mysql命令最新

本文主要是介绍mysql命令最新，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

 

查看授权

mysql> select user,host from mysql.user;
+--------+------------+
| user   | host       |
+--------+------------+
| root   | %          |
| root   | 127.0.0.1  |
| rep    | 172.16.0.% |
| rep    | 172.16.1.% |
| root   | ::1        |
|        | localhost  |
| backup | localhost  |
| root   | localhost  |
|        | mcw01      |
| root   | mcw01      |
+--------+------------+
10 rows in set (0.07 sec)

mysql> show grants for rep@'172.16.0.%';
+-------------------------------------------------------------------------------------------------------------------------+
| Grants for rep@172.16.0.%                                                                                               |
+-------------------------------------------------------------------------------------------------------------------------+
| GRANT REPLICATION SLAVE ON *.* TO 'rep'@'172.16.0.%' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' |
+-------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

 

这篇关于mysql命令最新的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！