1.找到debian-sys-maint用户和密码:vi /etc/mysql/debian.cnf如:
user = debian-sys-maint
password = hTRH5bAZXkyxvF4Y
2.登录mysql:
#mysql -udebian-sys-maint -phTRH5bAZXkyxvF4Y
3.修改密码:
mysql> use mysql;
mysql> update user set authentication_string=PASSWORD(“你要改的密码”) where User=‘root’;
mysql> update user set plugin=“mysql_native_password”
mysql> flush privileges;
mysql>exit;
4.重启mysl服务:
$/etc/init.d/mysql restart
5.使用新密码登录:
$mysql -uroot -p新密码