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
Last activity: Jul 15, 2024, 01:56 AM