Hello I would like to create a user that can create databases and do all the necessary changes to it(select, insert, update, delete...), view all database that he has been granted to see by other users except the mysql.* I have created 1 user with the grant method but he can see all the tables and probable edit them because I have used the
grant all priviledges to [EMAIL PROTECTED] identified by 'somepass' with grant option; How should I procede after I created the above user I tried to revoke select on mysql.* from [EMAIL PROTECTED]; but i got the following error ERROR 1141: There is no such grant defined for user 'myself' on host 'localhost' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
