启动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!

解决方法：

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的值

ok，mysqld可以启动了

接下来，是mysql启动不了，同样，vim /etc/my.cnf,添加了如下脚本：

[mysql]

然后，mysqladmin启动不了，还是一样，在[mysqladmin]下面socket值设置为同样的路径
ok,可以启动了