RHEL-Mysql5.7.18 安装之后无法登陆

1. Stop mysql:

systemctl stop mysqld

2. Set the mySQL environment option

systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"

3. Start mysql usig the options you just set

systemctl start mysqld

4. Login as root

mysql -u root

5. Update the root user password with these mysql commands

mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword')
    -> WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit

6. Stop mysql

systemctl stop mysqld

7. Unset the mySQL envitroment option so it starts normally next time

systemctl unset-environment MYSQLD_OPTS

8. Start mysql normally:

systemctl start mysqld

Try to login using your new password:

 mysql -u root -p

登陆之后出现如下错误

error1.png

出现这个错误，如果继续输入

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'

出现以下错误

image.png

出现这两个错误的原因是，mysql5.7+的 Password validation system即密码验证系统，如果你想用简单密码，就必须把密码验证系统关闭。

解决方法：

resolution.png resetpassword.png