MYSQL进入客户端后切换服务器的简单做法试验-白红宇

今天发现有个\r 选项可以切换连接。不过功能比较单一。
connect (\r) Reconnect to the server. Optional arguments are db and host.
进入客户端后切换服务器连接的做法。
 只能是切换到和另外一个SERVER端口，用户名，密码都是一样的。
 原来SERVER：A。
 切换的SERVER：B。
B上的操作：
 mysql> grant usage,select on *.* to root@'%';
 Query OK, 0 rows affected (0.00 sec)
 mysql> flush privileges;
 Query OK, 0 rows affected (0.00 sec)
 mysql> status
--------------
/usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i686) using readline 5.0
 Connection id: 9
Current database: mysql
Current user: root@localhost
 SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
 Server version: 5.0.45-log MySQL Community Server (GPL)
 Protocol version: 10
 Connection: Localhost via UNIX socket
 Server characterset: utf8
 Db characterset: utf8
 Client characterset: utf8
 Conn. characterset: utf8
 UNIX socket: /tmp/mysql.sock
 Uptime: 3 days 6 hours 30 min 0 sec
 Threads: 1 Questions: 59 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.000
--------------
 mysql> show processlist;
+----+-------------+-----------+------+---------+--------+-----------------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------------+-----------+------+---------+--------+-----------------------------------------------------------------------+------------------+
| 2 | system user | | NULL | Connect | 282919 | Has read all relay log; waiting for the slave I/O thread to update it | NULL | 
| 9 | root | localhost | test | Query | 0 | NULL | show processlist | 
+----+-------------+-----------+------+---------+--------+-----------------------------------------------------------------------+------------------+
 2 rows in set (0.00 sec)
A上的操作：
 mysql> \r test 192.168.0.232
 Connection id: 23
Current database: test
 mysql> status
--------------
 mysql Ver 14.14 Distrib 5.1.22-rc, for redhat-linux-gnu (i686) using readline 5.0
 Connection id: 23
Current database: test
Current user: root@192.168.0.231
 SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
 Server version: 5.1.22-rc-log MySQL Community Server (GPL)
 Protocol version: 10
 Connection: 192.168.0.232 via TCP/IP
 Server characterset: utf8
 Db characterset: utf8
 Client characterset: utf8
 Conn. characterset: utf8
 TCP port: 3306
 Uptime: 3 days 6 hours 33 min 10 sec
 Threads: 2 Questions: 77 Slow queries: 1 Opens: 12 Flush tables: 1 Open tables: 9000 Queries per second avg: 0.000
--------------
 mysql> show processlist;
+----+------+---------------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+---------------------+------+---------+------+-------+------------------+
| 9 | root | localhost | test | Sleep | 25 | | NULL | 
| 23 | root | 192.168.0.231:34173 | test | Query | 0 | NULL | show processlist | 
+----+------+---------------------+------+---------+------+-------+------------------+
 2 rows in set (0.00 sec)
 mysql> 
连接后B上的操作：
 mysql> show processlist;
+----+-------------+---------------------+------+---------+--------+-----------------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------------+---------------------+------+---------+--------+-----------------------------------------------------------------------+------------------+
| 2 | system user | | NULL | Connect | 282869 | Has read all relay log; waiting for the slave I/O thread to update it | NULL | 
| 9 | root | localhost | test | Query | 0 | NULL | show processlist | 
| 23 | root | 192.168.0.231:34173 | test | Sleep | 69 | | NULL | 
+----+-------------+---------------------+------+---------+--------+-----------------------------------------------------------------------+------------------+
 3 rows in set (0.00 sec)
现在已经连接上了。
本文转自 david_yeung 51CTO博客，原文链接：http://blog.51cto.com/yueliangdao0608/81254，如需转载请自行联系原作者