Linux中安装、使用mysql遇到的问题:
问题一:
The GPG keys listed for the "MySQL 5.7 Community Server" repository
are already installed but they a.....
原因: MySQL GPG 密钥已过期
解决方法:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
问题二:
You must reset your password using ALTER USER statement before executing this statement.
OR
Your password does not satisfy the current policy requirements
原因: 第一次修改密码or密码修改的太简单了,而导致触发了Mysql的一个策略
解决方法:
mysql> set global validate_password_policy=low; //密码级别改为弱
mysql> set global validate_password_length=6; //密码长度改为6
mysql> alter user USER() identified by '123456'; //改密码为123456