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
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
r