- 2万+
- 积分
- 1万+
- 粉丝
- 1594
- 获赞
- 401
- 评论
- 6857
- 收藏
MySQL修改root用户密码
Will_wang_: ALTER USER USER() IDENTIFIED BY 'new_password';
罄竹_: 方式一不成功可以试下新密码用双引号
可爱姗姗33: 真的是完美解决问题,方法完全有效
颖颖怪: 第五步,第三行的单双引号有问题吗? grant all privileges on *.* to "root"@'localhost';
颖颖怪: 我描述不正确,按照ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; alter user 'root'@'localhost' identified by '123456'; grant all privileges on *.* to "root"@'localhost'; flush privileges;按照这个执行报错,把localhost改为% 就不报错了