Linux连接mysql提示Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)
Linux连接mysql提示Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
·
Linux连接mysql提示Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
解决方法:
1. 修改/etc/my.cnf中对应的socket地址
比如一开始设置的连接地址:
scoekt = /temp/smysql.sock
可将socket
地址修改为:socket = /usr/mysql/mysql.sock
如果这个不行,可设置为socket = /usr/mysql/mysqld.sock
2. 重启mysql
停止MySQL:service mysqld stop
启动MySQL:service mysqld start
3. 再次进行远连接
ln -s /usr/local/mysql/mysql/mysqld.sock /usr/local/mysql/mysql.sock
4. 重启MySQL
停止MySQL:service mysqld stop
启动MySQL:service mysqld start
更多推荐
所有评论(0)