剛安裝完mysql,，進(jìn)行運(yùn)行測(cè)試,，報(bào)Can't connect to local MySQL server through socket '/tmp/mysql.sock'錯(cuò)誤，

[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe
131206 22:42:51 mysqld_safe Logging to '/var/log/mysqld.log'.
131206 22:42:51 mysqld_safe Starting mysqld daemon with databases from /data/mysql/data
131206 22:42:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@localhost mysql]# /usr/local/mysql/bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

檢查一下mysql的運(yùn)行狀態(tài)
[root@localhost mysql]# ps -ef | grep mysql
root     32092  2108  0 22:43 pts/0    00:00:00 grep mysql

查看/tmp文件夾的確沒有mysql.sock文件,，

通過find命令查找

[root@localhost /]# find / -name mysql.sock
/var/lib/mysql/mysql.sock

原來安裝到/var/lib/mysql/mysql.sock這個(gè)位置啦,，我們需要修改my.cnf文件

[root@localhost /]# vi /usr/local/mysql/my.cnf

[client]
character-set-server = utf8
port    = 3306
socket  = /var/lib/mysql/mysql.sock
......

保存之后即出,，重新啟動(dòng)mysql,。

[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe &