解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误

[root@centos6Desktop]# ps -ef |grep mysql

root       4635     1  0 15:36 pts/0    00:00:00 /bin/sh/usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql--pid-file=/var/lib/mysql/centos6.pid

mysql      4724  4635  0 15:36 pts/0    00:00:00 /usr/local/mysql/libexec/mysqld--basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql--log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos6.pid--socket=/var/lib/mysql/mysql.sock

root       4805  3480  0 15:44 pts/0    00:00:00 grep mysql

 

得知当前Mysql使用的socket文件的位置

 

然后在服务器的my.cnf中添加以下

[client]

port=3306

socket=/var/lib/mysql/mysql.sock

 

Servicemysqld restart

 

 

修改root密码

mysqladmin -u rootpassword "Oracle2016"

 

 

#########

【mysql version in mysql5.1.73】