Thanks Rolando for your help. But there is one thing that is very stranger....
When I use Mysql Administrator to configure the permissions that I want for the user "MySqlMonitor" , everything works fine, as you can see in the image bellow: http://img801.imageshack.us/img801/6225/capturadetelabe.png Is there some explanation for this? I'm using "mysql-server-5.0.77-4.el5_5.3" in a CentOS Server. Thanks !!! On Mon, Aug 30, 2010 at 5:27 PM, Rolando Edwards <redwa...@logicworks.net> wrote: > 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
