Access problem

[latch]

Hi

I installed DBI,DBD-MySQl Driver on my Linux box and everything works fine . I
want to restrict access for a user ( called 'user1' ) to the database 'mysql';

This is what I did

I created user called 'user1' with all permissions set to 'Y' in the 'user'
table
I didnt specify any databases for user 'user1' in the 'db' table
and made no entries in the 'host' table either.
Yet user 'user1' is able to access all databases including the database 'mysql';
I want to deny access to the 'mysql' database for user 'user1'

Any help appreciated

Thanx

CM

"Brahmaiva satyam"
-Adi Shankara (788-820 AD)

 

[Broccoli2]

MySQL has an 'optimistic' privelege system - ie, it uses a logical 'OR' on (nearly) all the privelege tables when working out if a user can have access. This means you can't explicitly restrict access, you can only reduce the priveleges that you are enabling.

When you set all the 'Y's in the

user

table, you are giving global priveleges to the user (to all databases). Perhaps what you want is to change all the 'Y's to 'N's in the

user

table, then add an entry in the

db

table for the user/database combination you want to enable.

More information is available on the MySQL site -

http://www.mysql.com/doc

-Rob