Page 2 of 2 FirstFirst 12
Results 16 to 30 of 30
  1. #16
    just create another user for that database from mysql tab, then you should adjust the connection properties with that new user on your script/software

  2. #17
    Join Date
    Sep 2007
    Location
    In ur heart
    Posts
    60

    Solution

    Hi,

    If you are having your server root login details then follow following steps carefully from shell.

    1st login in to shell as root user now run command( For example I am using site/domain name as test.com and user test.

    /scripts/whoowns test.com

    It will give you user name, now switch to user account.

    cd ~test/public_html
    or
    cd /home/test/public_htm
    l

    Now you are in test user home directory under which all hosting files are present.

    Run command to search database user and password.

    grep test_ * -R -l

    Above command will show you all files under which database name/user name is defined.

    Now you have to open config file, you have received after running above command.

    One config file open search for database user name and password.

    login in to cPanel select mysql database feature and add database user with the password which you have found out in config files and reassigned privilege for newly added database user to existing database.

    <<snipped>>

    Awaiting for your reply.
    Last edited by bear; 01-02-2011 at 10:44 AM.

  3. #18
    Join Date
    Aug 2009
    Location
    New Delhi
    Posts
    611
    It is strange that you can not reset the mysql password from cpanel.
    Why shouldn't I be able to do that if I have created the user through cpanel?
    Looks like a feature suggestion for cpanel.
    Qtriangle - Website development and web hosting solutions
    The very best of PHP/MySQL development services

  4. #19
    Hi,
    If you lost your root SQL password there is an option in WHM to change it.

    Dylan,

  5. #20
    Can anyone please tell me what happens if I REMOVE those two passwords from that file? What apps on the system actually use or rely on them?

  6. #21
    Join Date
    Jan 2002
    Location
    USA
    Posts
    4,534
    Is the database being used by any active scripts?

    Could you not, I don't know... just look into the configuration (config.php) of said script to obtain current MySQL password?

    Example, if you lost your database details for a Wordpress blog, just look up the details in the config.php and save yourself the hassle of having to change that exact same line of information after you've made the update.
    Curtis Mann, Customer Success Specialist
    sales @ jaguarpc.com | (888) 338-5261 | Twitter: @jaguarpc
    JaguarPC.com - Managed Hybrid Servers | Managed VPS Hosting | Idera Idera Backup | Dedicated Servers
    Exceptional Service | Homegrown | Veteran Owned | Operating since 1998!

  7. #22
    Join Date
    May 2008
    Location
    Melbourne, Australia
    Posts
    10,474
    The database does not physically have a password, it is the user assigned to the database that uses the password, if you are using cPanel simply remove the user from the database and then re-create that user with another password.

    You can change the passwords as required within phpMyAdmin or view the config.php as recommended.
    l Clever Emu (Twitter) Shared Reseller Cloud VPS Since 2003
    l Leading UK and Ireland Hosting Provider Multiple locations - around the globe!
    l cPanel/WHM R1Soft Backups 24/7/365 Support 99.9% Uptime Guarantee
    l www.yourcompanynamehere.com Customer Service Rep. Superior Service Guarantee

  8. #23

    How to login to mySql

    Simply log into WHM and scroll down and find SQL Services. In that section you will find a link to reset your root password for MySQL.

    Kindly,

    If you dont have access to cpanel and you're just trying to reset a passwod for a a local dbuser. Log into cpanel and go to databases. From there you can just change the password for the db user.

  9. #24
    Simply log into WHM and scroll down and find SQL Services. In that section you will find a link to reset your root password for MySQL.

  10. #25
    so if users need to reset their mysql password trough their cpanel they need to know the old password? this is just plain stupid.

  11. #26
    Join Date
    Oct 2002
    Location
    Middle Dearth
    Posts
    20,905
    Quote Originally Posted by magucr View Post
    so if users need to reset their mysql password trough their cpanel they need to know the old password? this is just plain stupid.
    Cpanel/WHM password is not the same as the mysql root pass.
    Having problems, or maybe questions about WHT? Head over to the help desk!


  12. #27
    Quote Originally Posted by bear View Post
    Cpanel/WHM password is not the same as the mysql root pass.
    huh? and whos saying that?

  13. #28
    When you click on change password, there is a buttom called sync passwords with mysql, click that and then job done,

    OR

    You can do what another user has said and make a new user in mysql.

  14. #29
    I know that, thanks but I am not asking for help, I am just criticizing the fact that you have to know the old password in order to reset it. It does not make any sense.

    Also, It is not a good idea to have both cpanel and mysql passwords synchronized, It's actually a documented security issue.

  15. #30
    login to cpanel and from there change the pass word easily, of your db username, you can change all the passwords, if you can solve it, re create the mysql database..

Page 2 of 2 FirstFirst 12

Related Posts from theWHIR.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •