Sample Header Ad - 728x90

Same global user works local but fails on live server for information_schema database UPDATE query

0 votes
1 answer
28 views
- I have two database servers, local and live. - The local server is running MariaDB 10.11.6, the live server is running 10.11.8. - I have the exact same global user, example@localhost on both the local and live servers. - I ran the exact same SQL query (UPDATE information_schema.TABLES ...) on both servers. - The database/table/column structures are exactly the same. - The query ran 100% perfect on the local server. - I received the following error on the live server: >Access denied for user 'example'@'localhost' to database 'information_schema' - I researched and found the exact same results using SELECT * FROM mysql.global_priv WHERE 'User'='example';. - The user has global permissions, not limited to specific databases on both the local and live servers. - In the mysql.db database/table there is no mention of the example user because again, it has *global permissions*. - In the mysql.db database/table there is no mention of the information_schema database on either server. How do I force MariaDB to allow the example user to execute my UPDATE information_schema.TABLES ... query on the live server?
Asked by John (769 rep)
Jul 14, 2024, 09:24 PM
Last activity: Jul 15, 2024, 01:56 AM