mysql服務啟動卻連接不上兩種解決辦法

這篇文章主要為大家詳細介紹了mysql服務啟動卻連接不上的解決方法,具有一定的參考價值,感興趣的小伙伴們可以參考一下

mysql服務啟動,但是連接不上,如何解決?

登陸報錯:

  ??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)

分析原因:

原因不詳,知道了補上

解決方案一:

  ?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/mysql  socket=/var/lib/mysql/mysql.sock  user=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.log  pid-file=/var/run/mysqld/mysqld.pid    root@localhost:~#?mysql?-u?root?-p  Enter?password:  Welcome?to?the?MySQL?monitor.?Commands?end?with?;?or?g.  Your?MySQL?connection?id?is?3  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>

? 版權聲明
THE END
喜歡就支持一下吧
點贊6 分享