• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Mysql User Limitations

Q

queueless

Guest
Greetings.

I am currently scripting a migration program to transfer domains to a Plesk 8 Linux system. My problem is that the Plesk MySQL interface is lacking functionality in that it will not allow a common database user among multiple databases. For example:

Originating server:

I have 3 databases

db1
db2
db3

I have 1 user that accesses these databases

dbuser

On the Plesk side, I have no option of, say, choosing an already existing user when adding a user to a database. I must have 3 distinct users for each database, which is less than optimal.

Now, I'm fully capable of duplicating the configuration on the backend (i.e. mysql db table); however, these users won't neccessarily be listed as users for secondary databases in the Plesk GUI.

I am wondering if anyone has any thoughts or encountered this problem, or how I might go about solving it.

Additionally, I'm (going to be) using the /usr/local/psa/bin/database to create the databases and users on a mass scale.

Thanks.
 
Well it seems this is a common problem with no solution.
 
Back
Top