Several databases with restricted access for several users

[Nicolas Girot]

Hi everyone,

I need some help about something which seems to be special.

Is it possible to filter databases access according to a user. This is what i want to do :

For the example i take 3 users : User1, User2 et User3.

I would like to create 3 identical databases in order to make the users working only in the databases that they are link to.
And i want them to not be able to modify or just to connect to the others databases.

That means :

User1 -> DBase1

User2 -> DBase2

User3 -> DBase3

Because if i give a password to Mysql, databases are not directly protected, which means that, for example User1 has an access to DBase2.
Then if a user access to Mysql, He won't be able to access the other databases, except his own.

The best should be for a user to direct connect to his own databases through a config file (PHP/PDO).

THanks for your answers.

NIcolas