忘记密码 mysql forge root password

我是 linux(manjaro) mysql版本 15
1. stop mysql

sudo systemctl stop mysqld

再次登录确保已经关掉服务

2. 启动服务with the --skip-grant-tables option.

systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl restart mysqld

3.登录并修改密码

mysql -uroot
set password for 'root'@'localhost' = PASSWORD('newpass');

可能会出现类似错误
ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

这时候先不管继续执行下面的，命令

mysql>>> flush privileges;

然后再次执行步骤3

退出mysql
exit;

4. 重启mysql

sudo systemctl unset-environment MYSQLD_OPTS
sudo systemctl start mysqld

5. 使用密码测试