mysql的用户管理

 

 

 为mysql添加用户。请参考mysql的官方文档。 6.3.2 Adding User Accounts

 

写道

mysql> use mysql;
mysql> select * from user where user='kanpiaoxue'\G
-- 删除用户
mysql> DROP USER 'kanpiaoxue'@'%';
-- 创建用户
mysql> CREATE USER 'kanpiaoxue'@'%' IDENTIFIED BY '123456';
-- 授权
mysql> GRANT ALL PRIVILEGES ON *.* TO 'kanpiaoxue'@'%' WITH GRANT OPTION;
-- 刷新权限，立即生效
mysql> flush privileges;