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
·
操作报错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)
华为开发者空间，是为全球开发者打造的专属开发空间，汇聚了华为优质开发资源及工具，致力于让每一位开发者拥有一台云主机，基于华为根生态开发、创新。
更多推荐
0
0- 0
已为社区贡献5条内容
所有评论(0)