mysql8 创建用户，并给用户增加权限命令

1. 使用root进入mysql

mysql -uroot -p123456

2 查看用户表

select host, user, plugin from mysql.user; 
// 返回如下 % 是主机地址，可远程  caching_sha2_password 是加密规则
+-----------+------------------+-----------------------+
| host      | user             | plugin                |
+-----------+------------------+-----------------------+
| %         | root             | caching_sha2_password |
| %         | z2               | mysql_native_password |
| %         | zhangsan         | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session    | caching_sha2_password |
| localhost | mysql.sys        | caching_sha2_password |
| localhost | root             | caching_sha2_password |
+-----------+------------------+-----------------------+

show databases;  // 查看数据库， 除test-v2 数据库，其余四个为 mysql 默认数据库，其中mysql.user表可以操作用户信息
+--------------------+
| Database           |
+--------------------+
| test-v2           |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

3. 创建新用户 and 修改用户密码\删除用户

// 创建用户 zhangsan 密码为123456
// 注意修改用户密码、主机也可以用此条命令
CREATE USER IF NOT EXISTS 'zangsan'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
// mysql 返回此行 表示命令成功
Query OK, 0 rows affected (0.17 sec) 

// 修改用户密码
alter user 'zhangsan'@'%' identified with caching_sha2_password by '110112';
// 删除用户没有引号
drop user zhangsan;

4. 增加用户权限

// 给用户 zhangsan 权限
grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, INDEX, 
ALTER,CREATE VIEW, SHOW VIEW,  EVENT, TRIGGER, CREATE TABLESPACE
ON *.* TO 'zhangsan'@'%';


-- 查看权限
show grants for zhangsan;

-- 收回用户zhangsan的所有权限
revoke all privileges on *.* from zhangsan;

var code = "2990acd3-900c-458b-8ca6-792d3359c0ca"