|
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只可在本机上联,却不能远程联,为什么? |
|