mysql连不上,大家帮忙
ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
昨天还好好的,今天莫名就连不上,先用mysql-font再直接用命令连,都连不上,服务也重起了N次了,试着操作手册上的命令也没什么效果,不知道为什么,我不想重装MYSQL,里面有很多数据,各位帮忙下了,实在不行就教偶如何完整的把里面的数据给搞出来
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -h 'localhost' version va
riables
mysqladmin: connect to server at ''localhost'' failed
error: 'Unknown MySQL server host ''localhost'' (11001)'
Check that mysqld is running on 'localhost' and that the port is 3306.
You can check this by doing 'telnet 'localhost' 3306'
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -h 'localhost' --port=330
6 version
mysqladmin: connect to server at ''localhost'' failed
error: 'Unknown MySQL server host ''localhost'' (11001)'
Check that mysqld is running on 'localhost' and that the port is 3306.
You can check this by doing 'telnet 'localhost' 3306'
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -h '192.168.1.87' --port=
3306 version
mysqladmin: connect to server at ''192.168.1.87'' failed
error: 'Unknown MySQL server host ''192.168.1.87'' (11001)'
Check that mysqld is running on '192.168.1.87' and that the port is 3306.
You can check this by doing 'telnet '192.168.1.87' 3306'
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -h 'ip for your host' ver
sion
mysqladmin: connect to server at ''ip' failed
error: 'Unknown MySQL server host ''ip' (11001)'
Check that mysqld is running on 'ip and that the port is 3306.
You can check this by doing 'telnet 'ip 3306'
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin --socket=/tmp/mysql.sock
version
mysqladmin: connect to server at 'localhost' failed
error: 'Host 'localhost' is not allowed to connect to this MySQL server'
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -h hostname version
mysqladmin: connect to server at 'hostname' failed
error: 'Unknown MySQL server host 'hostname' (11001)'
Check that mysqld is running on hostname and that the port is 3306.
You can check this by doing 'telnet hostname 3306'