mysql> REVOKE all on *.* from root@'192.168.1.12';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
use mysql
select user,host,password from user;
revoke all on *.* from root@"%";
delete from user where user="root" and host='%';
grant select on *.* to root@'%' IDENTIFIED BY "123456";
阅读(972) | 评论(0) | 转发(0) |
