LinuxSir.cn,穿越时空的Linuxsir!

 找回密码
 注册
搜索
热搜: shell linux mysql
查看: 765|回复: 0

我只能远程联winNT下的MYSQL,无法联Redhat下的MYSQL,为什么?!

[复制链接]
发表于 2003-8-1 09:44:43 | 显示全部楼层 |阅读模式
1.远程联winNT下的MYSQL3.23.47-nt
[net@hsa1b ~]$ mysql -u root -p mysql -h 192.168.2.1
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 134 to server version: 3.23.47-nt

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

mysql> status
--------------
mysql  Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)

Connection id:          134
Current database:       mysql
Current user:           root@HSA1B
Current pager:          stdout
Using outfile:          ''
Server version:         3.23.47-nt
Protocol version:       10
Connection:             192.168.2.1 via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 21 days 18 hours 41 min 26 sec

Threads: 10  Questions: 21518805  Slow queries: 4  Opens: 11326  Flush tables: 1
  Open tables: 15 Queries per second avg: 11.436
--------------
2.远程联Redhat8下的MYSQL3.23.56
mysql>
[net@hsa1b ~]$ mysql -u monty -p mysql -h 192.168.2.98
Enter password:
ERROR 2013: Lost connection to MySQL server during query

3.在Redhat8主机上联自己的MYSQL却可以
[root@red1 bin]# ./mysql -u monty -p mysql -h 192.168.2.98
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.56

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

mysql> status
--------------
./mysql  Ver 11.18 Distrib 3.23.56, for pc-linux (i686)

Connection id:          2
Current database:       mysql
Current user:           monty@red1
Current pager:          stdout
Using outfile:          ''
Server version:         3.23.56
Protocol version:       10
Connection:             192.168.2.98 via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 24 sec

Threads: 1  Questions: 38  Slow queries: 0  Opens: 40  Flush tables: 1  Open tables: 34 Queries per
second avg: 1.583
--------------

mysql>

我的REDHAT8下的MYSQL只可在本机上联,却不能远程联,为什么?
您需要登录后才可以回帖 登录 | 注册

本版积分规则

快速回复 返回顶部 返回列表