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'
昨天还好好的,今天莫名就连不上,先用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'
mysql已经启动
底下是我打出的log日志
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.18-nt-log. started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
如果在3306段口TELNET失败的话。检查你的防火墙。
其他问题看精华帖子。
连不上服务器,精华贴在哪
mysqladmin: connect to server at 'localhost' failed
error: 'Host 'localhost' is not allowed to connect to this MySQL server'
快疯掉了,防火墙也关了,3306查了也有监听,就是登陆不上去,数据库中还有几个数据文件有用
你把服务卸掉,重装试试吧,只不过应该也没什么用的。
但是连root都登陆不上,所以我就莫名其妙,由于有项目要开发,没办法只能冲装数据库,还有数据在其他电脑上有,没有太大的损失.
谢谢大家
还想请问大家,如果发生类似数据库崩溃无救的时候,如何拯救原来的数据.我有试过把data里面的文件全部拷贝出来,放在新装的数据库中,好像所有表的值都没有,都是报***.数据库名 desn't exit; 我会发出新贴,希望大家指点