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 😎

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.

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

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