• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

A

acidbox

Guest
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.
 
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.
 
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';
 
Back
Top