問題描述:在終端中輸入mysql出現(xiàn):?ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")

根據(jù)錯誤提示知道是沒有啟動mysql服務(wù)器,于是立馬在終端中輸入mysqld命令啟動mysql服務(wù)器,然而又在次報(bào)錯:

2017-05-31 10:54:51 139998512155840 [Note] mysqld (mysqld 10.1.23-MariaDB) starting as process 3154 ...

2017-05-31 10:54:51 139998512155840 [Warning] Can't create test file /var/lib/mysql/zihao-pc.lower-test

mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13 "Permission denied")

2017-05-31 10:54:51 139998512155840 [ERROR] Aborting

看這錯誤提示猜測可能是/var/lib/mysql?文件權(quán)限不正確,于是?ls -l /var/lib?查看權(quán)限為:drwx------果斷改為:drwxrwxrwx?,然后再次執(zhí)行mysqld命令又出新錯誤:

2017-05-31 10:58:36 140654622538944 [ERROR] Can't start server : Bind on unix socket: Permission denied

2017-05-31 10:58:36 140654622538944 [ERROR] Do you already have another mysqld server running on socket: /run/mysqld/mysqld.sock ?

2017-05-31 10:58:36 140654622538944 [ERROR] Aborting

錯誤原因和上個步驟類似,這次將/run/mysqld?目錄權(quán)限更改為:drwxrwxrwx,然后再次執(zhí)行mysqld完美運(yùn)行!