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,662
    Likes Received:
    17
    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,662
    Likes Received:
    17
    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:
    2,003
    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:
    12,308
    cPanelMichael
    Aug 28, 2017
  3. CristianAugusto

    New Thread UAPI Add MySQL Host doesn't take effect

    CristianAugusto, Mar 20, 2019 at 9:09 AM, in forum: cPanel Developers
    Replies:
    0
    Views:
    26
    CristianAugusto
    Mar 20, 2019 at 9:09 AM
  4. ca2236

    New Thread MySQL to Mariadb upgrade path?

    ca2236, Mar 19, 2019 at 6:08 PM, in forum: Database Discussion
    Replies:
    1
    Views:
    53
    GOT
    Mar 20, 2019 at 7:48 AM
  5. Gustavo Vendramini

    New Thread Create a new MySQL user with super privileges

    Gustavo Vendramini, Mar 19, 2019 at 1:52 PM, in forum: Database Discussion
    Replies:
    0
    Views:
    38
    Gustavo Vendramini
    Mar 19, 2019 at 1:52 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