MariaDB 10.1.20或更新的版本修改root密码

修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
flush privileges;

允许root用户远端访问数据库

use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'new_password'; // new_password为你设置的root访问密码
flush privileges;

使用以下命令可查看是否修改成功

select user,authentication_string,Host from user;