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,605
    Likes Received:
    11
    Trophy Points:
    168
    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,605
    Likes Received:
    11
    Trophy Points:
    168
    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. Droidism20011

    New Thread MySQL -> MariaDB security questions

    Droidism20011, Jul 20, 2017 at 2:21 PM, in forum: Security
    Replies:
    0
    Views:
    17
    Droidism20011
    Jul 20, 2017 at 2:21 PM
  2. Ahmed Hany

    Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/

    Ahmed Hany, Jul 11, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    55
    cPanelMichael
    Jul 12, 2017
  3. mark4785

    MySQL DB Download Traces

    mark4785, Jun 30, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    68
    Infopro
    Jun 30, 2017
  4. sparek-3

    MySQL to MariaDB - what to expect?

    sparek-3, Jun 26, 2017, in forum: Database Discussions
    Replies:
    5
    Views:
    210
    DWaters
    Jul 4, 2017
  5. burn1024

    Munin mysql2 plugin isn't working

    burn1024, Jun 23, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    58
    cPanelMichael
    Jun 26, 2017

Share This Page