mysql服務(wù)啟動卻連接不上的解決方法

2024-07-24 12:52:06

字體：大中小

供稿：網(wǎng)友

mysql服務(wù)啟動，但是連接不上，如何解決？

登陸報錯：

root@localhost:~# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) root@localhost:~# service mysqld restart Shutting down MySQL.. [ OK ] Starting MySQL. [ OK ] root@localhost:~# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

分析原因：

原因不詳，知道了補(bǔ)上

解決方案一：

root@localhost:~# find / -name mysql.sock /tmp/mysql.sock root@localhost:~# mysql -u root -p -S /tmp/mysql.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 1 Server version: 5.6.15-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '/h' for help. Type '/c' to clear the current input statement. mysql>

解決方案二：

root@localhost:~# find / -name mysql.sock /tmp/mysql.sock root@localhost:~# vi /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Default to using old password format for compatibility with mysql 3.x# clients (those using the mysqlclient10 compatibility package).old_passwords=1# Disabling symbolic-links is recommended to prevent assorted security risks;# to do so, uncomment this line:# symbolic-links=0# 加上下面的這段代碼即可[mysql]socket=/tmp/mysql.sock[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidroot@localhost:~# mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 3Server version: 5.6.15-log Source distributionCopyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql>

以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持錯新站長站。

您可能感興趣的文章:

利用Prometheus與Grafana對Mysql服務(wù)器的性能監(jiān)控詳解Mysql5.7服務(wù)無法啟動的圖文解決教程MySQL使用innobackupex備份連接服務(wù)器失敗的解決方法mysql運(yùn)行net start mysql報服務(wù)名無效的解決辦法MySQL使用show status查看MySQL服務(wù)器狀態(tài)信息mysql自動定時備份數(shù)據(jù)庫的最佳方法(windows服務(wù)器)查看linux服務(wù)器上mysql配置文件路徑的方法MySql服務(wù)未知原因消失解決方法

上一篇：MySQL 觸發(fā)器詳解及簡單實(shí)例

下一篇：mysql取得datetime類型的數(shù)據(jù),后面會跟個.0的實(shí)現(xiàn)方法