启动MYSQL提示:Can’t connect to MySQL through socket ‘/tmp
启动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 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 |
ok,mysqld可以启动了
接下来,是mysql启动不了,同样,vim /etc/my.cnf,添加了如下脚本:
[mysql]
代码如下 | |
socket=/var/lib/mysql/mysql.sock |
然后,mysqladmin启动不了,还是一样,在[mysqladmin]下面socket值设置为同样的路径
ok,可以启动了