mac os Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'

该错误是出现在mac os上，其他系统可以参考。

mac os每次系统升级都会发生一些很搞笑的事情。

这次升级导致mysql服务启动失败。

在偏好设计》mysql 打开的面板上会显示

mac os Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'

在终端上运行mysql会提示错误

 

811deMacBook-Pro:bin beiyaoyao$ mysql

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

千万不要根据终端报出来的错误去解决问题，要不百度坑死你。

根据mysql控制面板的错误大概就是说 /usr/local/mysql/data 该目录不被mysql 或 _mysql拥有吧。

不是很清楚mac os 更新做了什么。

直接在终端中输入

 

 sudo chown -R mysql /usr/local/mysql/data

然后再试一下mysql命令

 

811deMacBook-Pro:bin beiyaoyao$ mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.6.26 MySQL Community Server (GPL)

 

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> 

启动成功