MariaDB使用mysql.user时Insert操作报错：ERROR 1356 (HY000): View ‘mysql.user‘ references invalid table(s) or

操作报错MYSQL ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them解决：MariaDB [(none)]> grant all privileges o

爱美琪

7379人浏览 · 2022-05-12 17:48:08

爱美琪 · 2022-05-12 17:48:08 发布

操作报错MYSQL ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

解决：

MariaDB [(none)]> grant all privileges on *.* to 'root'@'%' identified by '123456qwer';
Query OK, 0 rows affected (0.005 sec)

MariaDB [(none)]> delete from mysql.user where User='';
Query OK, 2 rows affected (0.006 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)