请注意版本为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