ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'

素颜马尾好姑娘i 2022-06-06 02:52 120阅读 0赞

今天服务器遇到了一个很熟悉的问题  
输入  
\#mysql -u root -p  
  
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock' (111)  
  
  
随即上网找寻答案  
  
根据大家提供的方法我逐一尝试  
  
方案1.  
1.\#ps -A|grep mysql  
显示类似：  
1829 ? 00:00:00 mysqld\_safe  
1876 ? 00:00:31 mysqld  
2.\#kill -9 1829  
3.\#kill -9 1876  
4.\#/etc/init.d/mysql restart  
5.\#mysql -u root -p  
  
他的麻烦解决了,我的还没解决!  
  
继续找  
方案2  
先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已经启动.  
另外看看是不是权限问题.  
\------------------------------------------------------------------------------------  
\[root@localhost beinan\]\#chown -R mysql:mysql /var/lib/mysql  
\[root@localhost beinan\]\# /etc/init.d/mysqld start  
启动 MySQL： \[ 确定 \]  
\[root@localhost lib\]\# mysqladmin -uroot password '123456'  
\[root@localhost lib\]\# mysql -uroot -p  
Enter password:  
Welcome to the MySQL monitor. Commands end with ; or /g.  
Your MySQL connection id is 3 to server version: 4.1.11  
  
  
Type 'help;' or '/h' for help. Type '/c' to clear the buffe  
  
他的也解决了,我的麻烦还在继续,依然继续寻找  
  
方案3  
问题解决了，竟然是max\_connections=1000 他说太多了，然后改成500也说多，无奈删之问题解决了。  
  
还是不行  
方案4  
  
/var/lib/mysql 所有文件权限 改成mysql.mysql  
  
不行不行  
  
方案5  
摘要：解决不能通过mysql .sock连接MySQL问题 这个问题主要提示是，不能通过 '/tmp/mysql .sock'连到服务器，而php标准配置正是用过'/tmp/mysql .sock'，但是一些mysql 安装方法 将 mysql .sock放在/var/lib/mysql .sock或者其他的什么地方，你可以通过修改/etc/my.cnf文件来修正它，打开文件，可以看到如下的东东：  
　　\[mysqld\]  
　　socket=/var/lib/mysql .sock  
　　改一下就好了，但也会引起其他的问题，如mysql 程序连不上了，再加一点：  
　　\[mysql\]  
　　socket=/tmp/mysql .sock  
　　或者还可以通过修改php.ini中的配置来使php用其他的mysql .sock来连，这个大家自己去找找  
　　注意是mysql不是mysqld  
　　或者用这样的方法:  
　　ln -s /var/lib/mysql /mysql .sock /tmp/mysql .sock  
成功了,就是这样ln -s /var/lib/mysql /mysql .sock /tmp/mysql .sock

OK!

\[root@iZ23h0vz72uZ ~\]\# service mysql stop  
Shutting down MySQL.... \[ OK \]  
\[root@iZ23h0vz72uZ ~\]\# service mysql start  
Starting MySQL. \[ OK \]  
\[root@iZ23h0vz72uZ ~\]\# mysql -uroot -p  
Enter password:  
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock' (111)  
\[root@iZ23h0vz72uZ ~\]\# more /etc/issue  
CentOS release 6.5 (Final)  
Kernel \\r on an \\m  
  
  
\[root@iZ23h0vz72uZ ~\]\# netstat -ntlp | grep 3306  
\[root@iZ23h0vz72uZ ~\]\# netstat -ntlp | grep 612345  
\[root@iZ23h0vz72uZ ~\]\# netstat -ntlp | grep 62345  
\[root@iZ23h0vz72uZ ~\]\# netstat -ntlp | grep 61234  
tcp 0 0 0.0.0.0:61234 0.0.0.0:\* LISTEN 1768/mysqld  
\[root@iZ23h0vz72uZ ~\]\# more /etc/my.cnf |grep sock  
socket=/mnt/mysql/mysql.sock  
\#socket=/usr/local/mysql/mysql.sock  
\[root@iZ23h0vz72uZ ~\]\# vi /etc/my.cnf  
  
  
socket = /tmp/mysql.sock  
\[mysql\]  
no-auto-rehash  
socket=/mnt/mysql/mysql.sock  
\[mysqld\]  
datadir=/mnt/mysql/data  
socket=/mnt/mysql/mysql.sock  
\#socket=/usr/local/mysql/mysql.sock  
user=mysql  
port=61234  
\# Disabling symbolic-links is recommended to prevent assorted security risks  
symbolic-links=0  
binlog\_format = mixed  
expire\_logs\_days = 15  
slow\_query\_log = 1  
long\_query\_time = 1  
slow\_query\_log\_file = /mnt/mysql/logs/mysql-slow.log  
log\_error = /mnt/mysql/logs/mysql-error.log  
server-id = 2  
log-bin = /mnt/mysql/logs/mysql-bin.log  
\#replicate-do-db=snatch\_web  
replicate-ignore-db=mysql  
innodb\_buffer\_pool\_size = 1000M  
  
  
group\_concat\_max\_len=4294967295  
max\_allowed\_packet=4294967295  
  
  
\[mysqld\_safe\]  
log-error=/mnt/mysql/logs/mysqld\_error.log  
pid-file=/mnt/mysqld/mysqld.pid  
  
"/etc/my.cnf" 29L, 739C written  
\[root@iZ23h0vz72uZ ~\]\# Zser^C  
\[root@iZ23h0vz72uZ ~\]\# service mysql stop  
Shutting down MySQL... \[ OK \]  
\[root@iZ23h0vz72uZ ~\]\# service mysql start  
Starting MySQL. \[ OK \]  
\[root@iZ23h0vz72uZ ~\]\# mysql  
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL报错'ERROR 2002 (HY000): Can't connect to local MySQL server through'

相关【mysql报错】ERROR 2002 (HY000) Can‘t connect to local MySQL server through socket ‘tmpmysql

相关【Linux_Mysql】ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var

相关 ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘

相关 ERROR 2002 (HY000): Can't connect to local MySQL server through socket

相关 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'

相关 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

相关 MySQL：ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/

相关 MySQL：ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘

相关 ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘