请注意版本为mysql8.0

创建用户

方式一

create user zephyr identified by '123123';

方式二

create user zephyr@localhost identified by '123123'

用户信息可以在mysql.user表中查询，例如

select user, host
from mysql.user;

效果：

注意：若不在创建用户时指定host，则默认host为%。

授予访问权限

授予zephyr访问数据库jdbc_learning的权限

grant select, insert, delete, update on jdbc_learning.* to zephyr@localhost;

注意：若host为%，则上述语句可改写为：

grant select, insert, delete, update on jdbc_learning.* to zephyr;

省略了@localhost，因为%指代所有host

注意：mysql8.0不支持以下写法：

grant select,insert,delete,update on jdbc_learning.* to zephyr@localhost identified by '123123';

会报错：

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by '123123'' at line 1