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.

"Reset Local MySQL Root Password" does not work.

Discussion in 'General Discussion' started by gopederick, Oct 11, 2004.

  1. gopederick

    gopederick Active Member

    Joined:
    Nov 11, 2003
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    I did a search and got this http://forums.cpanel.net/showthread.php?t=23696 But it doesn't answer my problem so I will post a new thread.

    Now for my problem.

    Hi, I am having this same problem. When I click Add Db button it says it did, but when it returns back the page it shows no created database.

    1. MySQL is running. Forums and my gameserver plugins are working.
    2. I can not Reset Local MySQL Root Password. It says it did it but I can not access mysql via shell or phpmyadmin.

    So I did a make deinstall for mysql 4.0.13 and installed 4.0.21 and I still get the same problem.

    Any ideas on how I can reset the mysql password so it works?
     
  2. gopederick

    gopederick Active Member

    Joined:
    Nov 11, 2003
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    ^ bumpage ^
     
  3. gopederick

    gopederick Active Member

    Joined:
    Nov 11, 2003
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    ^ more bumpage ^
     
  4. paolorulez

    paolorulez Guest

    try


    pico /root/.my.cnf

    set user and your pass without ""

    after
    mysql> FLUSH PRIVILEGES;
    restart mysql


    another method

    shell> mysql -u root



    mysql> UPDATE mysql.user SET Password=PASSWORD(newpwd)
    -> WHERE User=root;
    mysql> FLUSH PRIVILEGES;
    restart mysql
     
  5. gopederick

    gopederick Active Member

    Joined:
    Nov 11, 2003
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    yay it worked.! many thanks! removing the quotes did it! thanks again ^_^
     
Loading...

Share This Page