以前问过这个问题
http://bbs.csdn.net/topics/380185323
回答说slave 上revoke alter权限,但是要对哪个用户执行revoke呢?
mysql> show processlist;
+------+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------------+------------------+
| 906 | root | localhost | mysql | Query | 0 | NULL | show processlist |
| 1199 | system user | | NULL | Connect | 184 | Waiting for master to send event | NULL |
| 1200 | system user | | NULL | Connect | 1 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL |
+------+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------------+------------------+
3 rows in set (0.00 sec)
由此看来,执行binary log的是一个叫system user的账号,但mysql.user表中找不到这个账号。
具体要怎么做呢?谢谢
http://bbs.csdn.net/topics/380185323
回答说slave 上revoke alter权限,但是要对哪个用户执行revoke呢?
mysql> show processlist;
+------+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------------+------------------+
| 906 | root | localhost | mysql | Query | 0 | NULL | show processlist |
| 1199 | system user | | NULL | Connect | 184 | Waiting for master to send event | NULL |
| 1200 | system user | | NULL | Connect | 1 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL |
+------+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------------+------------------+
3 rows in set (0.00 sec)
由此看来,执行binary log的是一个叫system user的账号,但mysql.user表中找不到这个账号。
具体要怎么做呢?谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货