mysql问题 - pod4g/tool GitHub Wiki

  1. mysql -u root

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

报这个错，因为mysql没有启动

启动：

mysql.server start

## 启动失败
Starting MySQL
./usr/local/Cellar/mysql/5.7.16/bin/mysqld_safe: line 135: /usr/local/var/mysql/xxx-Pro-2.local.err: Permission denied
/usr/local/Cellar/mysql/5.7.16/bin/mysqld_safe: line 169: /usr/local/var/mysql/xxx-Pro-2.local.err: Permission denied
/usr/local/Cellar/mysql/5.7.16/bin/mysqld_safe: line 135: /usr/local/var/mysql/xxx-Pro-2.local.err: Permission denied
 ERROR! The server quit without updating PID file (/usr/local/var/mysql/xxx-Pro-2.local.pid).

权限问题？

加sudo 再来一次

sudo mysql.server start

## 启动失败
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/xxx-Pro-2.local.pid).

从网上看到了这个：https://blog.csdn.net/wn5231/article/details/107263163/

尝试一下：


cd /usr/local/var/mysql
sudo chown -R _mysql /usr/local/var/mysql
sudo mysql.server start

# 启动成功
Starting MySQL
. SUCCESS!

#登录
mysql -u root -p
Enter password:
# 输入密码，登录成功