mac无法打开mysql_无法在Mac上启动Mysql

I'am not able to get Mysql running after installation using Brew. I'am using OS X El Capitan Version 10.11.3 and Mysql Server version 5.7.11. When I start the server I receive:

Starting MySQL.

ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hedis-MacBook-Pro.local.pid).

and this what I get in my err file:

2016-03-19T20:59:45.907542Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable

Does any one have got this before ?

Many thanks.

解决方案

I received this same error after updating homebrew.

To fix this I had to reset the owner of the mysql data dir, it was changed back to my userid after the update.

cd /usr/local/mysql

sudo chown -R _mysql data/

Assuming your mysql home dir is in /usr/local

After this a restart of the service worked

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

Starting MySQL

. SUCCESS!