REVOKE ALL ON mysql.* FROM [EMAIL PROTECTED]
Daniel was missing the '.*' after mysql, which causes mysql to treat the 'mysql' as a table name rather than as a db. Hence the error message. See <http://www.mysql.com/doc/en/GRANT.html> for the details.
Bernard Clement wrote:
Hello Daniel,
Try with: revoke show databases on mysql.* from [EMAIL PROTECTED];
If the user [EMAIL PROTECTED] issue "show databases" il will not see anymore the databases "mysql".
The revoke you were trying was not only on showing the database mysql but revoke all the privilege, is is really what you want to do?
BTW, nex time also supply the error text.
Regards,
Bernard
On Sunday 08 February 2004 08:49, Daniel Audette wrote:
Hello
I am new to mysql. What I want to do is give a user a right to create databases with all rights but I do not want them to see the mysql database I have tried the following
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] DENTIFIED BY 'some_pass' WITH GRANT OPTION;
then tried to revoke revoke all privileges on mysql from [EMAIL PROTECTED];
just got an error.
Any suggestions on how to do this.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]