[REQUEST] Ability to assign EXISITING database users to NEW databases!

[acidbox]

This is probably one of the most frustrating things about Plesk.

Let's say you have 5 databases. In the current system, you have to create 5 users, one for each database. Many times, you want to use the same user.

So my proposal is to allow users to either create a new user, or update an existing user to grant them access on any databases that you own.

This is especially important now with all these frameworks (like Ruby on Rails and cakePHP) where a typical application will have at least 3 databases (development, test, production).

Just my .o2 cents.

 

[arleen]

Thanks for posting the request, acidbox.

I strongly 2nd your request. It's a bit cumbersome having to create new db users for each database.

A.

 

[gulliver]

April 2008, still doesn't seem to be sorted. ;-(

 

[jahsh420]

You can just manually grant permissions via the command line:

mysql -uadmin -p mysql

>grant all privileges on database1.* to user@localhost identified by 'pass';
>grant all privileges on database2.* to user@localhost identified by 'pass';