mysql创建数据库以及分配用户权限

----创建用户
insert into mysql.user(Host,User,Password) values ("localhost","testUser",password("123"));
----刷新系统权限表
flush privileges;
----创建数据库
create database testdb；
----给用户all（所有）授权
grant all privileges on testdb.* to testUser@'%' identified by "123" flush privileges;
===========================================================================
--创建用户，赋予select,update权限
create database testdb；
create user learn@'%' identified by 'learn123';
grant select,update on testdb.* to learn@'%' identified by 'learn123' flush privileges;