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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,644
    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?
     
    #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 ...
     
    #2 ManojB, Mar 1, 2008
  3. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,644
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Great now I understand.
     
    #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.
     
    #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 Discussions
    Replies:
    7
    Views:
    497
    dave321
    Feb 1, 2018
  2. TragedyStruck

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

    TragedyStruck, Aug 11, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    3,412
    cPanelMichael
    Aug 28, 2017
  3. Peter Horvath

    InnoDB crashed, no MySQL service available

    Peter Horvath, Apr 17, 2018 at 6:03 PM, in forum: Database Discussions
    Replies:
    2
    Views:
    40
    Infopro
    Apr 17, 2018 at 8:28 PM
  4. Spuddyboy

    SOLVED Setup Remote MySQL - WHM 68

    Spuddyboy, Apr 16, 2018 at 9:00 AM, in forum: Database Discussions
    Replies:
    3
    Views:
    44
    cPanelMichael
    Apr 17, 2018 at 8:37 AM
  5. sergios

    MySQL Remoto em Produção

    sergios, Apr 11, 2018, in forum: Discussões em Português
    Replies:
    3
    Views:
    69
    cPanelLauren
    Apr 18, 2018 at 7:52 AM

Share This Page