本文章来给大家介绍在启动MYSQL时突然启动不了,查看日志发现提示:Can’t connect to MySQL through socket ‘/tmp/mysql.sock’,后来百度了两种解决办法,有需要的朋友可参考。
启动MYSQL是出现以下错误:
- [root@www ~]# /usr/local/webserver/mysql/bin/mysqladmin -u root -p 12345678
-
- Enter password:/usr/local/webserver/mysql/bin/mysqladmin: connect to server at ‘localhost’ failed
-
- error: ‘Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111)’
-
- Check that mysqld is running and that the socket: ‘/tmp/mysql.sock’ exists!
解决方法,代码如下:
- [root@www ~]# /usr/local/webserver/mysql/bin/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 3
- Server version: 5.1.38-log Source distribution
-
- Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
-
- mysql>
mysql的参数说明:/usr/local/webserver/mysql/bin/mysql –help | less
列举常用参数:
-u,–user=name User for login if not current user.
-p,–password[=name]
Password to use when connecting to server. If password is not given it’s asked from the tty.
-S,–socket=name Socket file to use for connection.
另一种解决办法,我通过vim /etc/my.cnf,修改了[mysqld]选项下面的socket的值,代码如下:
socket=/var/lib/mysql/mysql.sock
mysqld可以启动了,接下来,是mysql启动不了,同样,vim /etc/my.cnf,添加了如下脚本:
- [mysql]
- socket=/var/lib/mysql/mysql.sock
然后,mysqladmin启动不了,还是一样,在[mysqladmin]下面socket值设置为同样的路径,可以启动了. |