Solution for MySQL / MariaDB Start Issue on MacOS

mysq-mariadb-macos-start-issue.md

Solution for MySQL / MariaDB Start Issue on MacOS

Errors

On trying to start mysql.server start

./usr/local/bin/mysql.server: line 264: kill: (12262) - No such process ERROR!

On trying to connect mysql -uroot

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Solution

• Stop MySQL / MariaDB.
• Go to /usr/local/var/mysql
• Delete ib_logfile0 & ib_logfile1 files.
• Try to start now, It should work 😎

None of the suggested solutions worked because I installed mariadb with homebrew. So, using brew services to start/stop actually works. brew services start mariadb
See here for more details.

/opt/homebrew/etc/my.cnf

Thanks, after spending a whole day - finally found it here - /opt/homebrew/var/mysql

thanks a lot, you save my day

After updating to macOS Sonoma 14 the connection with 127.0.0.1 was not working anymore (localhost was working correct).

I added this:

[mysqld]
bind-address = 127.0.0.1
skip-name-resolve = 1

at the bottom of /opt/homebrew/etc/my.cnf and ran the command brew services restart mariadb to fix it.

Thank you!! You are a lifesaver. this worked for me

/Applications/XAMPP/xamppfiles/var/mysql

Thank you. not been able to do anything for 3days

Excelent!! That fixed the problem for me. Thanks

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐