CODEWITHSUNDEEP
mysqlmacosshellosx-yosemite
emoleumassi
emoleumassi

Reputation: 5149

ERROR! The server quit without updating PID file (/usr/local/mysql/data/Mac.local.pid)

After install, run fine mysql and restart my mac, i get this error, when i call this command line:

sudo /usr/local/mysql/support-files/mysql.server start

Hier the error:

ERROR! The server quit without updating PID file (/usr/local/mysql/data/Mac.local.pid).

And when i try to connect me to mysql -u root -p, this error:

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

I try the solution in this link MySQL does not start when upgrading OSX to Yosemite or El Capitan, but nothing. I also try to change the owner of the mysql folder with:

sudo chown -R _mysql:_mysql /usr/local/mysql/

But nothing.

Any ideas?

Thank

Upvotes: 3

Views: 15361

Answers (2)

hushed_voice
hushed_voice

Reputation: 3608

I had to uninstall mysql

brew uninstall [email protected]

and reinstall again

brew install [email protected]

When I check my terminal I could see this warning

 [ERROR] --initialize specified but the data directory has files in it. Aborting.

then I had to do this

rm -rf /usr/local/var/mysql

and open my.cnf like this

nano /usr/local/etc/my.cnf

and remove this line mysqlx-bind-address = 127.0.0.1

then do the post-install like this

brew postinstall [email protected]

Which finally worked. I had wasted a whole day on this. Hope someone finds this useful.

Upvotes: 1

Muhammad Bilal
Muhammad Bilal

Reputation: 105

start your mysql in safe_mode.its working for me. hope it would work also for you

/usr/local/mysql/bin/mysqld_safe start

Upvotes: 4

Related Questions