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,654
    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,654
    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:
    1,269
    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:
    8,125
    cPanelMichael
    Aug 28, 2017
  3. Aldeahost

    MySQL or MariaDB?

    Aldeahost, Oct 16, 2018 at 3:47 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    73
    cPanelLauren
    Oct 17, 2018 at 6:31 PM
  4. Maning

    New Thread MYSQL high cpu usage issue

    Maning, Oct 13, 2018 at 12:16 PM, in forum: Workarounds and Optimization
    Replies:
    0
    Views:
    68
    Maning
    Oct 13, 2018 at 12:16 PM
  5. Maning

    limit user connections on mysql

    Maning, Oct 11, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    55
    cPanelLauren
    Oct 12, 2018 at 1:04 PM

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