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]
