Information_schema is a read-only memory database. When you create'MySqlMonitor'@'localhost', you will still see the information_schema.
However, the information_schema will only contain table info 'MySqlMonitor'@'localhost' can access. Information_schema behaves more like a restricted view of actual databases and tables (a view of only your stuff) Makes sense ??? Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -----Original Message----- From: Darvin Denmian [mailto:darvin.denm...@gmail.com] Sent: Monday, August 30, 2010 4:10 PM To: mysql@lists.mysql.com Subject: permissions in information_schema Can somebody tell me why the last command bellow doesn't works? mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'senha' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> GRANT SUPER,REPLICATION CLIENT,SELECT ON information_schema.* TO 'MySqlMonitor'@'localhost' IDENTIFIED BY 'senha'; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema' mysql> Thanks, and sorry if this is a newbie doubt! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
