MySQL Forums
Forum List  »  General

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)

Options: ReplyQuote


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.