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

by

MariaDB-10.4+ the mysql.user is a view rather than a table.

Its recommend to stop copying off old blogs to do any authentication relates changes in MySQL and MariaDB, the mechanisms are being updated and no longer apply. Always check the official documentation.

Use SET PASSWORD or ALTER USER to manage user authentication.

Also modifying a user/host component of the username will put triggers, events, plugins, grants, roles etc out of sync with the combined username (aka broken). So just DROP/CREATE users rather than manipulate them.

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0
  2. how to delete data from table A besides the customer service and director data in table B?
  3. Trouble with UTF-8 characters; what I see is not what I stored
  4. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  5. MySQL: Grant **all** privileges on database
  6. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  7. MySQL error 1064 syntax but everything seems fine
  8. MySQL/MariaDB – order by inside subquery
  9. Cast int to varchar
  10. How can I change MariaDB to MySQL in XAMPP?
  11. Higher cardinality column first in an index when involving a range?
  12. How to turn on/off MySQL strict mode in localhost (xampp)?
  13. MySQL – SELECT * INTO OUTFILE LOCAL ?
  14. Database corruption with MariaDB : Table doesn’t exist in engine
  15. django cannot connect mysql in docker-compose
  16. Recreating a query using INNER JOIN? [duplicate]
  17. MySQL: Enable LOAD DATA LOCAL INFILE
  18. mysql select dynamic row values as column names, another column as value
  19. MySQL root access from all hosts
  20. Setting up MySQL and importing dump within Dockerfile
  21. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  22. How to select date from datetime column?
  23. How do I use properly CASE..WHEN in MySQL
  24. Delete query not working in mysql
  25. SQL Server equivalent of substring_index function in MySQL
  26. MySQL foreign key to allow NULL?
  27. MySQL selecting yesterday’s date
  28. MySQL: Can I do a left join and pull only one row from the join table?
  29. How can I stop a MySQL query if it takes too long?
  30. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys

Leave a Comment