在linux上安装完mysql,然后也正常启动了。但是修改root密码的时候报错了:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
解决办法:
linux 中 /etc下面编辑 vim my.cnf
[client]
default-character-set=utf8
#添加这里
socket=/var/lib/mysql/mysql.sock
[mysqld]
datadir=/var/lib/mysql
#保持一致
socket=/var/lib/mysql/mysql.sock
先把启动的mysql服务都停止掉:ps -ef|grep mysql 查找出所有关于mysql的进程,都 kill 掉
[root@iZ2]# ps -ef|grep mysql
root 2277 1 0 19:11 pts/2 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --
mysql 2446 2277 0 19:11 pts/2 00:00:00 /usr/local/mysql/bin/mysqld --
root 2484 1227 0 19:22 pts/2 00:00:00 grep --color=auto mysql
结束进程
[root@iZ2]# kill -9 2277 2446
重启mysql: service mysql start