linux數(shù)據(jù)庫(kù)登錄報(bào)錯(cuò):Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
錯(cuò)誤提示:
root@localhost ~]# mysql --socket=/tmp/mysql.sock
ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)
錯(cuò)誤出現(xiàn)在登錄數(shù)據(jù)庫(kù)時(shí)候
解決方法:
[root@localhost ~]# find / -name mysql.sock
/var/lib/mysql/mysql.sock
我們可以通過(guò)系統(tǒng)查找知道文件位置
由于mysql 默認(rèn)安裝時(shí)候的mysql.sock 是在/var/lib/mysql/mysql.sock,但linux系統(tǒng)總是去/tmp/mysql.sock查找,所以會(huì)報(bào)錯(cuò)。
那么我們就是到改如何處理了
1、指定到對(duì)應(yīng)位置
[root@localhost ~]# mysql --socket=/var/lib/mysql/mysql.sock
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 2 to server version: 5.0.22
Type help; or /h for help. Type /c to clear the buffer.
mysql>
這樣設(shè)置相當(dāng)于設(shè)置數(shù)據(jù)庫(kù)配置文件my.cnf,在里面添加一句socket = /tmp/mysql.sock
[root@SZDB mysqldata]# vi /etc/my.cnf
[mysql]
no-auto-rehash
socket = /tmp/mysql.sock #添加該行
#重啟mysql服務(wù)器
[root@SZDB mysqldata]# service mysqld start
Starting MySQL..[ OK ]
#再次連接正常
[root@SZDB mysqldata]# mysql -uroot -p
Enter password:
mysql> show variables like version;
+---------------+------------+
| Variable_name | Value |
+---------------+------------+
| version | 5.6.12-log |
+---------------+------------+
2. 創(chuàng)建符號(hào)連接:
為mysql.sock增加軟連接(相當(dāng)于windows中的快捷方式)。
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock