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 😎

This definitely saved me! Thank you!

You have saved my thesis for master.

Thanks mate

I was struggling for 2 hours. Thanks a lot!!!

I love you it work just delete the logs here /Applications/XAMPP/xamppfiles/var/mysql if you use XAMPP because i found them also here /usr/local/var/mysql maybe a other old database in my personnal computer. Thanks you !!!!!

Great! it works, removing log files from the MySQL server path /opt/homebrew/var/mysql/ made it work for me.

Obrigado pela ajuda, consegui resolver.

Thank you!

many thanks!

Thank you Sir

Thank, You saved my time.

Had to delete ibdata1 as well

Had to delete ibdata1 as well

Do your existing databases still work? Mine are corrupt now...

ty very much !!

Thank you sir!!!!!!!!!

Thank you!

Had to delete ibdata1 as well

👆 Monterey M1 Pro -- didn't work until I did this as well.

I have been struggling with this issue from hours and this solution helped me.
Thanks a lot!

Thank you!

Had to delete ibdata1 as well

👆 Monterey M1 Pro -- didn't work until I did this as well.

DON'T DELETE ibdata1 if you want to keep your old databases. Ibdata has information about all your databases.
If you have done it already like me, then use TimeMachine to recover your old ibdata1 file.

That worked for me too, thank you.

perfect, thank you.

It works, thanks you sir!

In my macOS High Sierra (10.13.6) deleting the "tc.log" file from "/usr/local/var/mysql" did the job.

It worked for me too. Thanks!

Thanks!

I'm using Mac M1, macOS 13.0.1
for me the logfile was in /Users//data/mariadb folder

Had to delete ibdata1 as well

This worked for me as well. Just move it to the desktop, restart mariadb, then put it back. Seems to get the job done!

Thank's solution not running mysl database mac

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.