请教一下mysql服务器无法远程登录的问题

为当前最终发行版之前的所有版本提供支持
回复
头像
QCH_520
帖子: 10
注册时间: 2006-10-14 6:05
送出感谢: 0
接收感谢: 0

请教一下mysql服务器无法远程登录的问题

#1

帖子 QCH_520 » 2006-11-01 11:30

我安装了一个mysql server 5.0
本地可以登录:

root@QCH:/home# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-Debian_0ubuntu6.06.2-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


我的主机的IP是192.168.1.178


root@QCH:/home# mysql -h192.168.1.178 -uroot -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.178' (111)


我的user表的设置如下

| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections |
+-----------+------------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
| localhost | root | 708513c20e3b78a6 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| % | root | 708513c20e3b78a6 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
| localhost | debian-sys-maint | 5efce0a23a2f2fa3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 |


请教各位,这是什么原因造成的,如何改啊,知道的告诉我一下,谢谢!
回复

回到 “老旧版本支持”