1. 关闭服务
systemctl stop mysqld
2. 关闭认证表认证和远程连接
mysqld_safe --skip-grant-tables --skip-networking &
3. 数据库修改密码
Master [[(none)]]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
Master [[(none)]]> alter user root@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec
#maridb 5.5 下面语句有效
update mysql.user set password=password('root') where user='root' and host='localhost';