MySQL 创建用户以及用户授权

创建用户

CREATE USER ch IDENTIFIED BY '123456';

授权

• 所有权限

GRANT ALL PRIVILEGES ON *.* TO 'ch'@'%' IDENTIFIED BY '123456';

给ch用户所有数据库权限，“%”的意思是允许所有机器远程连接该库

注意：GRANT ALL PRIVILEGES ON . TO 'ch'@'%' （这样是报错的）
ERROR 1133 (42000): Can't find any matching row in the user table

• 指定权限

GRANT SELECT, UPDATE, INSERT, DELETE ON test.* TO 'ch'@'192.168.1.168' IDENTIFIED BY '123456';

给ch用户test库的 CRUD 权限，并且只有 '192.168.1.168' 机器可以远程连接该库

运行 flush privileges

mysql> flush privileges;                                                                
Query OK, 0 rows affected (0.00 sec)

让修改生效