MySQL无法登陆

1.Mysql忘记密码登录,或者密码登不上.

https://www.cnblogs.com/zhengchuzhou/p/9858907.html

可解决其他用户远程Access Dely
以及Root用户本地不能登录

2.用可以登录的 root 正常密码登录为别人授权

GRANT ALL ON *.* TO '用户'@'%';

3.Linux安装完mysql , 无法改密

You must reset your password using ALTER USER statement before executing
密码等级不够

grep "password" /var/log/mysqld.log  rpm安装这样可以找到临时密码
mysql -uroot -p  粘贴密码

Your password does not satisfy the current policy requirements
进去之后是无法修改密码,需要修改密码等级设定

mysql>set global validate_password_policy=0;
mysql>set global validate_password_length=1;
mysql> ALTER USER USER() IDENTIFIED BY 'Xiaoming250';