Mysql 创建用户，赋予权限，查看权限，删除用户，修改密码

查看用户

select host,user from mysql.user;

+-----------+---------------+
| host      | user          |
+-----------+---------------+
| %         | root          |
| localhost | mysql.session |
| localhost | mysql.sys     |
+-----------+---------------+

---

创建用户并赋予权限

切记：赋予权限之后，记得 flush privileges

方式一：

# all 表示所有权限（包括增 删 改 查等权限）
# *.* 表示所有数据库
# root 为添加的用户名
# 123456 为密码
# % 为匹配的所有主机

# 创建用户
grant all on *.* to zanhu02@'%' identified by '123456' ;

# 刷新系统权限表
flush privileges; 

# 创建用户并指定数据库
grant all on test.* to lwy@'%' identified by '123456';

# 添加部分权限
grant select,update on *.* to zanhu02@'%' identified by '123456';

方式二：

# 创建数据表
create database zanhu02 charset utf8;

# 创建用户
create user 'zanhu02'@'%' identified by '123456';

# 赋予权限(数据库zanhu02,用户zanhu02)
grant all on zanhu02.* to 'zanhu02'@'%';

# 刷新系统权限表
flush privileges;

---

查看权限

show grants for zanhu02@'%';

+-----------------------------------------------------------+
| Grants for zanhu02@%                                      |
+-----------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zanhu02'@'%'                       |
| GRANT ALL PRIVILEGES ON `zanhu02`.* TO 'zanhu02'@'%'      |
| GRANT ALL PRIVILEGES ON `test_zanhu02`.* TO 'zanhu02'@'%' |
+-----------------------------------------------------------+

---

删除用户

delete from mysql.user where user =’root’ ;

flush privileges; (刷新系统权限表)

---

修改密码

mysqladmin -u用户名 -p旧密码 password 新密码 

# 或者进入mysql命令行
旧版本：SET PASSWORD FOR root=PASSWORD("root");
新版本：SET PASSWORD FOR '用户名'@'主机名' = '新密码';
eg:set password for 用户名@localhost = password('新密码');