![d9f049488b441967e9abc8b3a091e8f7.png](https://i-blog.csdnimg.cn/blog_migrate/c2ddc5d7cab7b85a7f4c5b43ac8087d7.jpeg)
私信我或关注微信号:猿来如此呀,回复:学习,获取免费学习资源包。
1. 启动MySQL服务
sudo systemctl start mysqld (linux);sudo /usr/local/MySQL/support-files/mysql.server start (mac)
2. 停止MySQL服务
sudo systemctl stop mysqld (linux)sudo /usr/local/mysql/support-files/mysql.server stop(mac)
3. 重启MySQL服务
sudo systemctl restart mysqld(linux)sudo /usr/local/mysql/support-files/mysql.server restart
4. 跳过登陆方式启动并进入mysql
sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking
5. 修改密码
mysql -uroot -p;use mysql;ALTER USER 'username'@'host' IDENTIFIED BY 'password';ALTER USER 'username'@'host' IDENTIFIED WITH mysql_native_password BY 'password';
6. 新增用户
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
7. 授权
GRANT all privileges ON databasename.tablename TO 'username'@'host';
8. 创建用户同时授权
GRANT all privileges ON databasename.tablename TO 'username'@'host' identified by 'password';
9. 撤销授权
REVOKE privilege ON databasename.tablename FROM 'username'@'host';
10. 删除用户
DROP USER 'username'@'host';
11. 查看用户的授权
show grants for 'username'@'host';
12. 刷新权限
flush privileges;
13. 查看mysql的密码策略
SHOW VARIABLES LIKE 'validate_password%';SET GLOBAL validate_password_policy=LOW;
14. mysql密码策略相关参数;
1. validate_password_length 固定密码的总长度2. validate_password_dictionary_file 指定密码验证的文件路径3. validate_password_mixed_case_count 整个密码中至少要包含大/小写字母的总个数4. validate_password_number_count 整个密码中至少要包含阿拉伯数字的个数5. validate_password_policy 指定密码的强度验证等级,默认为 MEDIU validate_password_policy的取值: `0/LOW`:只验证长度; `1/MEDIUM`:验证长度、数字、大小写、特殊字符; `2/STRONG`:验证长度、数字、大小写、特殊字符、字典文件; 6. `validate_password_special_char_count` 整个密码中至少要包含特殊字符的个数;
来源网络,侵权联系删除
私信我或关注微信号:猿来如此呀,回复:学习,获取免费学习资源包。