mysql 用户 登陆 权限相关

GRANT all privileges ON mq.* TO ‘dog‘@‘localhost‘;

3. Delete FROM user Where User=‘test‘ and Host=‘localhost‘;

4. UPDATE user SET Password = PASSWORD(‘newpass‘) WHERE user = ‘root‘;

最后  flush privileges;

mysql 5.7密码安全策略

　　SHOW VARIABLES LIKE ‘validate_password%‘;

set global validate_password_length=4;

mysql 用户 登陆 权限相关

标签：variable   相关   class   glob   creat   length   grant   roo   create