在Linux安装MySQL有时候会出现[mysql]ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 这样的错误,具体解决办法如下:
- [root@www ~]# rm -rf /var/lib/mysql/*
- [root@www ~]# rm /var/lock/subsys/mysqld
- rm: remove regular empty file `/var/lock/subsys/mysqld'? y
- [root@www ~]# killall mysqld
- [root@www ~]# service mysqld start
- [root@www ~]# /etc/rc.d/init.d/mysqld status
- mysqld (pid 5457) is running...
- [root@r710-1 /]# mysql -u root
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- [root@r710-1 /]# vi /etc/my.cnf
- ##########添加如下内容:
- [client]
- socket=/var/lib/mysql/mysql.sock
- ##########保存退出后,
- ##########重启mysql
- [root@r710-1 /]# service mysqld restart
- Shutting down MySQL. [ OK ]
- Starting MySQL. [ OK ]
- [root@r710-1 /]# mysql -u root -p
- Enter password:
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- [root@r710-1 /]# mysql -u root
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 2
- Server version: 5.1.45 MySQL Community Server (GPL)
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpassword' WITH GRANT OPTION;
- Query OK, 0 rows affected (0.00 sec)
- mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'rootpassword' WITH GRANT OPTION;
- exit
- Bye
- [root@r710-1 /]# mysql -u root -p