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.

broken MySQL?!?

Discussion in 'General Discussion' started by nullvariable, Sep 9, 2005.

  1. nullvariable

    nullvariable Registered

    Joined:
    Sep 9, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    HELP!
    I've searched everywhere, tried all the fixes that I can find and I still can't get this fixed. It seems that when I changed my server from 4.0 to 4.1 (MySQL) the root password was reset...ok no problem except that every method I've used fails to fix it. Can't see things from cpanel (under backups the databases are not listed, just a mysql error) phpmyadmin won't authorize access.

    I've tried reseting the password from whm, I've done the following as posted in the FAQ:
    All the things I've tried haven't worked. I still can't get it back up and running. The users MySQL databases work but the root based stuff fails.


    Thanks
    DC
    http://ConeEnterprises.com
     
  2. jorj1

    jorj1 Member

    Joined:
    Nov 21, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Few guidelines:
    - use this command to login as root into your mysql:
    > mysql -p
    Enter password: *****

    This will avoid the use of .my.cnf so if you're going through then you should update ~/.my.cnf accordingly.

    If you don't then it also may be a poblem with your mysql.sock file. This is what happened to me:
    > ls -lia /tmp/mysql.sock
    15 lrwxrwxrwx 1 root root 30 Sep 11 04:41 /tmp/mysql.sock -> ../../var/lib/mysql/mysql.sock=

    This is wrong because mysql.sock target is under "../" not "../.." so :
    rm -rf /tmp/mysql.sock
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    ..this would restore the proper link.

    And add these lines into /etc/my.cnf
    datadir=/var/lib/mysql
    pid-file=/var/lib/mysql/ns1.worldsview.com.pid
     
    #2 jorj1, Sep 11, 2005
    Last edited: Sep 13, 2005
Loading...

Share This Page