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]
