- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
解决办法:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock;
- (ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2 “No such file or directory”))
解决办法:
ln -s /tmp/mysql.sock /var/run/mysqld/mysqld.sock
- 用户登陆后显示表不全,在启动时加上
--skip-grant-tables
参数
sudo ./bin/mysqld_safe --skip-grant-tables --user=mysql &