MYSQL database setup

[mmxp]

It seems that in Plesk, even under the same domain, it is impossible to setup a same MYSQL user for different databases. every database has to have its unique users?
what if I want to give permission to user1 to access database1 and database2? (under the same domain).
How can I do that?
Thanks.

 

[ppc]

It seems that in Plesk, even under the same domain, it is impossible to setup a same MYSQL user for different databases. every database has to have its unique users?
what if I want to give permission to user1 to access database1 and database2? (under the same domain).
How can I do that?
Thanks.

You are correct in your assumption that every database needs a unique user. If you really needed to give "user1" access to "database1" and "database2" your going to need to fiddle manually within server configs which is not ideal.