1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

MySQL - Have a db user with rights to multiple tables

Discussion in 'Plesk for Windows - 8.x and Older' started by pg116, Sep 13, 2004.

  1. pg116

    pg116 Guest

    0
     
    When i create a domain and then add a DB, I'm prompted to create a user for each db.

    How can I have 1 db user for a domain that has rights to multiple db's?

    And have them show up when he logs into the Plesk CP.

    Thanks
     
  2. pg116

    pg116 Guest

    0
     
    Anyone know?
     
  3. pg116

    pg116 Guest

    0
     
    Anyone? Hello??
     
  4. Brummbaer76

    Brummbaer76 Guest

    0
     
    i am interesting to, this is a very good questen.
    in confixx this isn´t a problem !
     
  5. alex042

    alex042 Guest

    0
     
    I don't think I've seen this feature, but it seems like it could be a potential security hole. Just think if a hacker somehow got ahold of the user and password to one of the databases, they could technically have access to all of the others also.
     
  6. pg116

    pg116 Guest

    0
     
    I really don't think it is an increase of a security risk. Having control of 1 database compared to 5 doesn't really change things.

    This should be something that is offered by the Control Panel.
     
  7. DReffects

    DReffects Basic Pleskian

    26
    40%
    Joined:
    Feb 8, 2005
    Messages:
    76
    Likes Received:
    0
    GRRRRRRRRR i just switched from ensim to plesk...

    first of all the migration doesnt work at all.
    second thing is this **** with the database users. i know lots of professional scripts that use multiple databases at the same time. also my customers do.

    this is totally inacceptable and far from any standard.

    @SwSoft: plase release a upgrade IMMEDIATELY cause your software is unuseable the way it is now.
     
  8. mymilkexpired

    mymilkexpired Guest

    0
     
    You can give the rights manually in MYSQL. You just need to update the users permissions inside the dos mysql console... not hard, really.
     
  9. DReffects

    DReffects Basic Pleskian

    26
    40%
    Joined:
    Feb 8, 2005
    Messages:
    76
    Likes Received:
    0
    i can. but dumb customers that rely on the common control panel features ensim confixx or cpanel provides dont. i don't need a expensive control panel if my customers cannot use it the way they are used to.

    this is a step backwards instead of forwards. nowadays you cannot sell hosting without a control panel - and hey - confixx can do things then new and oh so magical plesk can't? and what should i tell my existing customers that use two or more databases, spent lots of money for the development of their websites and then find that with an UPDATE to a NEW control panel even the most basic things wont work?

    Creating a seperate mysql connect for each database is for some communities i host simply impossible. also, creating a new connection to the database everytime isnt really a CPU load-saver....

    man, this sucks!
     
  10. kineda

    kineda Guest

    0
     
    Can you please explain how?
     
  11. DReffects

    DReffects Basic Pleskian

    26
    40%
    Joined:
    Feb 8, 2005
    Messages:
    76
    Likes Received:
    0
    install phpmyadmin in one of your own domains, login as admin/root and click the 'rights' button on the start-page.

    then you get a listing of all the database users. select the one you'd like to edit, and grant him specific rights for another database.

    its very simple - but not for a customer.. especially cause i do not give my customers my root pwd ;)
     
  12. kineda

    kineda Guest

    0
     
Loading...