微博上看到的，惬意的图片，分享~
MySQL 用户操作：添加删除用户
一、创建用户
|
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"@"%" |
三、修改用户密码 [crayon-694ae190c4fd30 ... 阅读更多