MariaDB修改root用户密码

执行

update user set `Password` = password(`123456`) where `User` =`root` and `Host`=`localhost`

报错

查询出错 (1356): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

执行

SET PASSWORD FOR 'root'@'%' = PASSWORD('123456');

重新登录。