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

直接报了下面的错误

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

mac可以在设置里面启动mysql，设置里面启动mysql的时候提示没有/usr/local/mysql/data的权限，

给予权限

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

发现还是没用，但是发现mysql当时是配置了链接

qiweijieMacBook-Pro:~ qiweijie$ ll /usr/local/mysql

lrwxr-xr-x  1 _mysql  _mysql  27  2 26  2016 /usr/local/mysql -> mysql-5.7.11-osx10.9-x86_64

虽然给了mysql权限，还是只是给到了链接的权限，没有得到真正的mysql目录的权限

qiweijieMacBook-Pro:~ qiweijie$ ll /usr/local/mysql-<span style="color: #800080">5.7</span>.<span style="color: #800080">11</span>-osx10.<span style="color: #800080">9</span>-x86_64/<span style="color: #000000">

total </span><span style="color: #800080">48</span><span style="color: #000000">
...
drwxr</span>-x---  <span style="color: #800080">16</span> qiweijie  staff    <span style="color: #800080">544</span> <span style="color: #800080">10</span>  <span style="color: #800080">7</span> <span style="color: #800080">12</span>:<span style="color: #800080">18</span><span style="color: #000000"> data
....</span>

sudo chown -R mysql:mysql  /usr/local/mysql-5.7.11-osx10.9-x86_64/

这样就好了

 

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

标签：mysql   err   5.7   bsp   ...   没有   chown   error   osx   

本文系统来源：http://www.cnblogs.com/qwj-sysu/p/6003205.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！