命令行登陆mysqlmysql -u root -p
修改密码:1、use mysql;
2、UPDATE user SET authentication_string=PASSWORD("new password") WHERE user='username';//mysql版本5.7之后用此方法
UPDATE user SET password=PASSWORD("new password") WHERE user='username';//mysql版本5.7之前用此方法
3、FLUSH PRIVILEGES;//刷新系统权限表
4、quit;//重启mysql
登陆mysql:
(mysql.sock文件根据自己实际路径)mysql -u root -p -S /tmp/mysql.sock
如果提示:
You must reset your password using ALTER USER statement before executing this statement.
请按以下步骤操作即可:1、SET PASSWORD = PASSWORD('new password');
2、ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
3、flush privileges;