Creating users

2004-02-10 Thread Daniel Audette
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

creating users

2004-02-08 Thread Daniel Audette
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