autentication of database

[Anon]

can i authenticat a particular database with ur name and user id

[Anon]

I don't really understand what you mean.

In all <dbname>_connect() you may use user and pass.

Hamster.

[Anon]

sorry hamster,

Actually i want know that,how can i give the seperate <username> and <passowrd> for each database in mysql so that only authorised user can access a particular database.I mean
i want to authenticate each mysql database with a seperate user name and password.

Thanks for reply

Dhirendra

hamster wrote:

I don't really understand what you mean.

In all <dbname>_connect() you may use user and pass.

Hamster.

[Anon]

In mysql there is database called mysql and there are table user, db and host, in newer version there is also columns_priv.

Thanks to this tables u can control users' access.

Read documentation.

Hamster.

ps. is it an answer for your question ???