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';
网友评论