CentOS 7 安装 Mysql 8.0 教程
2021/4/24 19:28:18
本文主要是介绍CentOS 7 安装 Mysql 8.0 教程,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
通用安装参考
(4条消息) CentOS 7 安装 Mysql 8.0 教程_danykk的博客-CSDN博客_centos安装mysql8.0
修复问题
Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
原因:账号密码安全等级的问题,可以修改安装登记,默认安装的账号安全等级是中等:即需要大小写,数字,符号的;
Fix - MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements - OSTechNix
irst we need to find the current password policy level. To do so, run the following command to show Password Validation Plugin system variables:
查看安全等级
mysql> SHOW VARIABLES LIKE 'validate_password%';
Sample output:
+--------------------------------------+--------+
| Variable_name | Value |
+--------------------------------------+--------+
| validate_password.check_user_name | ON |
| validate_password.dictionary_file | |
| validate_password.length | 8 |
| validate_password.mixed_case_count | 1 |
| validate_password.number_count | 1 |
| validate_password.policy | MEDIUM |
| validate_password.special_char_count | 1 |
+--------------------------------------+--------+
7 rows in set (0.09 sec)
修改安全等级
Change password validation policy
You can also solve the "ERROR 1819 (HY000)..." by setting up a lower level password policy.
To do so, run the following command from the mysql prompt:
mysql> SET GLOBAL validate_password.policy = 0;
Or,
mysql> SET GLOBAL validate_password.policy=LOW;
Now you can create a user with a weak password like below:
mysql> create user 'senthil'@'localhost' identified by 'password';
腾讯云服务器默认拦截3306的请求,需要腾讯云管理后台修改
Mysql 解决1251 client does not support ...问题
mysql客户端版本太低的问题
4、更改加密方式:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
5、更改密码:该例子中 123为新密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
6、刷新:
mysql> FLUSH PRIVILEGES;
这步完成后我已经成功解决了问题。
参考:
Fix - MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements - OSTechNix
(4条消息) Navicat连接mysql8.0.1版本出现1251--Client does not support authentication protocol requested by server的解决_若水2018的博客-CSDN博客
这篇关于CentOS 7 安装 Mysql 8.0 教程的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-29阿里 Canal 实时同步 MySQL 增量数据至 ClickHouse 数据库
- 2024-05-24在Linux下管理MySQL的大小写敏感性
- 2024-04-26MySQL查出时间比实际晚8小时的解决方案
- 2024-04-01JPA不识别MySQL的枚举类型
- 2024-03-30mysql数据库表卡死解决方法
- 2024-03-15MySQL多数据源笔记5-ShardingJDBC实战
- 2024-03-11natural join mysql
- 2024-03-11关于VS2017,VS2015 中利用 EF使用Mysql 不显示数据源问题解决方案
- 2024-02-26mysql 阿里云xb后缀备份文件恢复-icode9专业技术文章分享
- 2024-02-22docker mysql 5.7