MariaDB 10.4 版本以上修改用户密码

ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('123456');

flush privileges;

参考资料

https://mariadb.com/kb/en/alter-user/