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=gcdmg-mysql-2@m.gmane.org

RE: permissions in information_schema

Information_schema is a read-only memory database.

When you create'MySqlMonitor'@'localhost', you will still see the informati=
on_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
redwards@logicworks.net
http://www.linkedin.com/in/rolandoedwards


-----Original Message-----
From: Darvin Denmian [mailto:darvin.denmian@gmail.com]=20
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!

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dredwards@logicworks=
..net


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: permissions in information_schema

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
wrote:
> Information_schema is a read-only memory database.
>
> When you create'MySqlMonitor'@'localhost', you will still see the informa=
tion_schema.
>
> However, the information_schema will only contain table info 'MySqlMonito=
r'@'localhost' can access.
>
> Information_schema behaves more like a restricted view of actual database=
s 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
> redwards@logicworks.net
> http://www.linkedin.com/in/rolandoedwards
>
>
> -----Original Message-----
> From: Darvin Denmian [mailto:darvin.denmian@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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dredwards@logi=
cworks.net
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg