时光轴网站,摄影网站的模板,营销型网站架构,制作高端网站公司排名今天发现有个\r 选项可以切换连接。不过功能比较单一。connect (\r) Reconnect to the server. Optional arguments are db and host.进入客户端后切换服务器连接的做法。只能是切换到和另外一个SERVER端口#xff0c;用户名#xff0c;密码都是一样的。原来SERVER#xf… 今天发现有个\r 选项可以切换连接。不过功能比较单一。connect (\r) Reconnect to the server. Optional arguments are db and host.进入客户端后切换服务器连接的做法。只能是切换到和另外一个SERVER端口用户名密码都是一样的。原来SERVERA。切换的SERVERB。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.0Connection id: 9Current database: mysqlCurrent user: rootlocalhostSSL: Not in useCurrent pager: stdoutUsing outfile: Using delimiter: ;Server version: 5.0.45-log MySQL Community Server (GPL)Protocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8Db characterset: utf8Client characterset: utf8Conn. characterset: utf8UNIX socket: /tmp/mysql.sockUptime: 3 days 6 hours 30 min 0 secThreads: 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.232Connection id: 23Current database: testmysql status--------------mysql Ver 14.14 Distrib 5.1.22-rc, for redhat-linux-gnu (i686) using readline 5.0Connection id: 23Current database: testCurrent user: root192.168.0.231SSL: Not in useCurrent pager: stdoutUsing outfile: Using delimiter: ;Server version: 5.1.22-rc-log MySQL Community Server (GPL)Protocol version: 10Connection: 192.168.0.232 via TCP/IPServer characterset: utf8Db characterset: utf8Client characterset: utf8Conn. characterset: utf8TCP port: 3306Uptime: 3 days 6 hours 33 min 10 secThreads: 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)现在已经连接上了。 转载于:https://blog.51cto.com/yueliangdao0608/81254
