Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MYSQL lost database passwords

Discussion in 'General Discussion' started by WebHostPro, Feb 29, 2008.

  1. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,651
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    All of the sudden today mysql decided to forget all the passwords for all the databses. If I go re-add the passord it works fine but the server it happened on has about 150 databases.

    Is there a way to have the password updated server wide for all mysql databases?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 WebHostPro, Feb 29, 2008
  2. ManojB

    ManojB Well-Known Member

    Joined:
    Mar 25, 2005
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    pune
    Hello,

    It seems you have updated MYSQL version without checking the option "Use old style passwords", so you are facing this problem. I too have gone through this issue and have to reset all the passwords manually. I would suggest you dont waste the time and reset the password manually.... Let me know if I can help you with this if you wish ...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 ManojB, Mar 1, 2008
  3. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,651
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Great now I understand.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 WebHostPro, Mar 1, 2008
  4. ManojB

    ManojB Well-Known Member

    Joined:
    Mar 25, 2005
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    pune
    Can you please let me know what steps you have taken to resolve this issue.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 ManojB, Mar 2, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - MYSQL lost database
  1. suganthanatwork

    Lost connection to MySQL server during query error

    suganthanatwork, Jan 25, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    769
    dave321
    Feb 1, 2018
  2. TragedyStruck

    SOLVED "Lost connection to MySQL server during query" with Python App

    TragedyStruck, Aug 11, 2017, in forum: Database Discussion
    Replies:
    3
    Views:
    4,747
    cPanelMichael
    Aug 28, 2017
  3. Clud7

    New Thread No mysql for clients on MariaDB 10.2

    Clud7, Jun 16, 2018 at 5:47 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    41
    Clud7
    Jun 17, 2018 at 4:56 PM
  4. Edwin Tjallings

    Alt-php not working after mysql 5.7 upgrade

    Edwin Tjallings, Jun 13, 2018 at 6:58 AM, in forum: CloudLinux
    Replies:
    2
    Views:
    87
    Edwin Tjallings
    Jun 15, 2018 at 5:21 AM
  5. .Tyler

    Install MySQL Enterprise on server with MySQL 5.5?

    .Tyler, Jun 12, 2018 at 4:38 PM, in forum: General Discussion
    Replies:
    1
    Views:
    53
    cPanelMichael
    Jun 13, 2018 at 8:21 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice