创建用户并设置密码
create user user_name identified by 'password';
赋予用户权限(所有)
grant all on database_name.* to 'user_name'@'%';
赋予权限后,刷新权限
flush privileges;
创建用户并设置密码
create user user_name identified by 'password';
赋予用户权限(所有)
grant all on database_name.* to 'user_name'@'%';
赋予权限后,刷新权限
flush privileges;