Mysql8 创建用户并授权

 1-- 删除用户
 2drop user 'jygz'@'%';
 3
 4-- 创建用户，并指定密码
 5CREATE USER 'jygz'@'%' IDENTIFIED BY 'Copote128!@*';
 6
 7-- 创建用户，并指定密码（指定密码生成方式），mysql8 默认使用 caching_sha2_password
 8CREATE USER 'jygz'@'%' identified with mysql_native_password by 'Copote128!@*';
 9
10-- 创建用户（使用随机密码，8.0.18版本后新增）
11create user 'fanderchan'@'%' IDENTIFIED BY RANDOM PASSWORD;
12+------------+------+----------------------+
13| user       | host | generated password   |
14+------------+------+----------------------+
15| fanderchan | %    | YMeIblT.jRciKLWkB0RL |
16+------------+------+----------------------+
171 row in set (0.01 sec)
18
19-- 修改密码
20alter user 'jygz'@'%' identified with mysql_native_password by '123456';
21
22-- 修改密码（使用随机密码，8.0.18版本后新增）
23ALTER USER 'fanderchan'@'%' IDENTIFIED BY RANDOM PASSWORD;
24+------------+------+----------------------+
25| user       | host | generated password   |
26+------------+------+----------------------+
27| fanderchan | %    | !bnMk/Lu4C87VMOdXQh. |
28+------------+------+----------------------+
291 row in set (0.01 sec)
30
31-- 修改密码（使用随机密码，8.0.18版本后新增）
32SET PASSWORD FOR 'fanderchan'@'%' TO RANDOM;
33+------------+------+----------------------+
34| user       | host | generated password   |
35+------------+------+----------------------+
36| fanderchan | %    | dCdJT5h9[Gm/dsC.aVHm |
37+------------+------+----------------------+
381 row in set (0.01 sec)
39
40-- 为用户授权数据库的所有权限（谨慎使用）
41GRANT ALL PRIVILEGES ON *.* TO 'jygz'@'%';
42
43-- 为用户授权某个数据库的权限
44GRANT ALL PRIVILEGES ON jygz.* TO 'jygz'@'%' with grant option;
45
46flush privileges;