can the same mysql user access two dbs?

[endquote]

I have multiple MySQL databases under the same domain. For all but one of them, it makes sense to have a separate user for each. However for one of the databases, I'd like all of the other users to be able to access it. If I try to add these other existing users to that db though, Plesk says I can't because they already exist. Is there any way to make this work?

 

[nbdev]

Hi,

This cannot AFAIK be done through the Plesk-panel.

It can of course be achieved on the command-line via 'mysql' program. In this program you can assign rights for a specific user on any database.

Shell-access is necessary of course. For information please check the mysql-site for the GRANT-syntax.

Regards,

Ton