報(bào)錯(cuò)信息

登陸數(shù)據(jù)庫(kù)報(bào)錯(cuò)：`

ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2 "No such file or directory")`

重啟服務(wù)報(bào)錯(cuò)：Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

查看服務(wù)狀態(tài)信息：`systemctl status mariadb.service

● mariadb.service - MariaDB 10.1 database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: failed (Result: exit-code) since Mon 2019-04-15 17:16:38 UTC; 4s ago

Process: 2864 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=1/FAILURE)

Process: 2841 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)

Apr 15 17:16:37 xiandian systemd[1]: Starting MariaDB 10.1 database server...

Apr 15 17:16:38 xiandian mysql-prepare-db-dir[2864]: Database MariaDB is not initialized, but the directory /var/lib/mysql is not empty...e done.

Apr 15 17:16:38 xiandian mysql-prepare-db-dir[2864]: Make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.

Apr 15 17:16:38 xiandian systemd[1]: mariadb.service: control process exited, code=exited status=1

Apr 15 17:16:38 xiandian systemd[1]: Failed to start MariaDB 10.1 database server.

Apr 15 17:16:38 xiandian systemd[1]: Unit mariadb.service entered failed state.

Apr 15 17:16:38 xiandian systemd[1]: mariadb.service failed.

Hint: Some lines were ellipsized, use -l to show in full.`

重啟服務(wù)日志報(bào)錯(cuò)信息：`Apr 15 17:16:21 xiandian mysql-prepare-db-dir: Database MariaDB is not initialized, but the directory /var/lib/mysql is not empty, so initialization cannot be done.

Apr 15 17:16:21 mysql-prepare-db-dir: Make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.

Apr 15 17:16:21 systemd: mariadb.service: control process exited, code=exited status=1

Apr 15 17:16:21 systemd: Failed to start MariaDB 10.1 database server.

Apr 15 17:16:21 systemd: Unit mariadb.service entered failed state.

Apr 15 17:16:21 systemd: mariadb.service failed.`

可以看到報(bào)錯(cuò)信息中提示數(shù)據(jù)庫(kù)未初始化，但/var/lib/mysql不為空，所以無(wú)法進(jìn)行初始化。

去看一下這個(gè)目錄權(quán)限

ll /var/lib/

d---------. 11 mysql mysql 4096 May 4 2018 mysql

mysql權(quán)限為0，導(dǎo)致啟動(dòng)文件sock文件無(wú)法寫(xiě)入進(jìn)去

重啟賦予目錄權(quán)限為755

chmod 755 /var/lib/mysql/然后再重啟一下mysql服務(wù)systemctl restart mariadb.serviceps -e | grep -i mysql3191 ? 00:00:02 mysqld正常啟動(dòng)

總結(jié)

以上是生活随笔為你收集整理的mysql启动报错2002_mysql登陆启动报错 ERROR 2002 (HY000) 解决方法的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。