The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[WHM] confused about "SQL Services >> Change MySQL DB Owner Password" terminology

Discussion in 'General Discussion' started by cPancake, Jan 28, 2011.

  1. cPancake

    cPancake Member

    Joined:
    Jan 28, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    WHM : Main >> SQL Services >> Change MySQL DB Owner Password

    What is meant by "Owner password" ?

    Is this the same as

    cPanel : MySQL Databases >> MySQL Users >> Add New User: Password ?

    Thanks,
    Alan

    - WHM 11.28.64
    - cPanel 11.28.64
     
  2. LinuxTechie

    LinuxTechie Well-Known Member

    Joined:
    Jan 22, 2011
    Messages:
    502
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hi Alan,

    This feature allows you to change passwords for a database owner. As this feature does not require the old password, this can be useful if a password is compromised or forgotten.


     
  3. cPancake

    cPancake Member

    Joined:
    Jan 28, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi Varada,

    Thanks for your reply.

    It still does not answer my question though. ;O)

    Alan
     
  4. LinuxTechie

    LinuxTechie Well-Known Member

    Joined:
    Jan 22, 2011
    Messages:
    502
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hi Alan,

    The option :

    cPanel : MySQL Databases >> MySQL Users >> Add New User: Password ? : Will add a new user and a password will be set for the user.

    The option :

    WHM : Main >> SQL Services >> Change MySQL DB Owner Password : Used to change the password of existing mysql db owners.

    So, the answer is there is difference between the options.
     
    #4 LinuxTechie, Jan 28, 2011
    Last edited: Jan 28, 2011
  5. cPancake

    cPancake Member

    Joined:
    Jan 28, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi Varda,

    The confusion is not in the options themselves, it's in their terminology (re: subject line)

    One talks about password "owner", the other about password "user".

    From what I understand from your latest post, MySQL DB "owner password" (in WHM) and "user password" (in cPanel) are the same, i.e. when the "owner password" is changed through "WHM : Main >> SQL Services >> Change MySQL DB Owner Password", it changes the "user password" which was set through "cPanel : MySQL Databases >> MySQL Users >> Add New User: Password" .

    Correct ?

    Regards,
    Alan
     
    #5 cPancake, Jan 28, 2011
    Last edited: Jan 28, 2011
  6. LinuxTechie

    LinuxTechie Well-Known Member

    Joined:
    Jan 22, 2011
    Messages:
    502
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hi Alan,

    I would like to correct it here. It will change the password of the database owner only. There is difference between users and owner of the database.
     
  7. cPancake

    cPancake Member

    Joined:
    Jan 28, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi Varada,

    excuse me my ignorance,

    the difference is ... ?

    edit #1: its even more confusing because "WHM : Main >> SQL Services >> Change MySQL DB Owner Password" first asks to select a "MySQL User" (to change the owner password) and results in "Change MySQL User Password: Password changed for (...) to (new password)"

    edit #2: searched the MySQL online manual for "owner password" which gives "refman-50 - There are no matches for the search term."; found "user password" and "root password" but "owner password" is a mystery
     
    #7 cPancake, Jan 28, 2011
    Last edited: Jan 28, 2011
  8. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    With version 11.28 the cPanel account can have a separate password for cPanel (which is the system password) and MySQL. The 'Change MySQL DB Owner Password' interface in WHM allows root/reseller to change just the MySQL password for the account.

    The term 'DB Owner' refers to something internal to the database mapping functionality and is an artefact of something that changed during development. The title should more clearly state 'Change MySQL Password for cPanel Accounts' or something like that.
     
  9. cPancake

    cPancake Member

    Joined:
    Jan 28, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi Kenneth,

    what is this "cPanel Account MySQL password" good/useful for ?
    so far I've only found what "MySQL user password" (in cPanel) and "MySQL root password" (in WHM) mean
     
    #9 cPancake, Jan 28, 2011
    Last edited: Jan 28, 2011
  10. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    For the typical hosting customer, there's 2 ways to authenticate into one of their databases:

    1. Create a MySQL user, assign that MySQL user some permissions to a desired database and login as that MySQL user. This is sometimes referred to as using a MySQL virtual user.

    2. Authenticate using your cPanel credentials.

    This second option becomes tricky in environments where you do not want your website to break because you changed your cPanel password. That is one potential use for keeping the password used for authenticating as the cPanel user different for MySQL than for cPanel itself.

    Personally, I prefer if everyone just used MySQL virtual users, it just makes things much less of a headache in the long-run. However, many who are experienced with non-control panel environments are accustomed to authenticating as the system (cPanel) user into a database.
     
Loading...

Share This Page