创建用户
1.创建用户
grant all privileges on `testdb`.* to 'test'@'%' identified by '123456'; #赋所有权限
grant select,update on databasename.* to username@hostname identified by 'password';#赋予部分权限
flush privileges;#刷新系统权限表
1.创建用户
grant all privileges on `testdb`.* to 'test'@'%' identified by '123456'; #赋所有权限
grant select,update on databasename.* to username@hostname identified by 'password';#赋予部分权限
flush privileges;#刷新系统权限表