MySQL報(bào)錯(cuò)的解決'Can'tconnecttolocalMySQLserverthroughsocke

剛開始編譯安裝MySQL的時(shí)候，都弄完了以后總是出錯(cuò)，很是郁悶，而且這個(gè)問題我在幾個(gè)機(jī)器上都遇到過。今天查網(wǎng)絡(luò)，終于弄明白是怎

剛開始編譯安裝MySQL的時(shí)候，都弄完了以后總是出錯(cuò)，很是郁悶，而且這個(gè)問題我在幾個(gè)機(jī)器上都遇到過。今天查網(wǎng)絡(luò)，終于弄明白是怎么回事了，原來是權(quán)限設(shè)置不對，雖然是所有者權(quán)限了，但是忘記設(shè)置所屬組了。所以錯(cuò)在這里，望大家遇到童言的問題多檢查檢查，這么馬虎，用了這么長時(shí)間才弄好，慚愧啊

以下是操作記錄，從make install 完成以后開始記錄，同時(shí)后邊跟著一個(gè)網(wǎng)友的文章，，忘記出處了。先拿過來寫了。

==================

[root@localhost mysql]# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

[root@localhost mysql]# service mysqld restart這里說明mysqld并沒有啟動(dòng)，

MySQL manager or server PID file could not be found! [FAILED]

Starting MySQL/etc/init.d/mysqld: line 159: kill: (18977) - No such process

[FAILED]

[root@localhost mysql]# cd bin

[root@localhost bin]# ./mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) 這里就說了不能通過/tmp/mysql.sock連接數(shù)據(jù)庫。

[root@localhost bin]# cd /tmp 進(jìn)去檢查，看到有這個(gè)文件，所以看別的原因。

[root@localhost tmp]# ls

gconfd-root mapping-root mysql.sock mysql-test-ports mysql-test-ports.sem scim-panel-socket:0-root VMwareDnD vmware-root vmware.txt

[root@localhost tmp]# cd /usr/local/mysql/

[root@localhost mysql]# pwd

/usr/local/mysql

[root@localhost mysql]# chown -R root:mysql . 忽然想起來了沒有設(shè)置權(quán)限呢，開始設(shè)置權(quán)限

[root@localhost mysql]# ll

total 36

drwxr-xr-x 2 root mysql 4096 Nov 28 21:51 bin

drwxr-xr-x 3 root mysql 4096 Nov 28 21:50 include

drwxr-xr-x 2 root mysql 4096 Nov 28 21:50 info

drwxr-xr-x 3 root mysql 4096 Nov 28 21:50 lib

drwxr-xr-x 2 root mysql 4096 Nov 28 21:51 libexec

drwxr-xr-x 4 root mysql 4096 Nov 28 21:50 man

drwxr-xr-x 8 root mysql 4096 Nov 28 21:51 mysql-test

drwxr-xr-x 3 root mysql 4096 Nov 28 21:50 share

drwxr-xr-x 5 root mysql 4096 Nov 28 21:50 sql-bench

[root@localhost mysql]# chown -R mysql /var/lib/mysql

[root@localhost mysql]# cp share/mysql/my-huge.cnf /etc/my.cnf

[root@localhost mysql]# cp share/mysql/mysql.server /etc/rc.d/init.d/mysqld

[root@localhost mysql]# chmod 755 /etc/rc.d/init.d/mysqld

[root@localhost mysql]# chkconfig --add mysqld

[root@localhost mysql]# chkconfig --level 345 mysqld on

=======error========

[root@localhost mysql]# mysqladmin -u root password 'uplooking'

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'

Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! 又是上邊一樣的錯(cuò)誤

[root@localhost mysql]# bin/mysql start

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

[root@localhost mysql]# /etc/rc.d/init.d/mysqld status

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com