创建用户并指定密码
create user 'username'@'%' identified by 'password';
授权(schemaName一般是库名,此例子是把库下的所有表授权给用户)
grant all on schemaName.* to 'username'@'%';
刷新缓存
flush privileges;
create user 'username'@'%' identified by 'password';
授权(schemaName一般是库名,此例子是把库下的所有表授权给用户)
grant all on schemaName.* to 'username'@'%';
刷新缓存
flush privileges;