How to grant select on information_schema
Posted by:
Justin Xu
Date: January 29, 2018 09:41PM
Hi,
I want to grant select on DB in formation_schema to an user, but got the below error. How to grant select privilege on all tables of information_schema to an user ?
mysql> grant select on information_schema.* to 'mytest'@'%' identified by 'test1234';
--------------
grant select on information_schema.* to 'mytest'@'%' identified by 'test1234'
--------------
ERROR 1044 (42000): Access denied for user 'root'@'127.0.0.1' to database 'information_schema'
mysql> show grants for root;
--------------
show grants for root
--------------
+--------------------------------------------------------------------------------------------------------------+
| Grants for root@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*D50CDD8864D10CA3204A886A4BA20DD3C87BACCA' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Subject
Written By
Posted
How to grant select on information_schema
January 29, 2018 09:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.