Mysql创建用户并且限制权限

134 阅读1分钟
set global validate_password_policy=LOW; 
set global validate_password_length=6; 
CREATE USER 'czauth_data_write'@'mysql服务器地址' IDENTIFIED BY '密码'; 
grant all privileges on 库名.表名 TO '用户'@'%' identified by "密码";