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 Error(s)

Discussion in 'General Discussion' started by Redcoat, Aug 10, 2007.

  1. Redcoat

    Redcoat Registered

    Joined:
    Aug 24, 2005
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I'm experiencing some major issues that have rendered our services basically useless. I'm turning to the community for help as I have spent 6 hours on this issue with no avail and we cannot afford anymore system downtime.

    BACKGROUND:
    We are running WHM 10.8.0 cPanel 10.9.1-S14304 CentOS 4.5 i686 - WHM X v3.1.0

    We attempted to upgrade MySQL and some other Cpanel/WHM tools through /scripts/upcp. Everything appeared to be working fine, until we noticed we could not bring the MySQL server back up.

    When I trid to start MySQL I received the following error:
    Code:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) 
    To fix this I edited my /etc/my.cnf file and commented out the basedir line (not sure it was the right thing to do, but someone mentioned it in another post)

    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    max_connections=50
    table_cache=1000
    thread_cache_size=40
    thread_stack=100K
    wait_timeout=10
    join_buffer=2M
    myisam_sort_buffer_size=6M
    query_cache_size=6M
    read_rnd_buffer_size=2M
    
    [mysql.server]
    user=mysql
    #basedir=/var/lib
    
    After doing that, I received this error:

    Code:
    Access denied for user 'root'@'localhost' (using password: YES)
    
    I tried reseting the root password. That does nothing. I've searched on this forum prior to posting this. It looks like there has yet to be a resolution posted. I'm hoping someone can help. Otherwise I'm going to have to spend a few days restoring some backups.


    Here are some other tings I've tired:
    - Resinstall mySQL
    - Reinstall mySQL with force
    - the error log file... it shows nothing, since mySQL isnt actually starting
     
    #1 Redcoat, Aug 10, 2007
    Last edited: Aug 10, 2007
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Look in
    /root/my.cnf

    Change that to the password you set for mysql root via whm or vice versa
     
  3. Redcoat

    Redcoat Registered

    Joined:
    Aug 24, 2005
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    The password does match what I have put through WHM. I don't think this is the issue.
     
  4. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
  5. Redcoat

    Redcoat Registered

    Joined:
    Aug 24, 2005
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I tried the steps mentioned in the thread you posted. No go. Same error
     
  6. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,125
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    New York
    Did you upgrade mysql to a much newer version?, I mean how old was it and what did you go to ?

    Also make sure that '/var/lib/mysql/mysql.sock' actually exists and that you werent using some other location
    for the socket.
     
  7. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Try running


    /scripts/mysqlconnectioncheck
     
  8. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA

    http://forums.cpanel.net/showthread.php?t=52517 ??
     
  9. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
  10. RACKSET

    RACKSET Active Member

    Joined:
    Apr 28, 2006
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    localhost
    Did you find any resolution for this?
     
Loading...

Share This Page