Hi, I insert a new user to access the MySQL database. I have 4 databases plus the mysql database. I want that this user can run the select instruction just into one database, so I did this:
[prompt]$ mysql u root p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3147 to server version: 4.0.18-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed INSERT INTO user (Host, User, Password, Select_priv) VALUES ('%', 'myuser', password('hispassword'), 'Y'); mysql> GRANT ALL ON database2.* TO myuser; mysql> FLUSH PRIVILEGES; mysql> quit; However, when I log using this new user myuser, I still can see the others database and a can insert, update and delete records into all databases instead of just have the rights to select in the database2. What I did was correct or it is missing something? Best Regards, Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]