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]