ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s)

Database changed
MariaDB [mysql]> UPDATE user SET plugin=’ ’ WHERE user =‘root’;
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 [mysql]> UPDATE user SET plugin=’ ’ WHERE user =‘harsha’;
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 [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.000 sec)

Can you explain what you are trying to achieve?

I think this is a securization procedure after installing mariadb, but no longer works on recent mariadb versions.

Try mysql_secure_installation instead. This setup the database engine properly.

Hope this helps.

Hi.,

I am basically installing erpnext setup on ubuntu and mariDB.