...可重新登录输入123456还报错MYSQL的密码问题:
发布网友
发布时间：2022-04-23 06:49
共2个回答
热心网友
时间：2022-05-02 16:19
MySQL>update user set password=password(‘123456’) where user=’root’;
2、set修改mysql的Hash密码
MySQL>SET PASSWORD FOR ‘root′@’localhost’ = PASSWORD('123456’);
3、用mysqladmin命令修改密码
Shell> mysqladmin -uroot -poldpassword password 123456;
4、用grant修改或create user时设置密码
MySQL>grant all privileges on db01.* to user01@”localhost” Identified by “newpassword”;
MySQL>CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpass';
热心网友
时间：2022-05-02 17:37
