一、创建用户
|
1 |
create user "user"@"host" identified by "123456" |
查询当前用户：
|
1 2 3 4 5 6 7 |
mysql> select user, host from user; +------+-----------+ | user | host | +------+-----------+ | root | 127.0.0.1 | +------+-----------+ 8 rows in set (0.00 sec) |
二、授权
|
1 2 3 4 |
grant [privileges] on db.table to "user"@"host" // 授予用户所有权限 grant all privileges on *.* to "maqian"@"%" |
三、修改用户密码
|
1 2 3 4 |
-- 当前用户 set password = password("123456") -- 非当前用户 set password for "user"@"host" = password("123456") |
四、取消授权
|
1 |
revoke [privilege] on db.table from "user"@"host" |
五、删除用户
|
1 |
drop user "user"@"localhost" |