Re: permissions in information_schema

2010-08-30 Thread Darvin Denmian
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.

RE: permissions in information_schema

2010-08-30 Thread Rolando Edwards
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