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

Question

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

try this and post the output sudo /usr/local/mysql/bin/mysqld — Bernd Buffen, Aug 26 '15 at 18:37
possible duplicate of [MySql server startup error 'The server quit without updating PID file '](http://stackoverflow.com/questions/4963171/mysql-server-startup-error-the-server-quit-without-updating-pid-file) — Ken White, Aug 26 '15 at 18:38
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.26) starting as process 7527 ... 7527 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.6.26-osx10.8-x86_64/data/ is case insensitive 7527 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 7527 [ERROR] Aborting 7527 [Note] Binlog end 7527 [Note] /usr/local/mysql/bin/mysqld: Shutdown — emoleumassi, Aug 26 '15 at 18:55
@BK435 i am not a mac profit. Where is the location of the error log? in my /var/log/ is no mysql.log file — emoleumassi, Aug 26 '15 at 18:57

score 4 · Answer 1 · answered Jan 15 '16 at 19:20

4

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

/usr/local/mysql/bin/mysqld_safe start

answered Jan 15 '16 at 19:20

Muhammad Bilal

score 1 · Answer 2 · answered Jun 10 '21 at 06:25

I had to uninstall mysql

brew uninstall mysql@5.7

and reinstall again

brew install mysql@5.7

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 mysql@5.7

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

2 Answers2