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!

Upgraded mySQL to 5.5.34 via cPanel, get #2002 Cannot log in to the MySQL server

Discussion in 'General Discussion' started by Jesse Smith, Dec 20, 2013.

  1. Jesse Smith

    Jesse Smith Member

    Joined:
    Dec 12, 2013
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Trying to log in to phpMyAdmin generates...

    #2002 Cannot log in to the MySQL server

    SSH generates...

    Code:
    -bash-3.2# mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    -bash-3.2# service mysql start
    Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/wor.domain.com.pid).
    
    and if it will help...
    
    -bash-3.2# tail -n 50 /var/lib/mysql/`hostname`.err
    131219 22:37:10 [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M'
    131219 22:37:10 [ERROR] Aborting
    
    131219 22:37:10  InnoDB: Starting shutdown...
    131219 22:37:10  InnoDB: Shutdown completed; log sequence number 2481200
    131219 22:37:10 [Note] /usr/sbin/mysqld: Shutdown complete
    
    131219 22:37:10 mysqld_safe mysqld from pid file /var/lib/mysql/wor.domain.com.pid ended
    131219 22:42:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    131219 22:42:10 [Warning] Using unique option prefix join_buffer instead of join_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    131219 22:42:10 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    131219 22:42:10 [Note] Plugin 'FEDERATED' is disabled.
    131219 22:42:10 InnoDB: The InnoDB memory heap is disabled
    131219 22:42:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    131219 22:42:10 InnoDB: Compressed tables use zlib 1.2.3
    131219 22:42:10 InnoDB: Using Linux native AIO
    131219 22:42:10 InnoDB: Initializing buffer pool, size = 128.0M
    131219 22:42:10 InnoDB: Completed initialization of buffer pool
    131219 22:42:10 InnoDB: highest supported file format is Barracuda.
    131219 22:42:10  InnoDB: Waiting for the background threads to start
    131219 22:42:11 InnoDB: 5.5.34 started; log sequence number 2481200
    131219 22:42:11 [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M'
    131219 22:42:11 [ERROR] Aborting
    
    131219 22:42:11  InnoDB: Starting shutdown...
    131219 22:42:11  InnoDB: Shutdown completed; log sequence number 2481200
    131219 22:42:11 [Note] /usr/sbin/mysqld: Shutdown complete
    
    131219 22:42:11 mysqld_safe mysqld from pid file /var/lib/mysql/wor.domain.com.pid ended
    131219 22:47:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    131219 22:47:11 [Warning] Using unique option prefix join_buffer instead of join_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    131219 22:47:11 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    131219 22:47:11 [Note] Plugin 'FEDERATED' is disabled.
    131219 22:47:11 InnoDB: The InnoDB memory heap is disabled
    131219 22:47:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    131219 22:47:11 InnoDB: Compressed tables use zlib 1.2.3
    131219 22:47:11 InnoDB: Using Linux native AIO
    131219 22:47:11 InnoDB: Initializing buffer pool, size = 128.0M
    131219 22:47:11 InnoDB: Completed initialization of buffer pool
    131219 22:47:11 InnoDB: highest supported file format is Barracuda.
    131219 22:47:11  InnoDB: Waiting for the background threads to start
    131219 22:47:12 InnoDB: 5.5.34 started; log sequence number 2481200
    131219 22:47:12 [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M'
    131219 22:47:12 [ERROR] Aborting
    
    131219 22:47:12  InnoDB: Starting shutdown...
    131219 22:47:13  InnoDB: Shutdown completed; log sequence number 2481200
    131219 22:47:13 [Note] /usr/sbin/mysqld: Shutdown complete
    
    131219 22:47:13 mysqld_safe mysqld from pid file /var/lib/mysql/wor.domain.com.pid ended
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,887
    Likes Received:
    1,814
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    The relevant error message here is:

    Code:
    [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M'
    Remove that value from your /etc/my.cnf file and then restart MySQL.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice