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.

How can I find existing database user password?

Discussion in 'General Discussion' started by ichsie, Oct 21, 2009.

  1. ichsie

    ichsie Registered

    Joined:
    Oct 21, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    kavoir.com
    Or is there any chance at all to find the password of an existing database user?

    There is no reset button neither. So deleting the user and readding it again is my only option? :confused:

    P.S. Where can I modify the default language pack from WHM for all new users of cPanel? There are just so many sections of configurations. Thanks!
     
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    It is not readily feasible or possible to decrypt passwords for MySQL users; the passwords are stored in an encrypted form by MySQL.

    I suggest trying to simply recreate the user using the desired password, optionally without removing it first, in attempt to reset an existing MySQL user.

    Regarding the language inquiry; would you be able to expand upon this question with more detail about what is needing to be accomplished?

    If I understand the question correctly, it is possible to set the user's language using the package system in WHM; once there is a package with your preferred language the package can then be used to easily define your desired preferences during new account creations.

    How to manage packages is detailed further in our documentation at the following link:
    WhmPackages < AllDocumentation/WHMDocs < TWiki
     
  3. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    As the mysql root user, it's trivial easy to reset the password for any MySQL user or their access permissions.

    You don't need to delete or re-add anything, that would be completely unnecessary.

    Just simply change the MySQL user's password!

    You can then update whatever script is using that database login with the new password and you should be ready to go! ;)
     
  4. ichsie

    ichsie Registered

    Joined:
    Oct 21, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    kavoir.com
    Thanks, Don and Spiral, for the clarification. Now I got it. :)
     
  5. aspardeshi

    aspardeshi Member

    Joined:
    Oct 22, 2009
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    recreating user is the only easy solution

    I do it several times. it is the easiest solution. :)
     
Loading...

Share This Page