创建一个具有超级用户权利的用户

GRANT ALL ON *.* TO anyname@localhost IDENTIFIED BY "passwd" WITH GRANT OPTION;


数据库级权限用一个ON db_name.*子句而不是ON *.*进行授权：

GRANT ALL ON xy_db_activity TO boris@localhost IDENTIFIED BY "boris";


如果你为一个数据库授权，如果需要在mysql.db表中创建一个条目。

GRANT ALL ON xy_db_config TO kite@localhost IDENTIFIED BY "ruby";


当所有为数据库的授权用REVOKE删除时，这个条目被删除。

REVOKE ALL ON xy_db_config FROM kite@localhost;



授权java用户192.168.1.99ip所有权限

mysql> select * from user;
mysql> GRANT ALL ON *.* TO java@'192.168.1.99' IDENTIFIED BY "java" WITH GRANT OPTION;
GRANT ALL ON *.* TO java@'192.168.1.31' IDENTIFIED BY "java" ;
SHOW GRANTS;
FLUSH PRIVILEGES;


查看用户授权信息

SHOW GRANTS FOR java@'192.168.1.32';


123012156.png



mysql> grant all on *.* to root@'%' identified by "123456";
Query OK, 0 rows affected (0.00 sec)



淘宝小店-运维学习参考资料

http://shop62632578.taobao.com