1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'Plesk for Linux - 8.x and Older' started by acidbox, Nov 23, 2005.

  1. acidbox

    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.
  2. arleen

    arleen Guest

    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.

  3. gulliver

    gulliver Guest

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

    jahsh420 Guest

    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';