MySQL報錯的解決'Can'tconnecttolocalMySQLserverthroughsocke

剛開始編譯安裝MySQL的時候，都弄完了以后總是出錯，很是郁悶，而且這個問題我在幾個機器上都遇到過。今天查網絡，終于弄明白是怎

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

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

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

[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并沒有啟動，

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連接數據庫。

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

[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 . 忽然想起來了沒有設置權限呢，開始設置權限

[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! 又是上邊一樣的錯誤

[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

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