Results 1 to 15 of 15
  1. #1
    Join Date
    Sep 2013
    Posts
    48

    The MySQL server is currently offline

    Hello,
    When I go to the MySQL Databases faced with the following error I get:

    Code:
    The MySQL server is currently offline.
    
    Error while connecting to MySQL: #28000Access denied for user 'root'@'localhost' (using password: YES)

    The new server is newly installed.
    But the sites are connected to the database.
    -----------
    This is the MySQL Root Password of the output:

    Code:
    MySQL password change failed!!
    A forced reset will now be attempted.
    ..found binary [/usr/sbin/mysqld]..
    Waiting for mysql to terminate.....Done
    Waiting for mysql to restart.....Done
    Waiting for mysql to terminate.....Done
    Restarting MySQL ....
    Waiting for mysql to restart......finished.
    
    mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/*hostname*.pid) running as root with PID 23436 (process table check method)
    mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/*hostname*.err --open-files-limit=50000 --pid-file=/var/lib/mysql/*hostname*.pid) running as mysql with PID 23699 (pidfile check method)
    
    mysql has failed, please contact the sysadmin (result was "mysql is not running").
    Done
    The MySQL root password has been changed.
    You have successfully changed “root”’s MySQL password.
    I was transferred to the server with the Restore Databases command was:
    mysql -u root -p -f < fulldbs.sql

    Before the command I chose a root password.

    Please Help

  2. #2
    Join Date
    Dec 2011
    Location
    Tulsa, OK
    Posts
    353
    Check your logs to see why your MySQL box won't start. Provide them here.
    OCOSA Communications | Since 2003
    http://www.ocosa.com
    Hosting, Connectivity, Professional Services

  3. #3
    Join Date
    Sep 2013
    Posts
    48
    The text file /var/lib/mysql/Hostname.err is :

    Code:
    140101 12:11:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140101 12:11:40 [Note] Plugin 'FEDERATED' is disabled.
    140101 12:11:40 InnoDB: The InnoDB memory heap is disabled
    140101 12:11:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140101 12:11:40 InnoDB: Compressed tables use zlib 1.2.3
    140101 12:11:40 InnoDB: Using Linux native AIO
    140101 12:11:40 InnoDB: Initializing buffer pool, size = 128.0M
    140101 12:11:40 InnoDB: Completed initialization of buffer pool
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    140101 12:11:40  InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    140101 12:11:40  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    140101 12:11:40  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: 127 rollback segment(s) active.
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    140101 12:11:40  InnoDB: Waiting for the background threads to start
    140101 12:11:41 InnoDB: 5.5.34 started; log sequence number 0
    140101 12:11:41 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140101 12:11:41 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140101 12:11:41 [Note] Server socket created on IP: '0.0.0.0'.
    140101 12:11:41 [Note] Event Scheduler: Loaded 0 events
    140101 12:11:41 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140101 12:11:42 mysqld_safe A mysqld process already exists
    140101 12:54:47 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140101 12:54:47 [Note] Event Scheduler: Purging the queue. 0 events
    140101 12:54:49 [Warning] /usr/sbin/mysqld: Forcing close of thread 166  user: 'leechprotect'
    
    140101 12:54:49  InnoDB: Starting shutdown...
    140101 12:54:50  InnoDB: Shutdown completed; log sequence number 2155325
    140101 12:54:50 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140101 12:54:50 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140101 12:54:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140101 12:54:51 [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.
    140101 12:54:51 [Note] Plugin 'FEDERATED' is disabled.
    140101 12:54:51 InnoDB: The InnoDB memory heap is disabled
    140101 12:54:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140101 12:54:51 InnoDB: Compressed tables use zlib 1.2.3
    140101 12:54:51 InnoDB: Using Linux native AIO
    140101 12:54:51 InnoDB: Initializing buffer pool, size = 128.0M
    140101 12:54:51 InnoDB: Completed initialization of buffer pool
    140101 12:54:51 InnoDB: highest supported file format is Barracuda.
    140101 12:54:51  InnoDB: Waiting for the background threads to start
    140101 12:54:52 InnoDB: 5.5.34 started; log sequence number 2155325
    140101 12:54:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140101 12:54:52 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140101 12:54:52 [Note] Server socket created on IP: '0.0.0.0'.
    140101 12:54:52 [Note] Event Scheduler: Loaded 0 events
    140101 12:54:52 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140102 12:03:27 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140102 12:03:27 [Note] Event Scheduler: Purging the queue. 0 events
    140102 12:03:29 [Warning] /usr/sbin/mysqld: Forcing close of thread 19462  user: 'eximstats'
    
    140102 12:03:29  InnoDB: Starting shutdown...
    140102 12:03:31  InnoDB: Shutdown completed; log sequence number 170477666
    140102 12:03:31 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140102 12:03:31 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140102 12:05:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140102 12:05:41 [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.
    140102 12:06:05 [Note] Plugin 'FEDERATED' is disabled.
    140102 12:06:05 InnoDB: The InnoDB memory heap is disabled
    140102 12:06:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140102 12:06:05 InnoDB: Compressed tables use zlib 1.2.3
    140102 12:06:05 InnoDB: Using Linux native AIO
    140102 12:06:07 InnoDB: Initializing buffer pool, size = 128.0M
    140102 12:06:10 InnoDB: Completed initialization of buffer pool
    140102 12:06:11 InnoDB: highest supported file format is Barracuda.
    140102 12:06:12  InnoDB: Waiting for the background threads to start
    140102 12:06:13 InnoDB: 5.5.34 started; log sequence number 170477666
    140102 12:06:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140102 12:06:13 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140102 12:06:13 [Note] Server socket created on IP: '0.0.0.0'.
    140102 12:06:13 [Note] Event Scheduler: Loaded 0 events
    140102 12:06:13 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140102 15:35:38 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140102 15:35:38 [Note] Event Scheduler: Purging the queue. 0 events
    140102 15:35:40 [Warning] /usr/sbin/mysqld: Forcing close of thread 1200  user: 'eximstats'
    
    140102 15:35:40  InnoDB: Starting shutdown...
    140102 15:35:42  InnoDB: Shutdown completed; log sequence number 1071393387
    140102 15:35:42 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140102 15:35:42 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140102 15:35:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140102 15:35:42 [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.
    140102 15:35:42 [Note] Plugin 'FEDERATED' is disabled.
    140102 15:35:42 InnoDB: The InnoDB memory heap is disabled
    140102 15:35:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140102 15:35:42 InnoDB: Compressed tables use zlib 1.2.3
    140102 15:35:42 InnoDB: Using Linux native AIO
    140102 15:35:42 InnoDB: Initializing buffer pool, size = 128.0M
    140102 15:35:42 InnoDB: Completed initialization of buffer pool
    140102 15:35:42 InnoDB: highest supported file format is Barracuda.
    140102 15:35:43  InnoDB: Waiting for the background threads to start
    140102 15:35:44 InnoDB: 5.5.34 started; log sequence number 1071393387
    140102 15:35:44 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140102 15:35:44 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140102 15:35:44 [Note] Server socket created on IP: '0.0.0.0'.
    140102 15:35:44 [Note] Event Scheduler: Loaded 0 events
    140102 15:35:44 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103 01:50:54 mysqld_safe A mysqld process already exists
    140103  1:51:15 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  1:51:15 [Note] Event Scheduler: Purging the queue. 0 events
    140103  1:51:17  InnoDB: Starting shutdown...
    140103  1:51:19  InnoDB: Shutdown completed; log sequence number 1072847180
    140103  1:51:19 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 01:51:19 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 01:51:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  1:51:19 [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.
    140103  1:51:19 [Note] Plugin 'FEDERATED' is disabled.
    140103  1:51:19 InnoDB: The InnoDB memory heap is disabled
    140103  1:51:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  1:51:19 InnoDB: Compressed tables use zlib 1.2.3
    140103  1:51:19 InnoDB: Using Linux native AIO
    140103  1:51:19 InnoDB: Initializing buffer pool, size = 128.0M
    140103  1:51:19 InnoDB: Completed initialization of buffer pool
    140103  1:51:19 InnoDB: highest supported file format is Barracuda.
    140103  1:51:20  InnoDB: Waiting for the background threads to start
    140103  1:51:21 InnoDB: 5.5.34 started; log sequence number 1072847180
    140103  1:51:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  1:51:21 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  1:51:21 [Note] Server socket created on IP: '0.0.0.0'.
    140103  1:51:22 [Note] Event Scheduler: Loaded 0 events
    140103  1:51:22 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  1:52:19 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  1:52:19 [Note] Event Scheduler: Purging the queue. 0 events
    140103  1:52:19  InnoDB: Starting shutdown...
    140103  1:52:20  InnoDB: Shutdown completed; log sequence number 1072847180
    140103  1:52:20 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 01:52:20 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 01:52:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  1:52:35 [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.
    140103  1:52:35 [Note] Plugin 'FEDERATED' is disabled.
    140103  1:52:35 InnoDB: The InnoDB memory heap is disabled
    140103  1:52:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  1:52:35 InnoDB: Compressed tables use zlib 1.2.3
    140103  1:52:35 InnoDB: Using Linux native AIO
    140103  1:52:35 InnoDB: Initializing buffer pool, size = 128.0M
    140103  1:52:35 InnoDB: Completed initialization of buffer pool
    140103  1:52:35 InnoDB: highest supported file format is Barracuda.
    140103  1:52:35  InnoDB: Waiting for the background threads to start
    140103  1:52:36 InnoDB: 5.5.34 started; log sequence number 1072847180
    140103  1:52:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  1:52:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  1:52:36 [Note] Server socket created on IP: '0.0.0.0'.
    140103  1:52:36 [Note] Event Scheduler: Loaded 0 events
    140103  1:52:36 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  1:52:37 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  1:52:37 [Note] Event Scheduler: Purging the queue. 0 events
    140103  1:52:37  InnoDB: Starting shutdown...
    140103  1:52:37  InnoDB: Shutdown completed; log sequence number 1072847180
    140103  1:52:37 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 01:52:37 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 01:52:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  1:52:49 [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.
    140103  1:52:49 [Note] Plugin 'FEDERATED' is disabled.
    140103  1:52:49 InnoDB: The InnoDB memory heap is disabled
    140103  1:52:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  1:52:49 InnoDB: Compressed tables use zlib 1.2.3
    140103  1:52:49 InnoDB: Using Linux native AIO
    140103  1:52:49 InnoDB: Initializing buffer pool, size = 128.0M
    140103  1:52:49 InnoDB: Completed initialization of buffer pool
    140103  1:52:49 InnoDB: highest supported file format is Barracuda.
    140103  1:52:49  InnoDB: Waiting for the background threads to start
    140103  1:52:50 InnoDB: 5.5.34 started; log sequence number 1072847180
    140103  1:52:50 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  1:52:50 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  1:52:50 [Note] Server socket created on IP: '0.0.0.0'.
    140103  1:52:50 [Note] Event Scheduler: Loaded 0 events
    140103  1:52:50 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  1:53:23 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  1:53:23 [Note] Event Scheduler: Purging the queue. 0 events
    140103  1:53:23  InnoDB: Starting shutdown...
    140103  1:53:24  InnoDB: Shutdown completed; log sequence number 1072847180
    140103  1:53:24 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 01:53:24 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 01:53:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  1:53:35 [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.
    140103  1:53:35 [Note] Plugin 'FEDERATED' is disabled.
    140103  1:53:35 InnoDB: The InnoDB memory heap is disabled
    140103  1:53:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  1:53:35 InnoDB: Compressed tables use zlib 1.2.3
    140103  1:53:35 InnoDB: Using Linux native AIO
    140103  1:53:36 InnoDB: Initializing buffer pool, size = 128.0M
    140103  1:53:36 InnoDB: Completed initialization of buffer pool
    140103  1:53:36 InnoDB: highest supported file format is Barracuda.
    140103  1:53:36  InnoDB: Waiting for the background threads to start
    140103  1:53:37 InnoDB: 5.5.34 started; log sequence number 1072847180
    140103  1:53:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  1:53:37 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  1:53:37 [Note] Server socket created on IP: '0.0.0.0'.
    140103  1:53:37 [Note] Event Scheduler: Loaded 0 events
    140103  1:53:37 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  1:54:04 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  1:54:04 [Note] Event Scheduler: Purging the queue. 0 events
    140103  1:54:04  InnoDB: Starting shutdown...
    140103  1:54:05  InnoDB: Shutdown completed; log sequence number 1072847180
    140103  1:54:05 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 01:54:05 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 01:54:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  1:54:16 [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.
    140103  1:54:16 [Note] Plugin 'FEDERATED' is disabled.
    140103  1:54:16 InnoDB: The InnoDB memory heap is disabled
    140103  1:54:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  1:54:16 InnoDB: Compressed tables use zlib 1.2.3
    140103  1:54:16 InnoDB: Using Linux native AIO
    140103  1:54:16 InnoDB: Initializing buffer pool, size = 128.0M
    140103  1:54:16 InnoDB: Completed initialization of buffer pool
    140103  1:54:16 InnoDB: highest supported file format is Barracuda.
    140103  1:54:16  InnoDB: Waiting for the background threads to start
    140103  1:54:17 InnoDB: 5.5.34 started; log sequence number 1072847180
    140103  1:54:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  1:54:17 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  1:54:17 [Note] Server socket created on IP: '0.0.0.0'.
    140103  1:54:17 [Note] Event Scheduler: Loaded 0 events
    140103  1:54:17 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  1:54:18 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  1:54:18 [Note] Event Scheduler: Purging the queue. 0 events
    140103  1:54:18  InnoDB: Starting shutdown...
    140103  1:54:19  InnoDB: Shutdown completed; log sequence number 1072847180
    140103  1:54:19 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 01:54:19 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 01:54:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  1:54:30 [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.
    140103  1:54:30 [Note] Plugin 'FEDERATED' is disabled.
    140103  1:54:30 InnoDB: The InnoDB memory heap is disabled
    140103  1:54:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  1:54:30 InnoDB: Compressed tables use zlib 1.2.3
    140103  1:54:30 InnoDB: Using Linux native AIO
    140103  1:54:30 InnoDB: Initializing buffer pool, size = 128.0M
    140103  1:54:30 InnoDB: Completed initialization of buffer pool
    140103  1:54:30 InnoDB: highest supported file format is Barracuda.
    140103  1:54:30  InnoDB: Waiting for the background threads to start
    140103  1:54:31 InnoDB: 5.5.34 started; log sequence number 1072847180
    140103  1:54:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  1:54:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  1:54:31 [Note] Server socket created on IP: '0.0.0.0'.
    140103  1:54:31 [Note] Event Scheduler: Loaded 0 events
    140103  1:54:31 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  1:55:06 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  1:55:06 [Note] Event Scheduler: Purging the queue. 0 events
    140103  1:55:06  InnoDB: Starting shutdown...
    140103  1:55:08  InnoDB: Shutdown completed; log sequence number 1072848685
    140103  1:55:08 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 01:55:08 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 01:55:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  1:55:19 [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.
    140103  1:55:19 [Note] Plugin 'FEDERATED' is disabled.
    140103  1:55:19 InnoDB: The InnoDB memory heap is disabled
    140103  1:55:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  1:55:19 InnoDB: Compressed tables use zlib 1.2.3
    140103  1:55:19 InnoDB: Using Linux native AIO
    140103  1:55:19 InnoDB: Initializing buffer pool, size = 128.0M
    140103  1:55:19 InnoDB: Completed initialization of buffer pool
    140103  1:55:19 InnoDB: highest supported file format is Barracuda.
    140103  1:55:19  InnoDB: Waiting for the background threads to start
    140103  1:55:20 InnoDB: 5.5.34 started; log sequence number 1072848712
    140103  1:55:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  1:55:20 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  1:55:20 [Note] Server socket created on IP: '0.0.0.0'.
    140103  1:55:21 [Note] Event Scheduler: Loaded 0 events
    140103  1:55:21 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:00:33 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:00:33 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:00:33  InnoDB: Starting shutdown...
    140103  2:00:34  InnoDB: Shutdown completed; log sequence number 1072848722
    140103  2:00:34 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:00:34 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:00:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:00:44 [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.
    140103  2:00:44 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:00:44 InnoDB: The InnoDB memory heap is disabled
    140103  2:00:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:00:44 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:00:44 InnoDB: Using Linux native AIO
    140103  2:00:44 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:00:44 InnoDB: Completed initialization of buffer pool
    140103  2:00:44 InnoDB: highest supported file format is Barracuda.
    140103  2:00:44  InnoDB: Waiting for the background threads to start
    140103  2:00:45 InnoDB: 5.5.34 started; log sequence number 1072848722
    140103  2:00:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:00:45 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:00:45 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:00:45 [Note] Event Scheduler: Loaded 0 events
    140103  2:00:45 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:07:10 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:07:10 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:07:10  InnoDB: Starting shutdown...
    140103  2:07:11  InnoDB: Shutdown completed; log sequence number 1072852845
    140103  2:07:11 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:07:11 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:07:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:07:23 [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.
    140103  2:07:23 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:07:23 InnoDB: The InnoDB memory heap is disabled
    140103  2:07:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:07:23 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:07:23 InnoDB: Using Linux native AIO
    140103  2:07:23 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:07:23 InnoDB: Completed initialization of buffer pool
    140103  2:07:23 InnoDB: highest supported file format is Barracuda.
    140103  2:07:23  InnoDB: Waiting for the background threads to start
    140103  2:07:24 InnoDB: 5.5.34 started; log sequence number 1072852845
    140103  2:07:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:07:24 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:07:24 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:07:24 [Note] Event Scheduler: Loaded 0 events
    140103  2:07:24 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:07:25 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:07:25 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:07:25  InnoDB: Starting shutdown...
    140103  2:07:26  InnoDB: Shutdown completed; log sequence number 1072852845
    140103  2:07:26 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:07:26 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:07:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:07:37 [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.
    140103  2:07:37 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:07:37 InnoDB: The InnoDB memory heap is disabled
    140103  2:07:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:07:37 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:07:37 InnoDB: Using Linux native AIO
    140103  2:07:37 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:07:37 InnoDB: Completed initialization of buffer pool
    140103  2:07:37 InnoDB: highest supported file format is Barracuda.
    140103  2:07:37  InnoDB: Waiting for the background threads to start
    140103  2:07:38 InnoDB: 5.5.34 started; log sequence number 1072852845
    140103  2:07:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:07:38 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:07:38 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:07:38 [Note] Event Scheduler: Loaded 0 events
    140103  2:07:38 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:08:11 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:08:11 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:08:11  InnoDB: Starting shutdown...
    140103  2:08:13  InnoDB: Shutdown completed; log sequence number 1072860053
    140103  2:08:13 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:08:13 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:08:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:08:26 [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.
    140103  2:08:26 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:08:26 InnoDB: The InnoDB memory heap is disabled
    140103  2:08:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:08:26 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:08:26 InnoDB: Using Linux native AIO
    140103  2:08:26 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:08:26 InnoDB: Completed initialization of buffer pool
    140103  2:08:26 InnoDB: highest supported file format is Barracuda.
    140103  2:08:26  InnoDB: Waiting for the background threads to start
    140103  2:08:27 InnoDB: 5.5.34 started; log sequence number 1072860078
    140103  2:08:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:08:27 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:08:27 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:08:27 [Note] Event Scheduler: Loaded 0 events
    140103  2:08:27 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:17:41 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:17:41 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:17:41  InnoDB: Starting shutdown...
    140103  2:17:43  InnoDB: Shutdown completed; log sequence number 1072869209
    140103  2:17:43 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:17:43 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:17:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:17:57 [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.
    140103  2:17:57 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:17:57 InnoDB: The InnoDB memory heap is disabled
    140103  2:17:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:17:57 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:17:57 InnoDB: Using Linux native AIO
    140103  2:17:57 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:17:57 InnoDB: Completed initialization of buffer pool
    140103  2:17:57 InnoDB: highest supported file format is Barracuda.
    140103  2:17:57  InnoDB: Waiting for the background threads to start
    140103  2:17:58 InnoDB: 5.5.34 started; log sequence number 1072869219
    140103  2:17:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:17:58 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:17:58 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:17:58 [Note] Event Scheduler: Loaded 0 events
    140103  2:17:58 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:33:47 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:33:47 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:33:47  InnoDB: Starting shutdown...
    140103  2:33:48  InnoDB: Shutdown completed; log sequence number 1073049901
    140103  2:33:48 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:33:48 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:34:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:34:01 [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.
    140103  2:34:01 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:34:01 InnoDB: The InnoDB memory heap is disabled
    140103  2:34:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:34:01 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:34:01 InnoDB: Using Linux native AIO
    140103  2:34:01 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:34:01 InnoDB: Completed initialization of buffer pool
    140103  2:34:01 InnoDB: highest supported file format is Barracuda.
    140103  2:34:01  InnoDB: Waiting for the background threads to start
    140103  2:34:02 InnoDB: 5.5.34 started; log sequence number 1073049911
    140103  2:34:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:34:02 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:34:02 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:34:02 [Note] Event Scheduler: Loaded 0 events
    140103  2:34:02 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:34:40 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:34:40 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:34:40  InnoDB: Starting shutdown...
    140103  2:34:41  InnoDB: Shutdown completed; log sequence number 1073050278
    140103  2:34:41 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:34:41 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:34:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:34:42 [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.
    140103  2:34:43 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:34:43 InnoDB: The InnoDB memory heap is disabled
    140103  2:34:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:34:43 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:34:43 InnoDB: Using Linux native AIO
    140103  2:34:43 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:34:43 InnoDB: Completed initialization of buffer pool
    140103  2:34:43 InnoDB: highest supported file format is Barracuda.
    140103  2:34:43  InnoDB: Waiting for the background threads to start
    140103  2:34:44 InnoDB: 5.5.34 started; log sequence number 1073050278
    140103  2:34:44 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:34:44 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:34:44 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:34:44 [Note] Event Scheduler: Loaded 0 events
    140103  2:34:44 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:34:45 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:34:45 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:34:45  InnoDB: Starting shutdown...
    140103  2:34:45  InnoDB: Shutdown completed; log sequence number 1073050278
    140103  2:34:45 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:34:45 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:34:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:34:58 [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.
    140103  2:34:58 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:34:58 InnoDB: The InnoDB memory heap is disabled
    140103  2:34:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:34:58 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:34:58 InnoDB: Using Linux native AIO
    140103  2:34:58 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:34:58 InnoDB: Completed initialization of buffer pool
    140103  2:34:58 InnoDB: highest supported file format is Barracuda.
    140103  2:34:58  InnoDB: Waiting for the background threads to start
    140103  2:34:59 InnoDB: 5.5.34 started; log sequence number 1073050288
    140103  2:34:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:34:59 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:34:59 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:34:59 [Note] Event Scheduler: Loaded 0 events
    140103  2:34:59 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:35:32 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:35:32 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:35:34  InnoDB: Starting shutdown...
    140103  2:35:36  InnoDB: Shutdown completed; log sequence number 1073053611
    140103  2:35:36 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:35:36 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:35:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:35:48 [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.
    140103  2:35:48 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:35:48 InnoDB: The InnoDB memory heap is disabled
    140103  2:35:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:35:48 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:35:48 InnoDB: Using Linux native AIO
    140103  2:35:48 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:35:48 InnoDB: Completed initialization of buffer pool
    140103  2:35:48 InnoDB: highest supported file format is Barracuda.
    140103  2:35:48  InnoDB: Waiting for the background threads to start
    140103  2:35:49 InnoDB: 5.5.34 started; log sequence number 1073054298
    140103  2:35:49 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:35:49 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:35:49 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:35:50 [Note] Event Scheduler: Loaded 0 events
    140103  2:35:50 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103 02:45:09 mysqld_safe A mysqld process already exists
    140103  2:45:13 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:45:13 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:45:13  InnoDB: Starting shutdown...
    140103  2:45:13  InnoDB: Waiting for 4 pages to be flushed
    140103  2:45:14  InnoDB: Shutdown completed; log sequence number 1073065414
    140103  2:45:14 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:45:14 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:45:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:45:14 [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.
    140103  2:45:14 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:45:14 InnoDB: The InnoDB memory heap is disabled
    140103  2:45:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:45:14 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:45:14 InnoDB: Using Linux native AIO
    140103  2:45:14 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:45:14 InnoDB: Completed initialization of buffer pool
    140103  2:45:14 InnoDB: highest supported file format is Barracuda.
    140103  2:45:15  InnoDB: Waiting for the background threads to start
    140103  2:45:16 InnoDB: 5.5.34 started; log sequence number 1073065414
    140103  2:45:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:45:16 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:45:16 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:45:16 [Note] Event Scheduler: Loaded 0 events
    140103  2:45:16 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:54:40 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:54:40 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:54:42  InnoDB: Starting shutdown...
    140103  2:54:44  InnoDB: Shutdown completed; log sequence number 1073129608
    140103  2:54:44 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:54:44 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:54:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:54:56 [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.
    140103  2:54:56 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:54:56 InnoDB: The InnoDB memory heap is disabled
    140103  2:54:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:54:56 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:54:56 InnoDB: Using Linux native AIO
    140103  2:54:56 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:54:56 InnoDB: Completed initialization of buffer pool
    140103  2:54:56 InnoDB: highest supported file format is Barracuda.
    140103  2:54:56  InnoDB: Waiting for the background threads to start
    140103  2:54:57 InnoDB: 5.5.34 started; log sequence number 1073130525
    140103  2:54:57 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:54:57 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:54:57 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:54:57 [Note] Event Scheduler: Loaded 0 events
    140103  2:54:57 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:54:58 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:54:58 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:54:58  InnoDB: Starting shutdown...
    140103  2:55:00  InnoDB: Shutdown completed; log sequence number 1073130535
    140103  2:55:00 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:55:00 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:55:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:55:12 [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.
    140103  2:55:12 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:55:12 InnoDB: The InnoDB memory heap is disabled
    140103  2:55:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:55:12 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:55:12 InnoDB: Using Linux native AIO
    140103  2:55:12 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:55:12 InnoDB: Completed initialization of buffer pool
    140103  2:55:12 InnoDB: highest supported file format is Barracuda.
    140103  2:55:12  InnoDB: Waiting for the background threads to start
    140103  2:55:13 InnoDB: 5.5.34 started; log sequence number 1073130545
    140103  2:55:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:55:13 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:55:13 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:55:14 [Note] Event Scheduler: Loaded 0 events
    140103  2:55:14 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  2:55:47 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140103  2:55:47 [Note] Event Scheduler: Purging the queue. 0 events
    140103  2:55:49  InnoDB: Starting shutdown...
    140103  2:55:50  InnoDB: Shutdown completed; log sequence number 1073132422
    140103  2:55:50 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140103 02:55:50 mysqld_safe mysqld from pid file /var/lib/mysql/HostName.pid ended
    140103 02:56:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  2:56:02 [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.
    140103  2:56:02 [Note] Plugin 'FEDERATED' is disabled.
    140103  2:56:02 InnoDB: The InnoDB memory heap is disabled
    140103  2:56:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  2:56:02 InnoDB: Compressed tables use zlib 1.2.3
    140103  2:56:02 InnoDB: Using Linux native AIO
    140103  2:56:02 InnoDB: Initializing buffer pool, size = 128.0M
    140103  2:56:02 InnoDB: Completed initialization of buffer pool
    140103  2:56:02 InnoDB: highest supported file format is Barracuda.
    140103  2:56:02  InnoDB: Waiting for the background threads to start
    140103  2:56:03 InnoDB: 5.5.34 started; log sequence number 1073132422
    140103  2:56:03 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  2:56:03 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  2:56:03 [Note] Server socket created on IP: '0.0.0.0'.
    140103  2:56:03 [Note] Event Scheduler: Loaded 0 events
    140103  2:56:03 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103 03:05:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140103  3:05:03 [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.
    140103  3:05:03 [Note] Plugin 'FEDERATED' is disabled.
    140103  3:05:03 InnoDB: The InnoDB memory heap is disabled
    140103  3:05:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140103  3:05:03 InnoDB: Compressed tables use zlib 1.2.3
    140103  3:05:03 InnoDB: Using Linux native AIO
    140103  3:05:03 InnoDB: Initializing buffer pool, size = 128.0M
    140103  3:05:03 InnoDB: Completed initialization of buffer pool
    140103  3:05:03 InnoDB: highest supported file format is Barracuda.
    InnoDB: Log scan progressed past the checkpoint lsn 1073198309
    140103  3:05:03  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 1073204544
    140103  3:05:28  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
    InnoDB: Apply batch completed
    140103  3:05:29  InnoDB: Waiting for the background threads to start
    140103  3:05:30 InnoDB: 5.5.34 started; log sequence number 1073204544
    140103  3:05:30 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140103  3:05:30 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140103  3:05:30 [Note] Server socket created on IP: '0.0.0.0'.
    140103  3:05:30 [Note] Event Scheduler: Loaded 0 events
    140103  3:05:30 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140103  3:15:15 [Warning] IP address '209.190.56.85' has been resolved to the host name '**HostName**', which resembles IPv4-address itself.
    140103  3:15:15 [Warning] IP address '209.190.56.85' has been resolved to the host name '**HostName**', which resembles IPv4-address itself.

  4. #4
    Join Date
    Sep 2013
    Posts
    48
    and /etc/my.cnf:

    Code:
    [mysqld]
    max_connections=1000
    innodb_file_per_table=1
    local-infile=0
    read_rnd_buffer_size=5376K
    read_buffer_size=8M
    wait_timeout=100
    join_buffer_size=8M
    sort_buffer_size=8M
    open_files_limit=50000
    interactive_timeout=100
    max_allowed_packet=32M
    key_buffer=512M
    default-storage-engine=MyISAM
    [mysql]
    no-auto-rehash
    [myisamchk]
    sort_buffer=512M
    read_buffer=128M
    write_buffer=128M
    key_buffer=512M
    [isamchk]
    sort_buffer=512M
    read_buffer=128M
    write_buffer=128M
    key_buffer=512M
    [mysqlhotcopy]
    interactive-timeout
    [safe_mysqld]
    err-log="/var/log/mysqld.log"
    [mysqldump]
    max_allowed_packet=32M

  5. #5
    Join Date
    Dec 2011
    Location
    Tulsa, OK
    Posts
    353
    What happens when you run?

    /etc/init.d/mysqld start
    OCOSA Communications | Since 2003
    http://www.ocosa.com
    Hosting, Connectivity, Professional Services

  6. #6
    Join Date
    Sep 2013
    Posts
    48
    [email protected] [~]# /etc/init.d/mysql start
    Starting MySQL [ OK ]

    I have a cPanel server


    When I go to the MySQL Databases faced with the following error I get:

    The MySQL server is currently offline.

    Error while connecting to MySQL: #28000Access denied for user 'root'@'localhost' (using password: YES)

    The new server is newly installed.
    But the sites are connected to the database.
    Please Help

  7. #7
    Join Date
    May 2013
    Location
    India
    Posts
    748
    Try to reset the MySQL root password from WHM. Then make sure the same password is updated to /root/.my.cnf as well. That may help to resolve the issue.

  8. #8
    Join Date
    Dec 2011
    Location
    Tulsa, OK
    Posts
    353
    Seems like your cPanel is not syncing right.
    OCOSA Communications | Since 2003
    http://www.ocosa.com
    Hosting, Connectivity, Professional Services

  9. #9
    Join Date
    Sep 2013
    Posts
    48
    I change root password but :

    MySQL password change failed!!
    A forced reset will now be attempted.
    ..found binary [/usr/sbin/mysqld]..
    Waiting for mysql to terminate.....Done
    Waiting for mysql to restart.....Done
    Waiting for mysql to terminate.....Done
    Restarting MySQL ....
    Waiting for mysql to restart......finished.

    mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/*hostname*.pid) running as root with PID 23436 (process table check method)
    mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/*hostname*.err --open-files-limit=50000 --pid-file=/var/lib/mysql/*hostname*.pid) running as mysql with PID 23699 (pidfile check method)

    mysql has failed, please contact the sysadmin (result was "mysql is not running").
    Done
    The MySQL root password has been changed.
    You have successfully changed “root”’s MySQL password.

    What do I do?

  10. #10
    Join Date
    Sep 2013
    Posts
    48
    Quote Originally Posted by ocosa View Post
    Seems like your cPanel is not syncing right.
    Well I do now?

  11. #11
    Join Date
    Dec 2011
    Location
    Tulsa, OK
    Posts
    353
    Well, did you have any server issues recently. Going back and reading your logs in depth sounds more like an InnoDB corruption.

    Quick Google search popped up this:

    http://forums.cpanel.net/f5/mysql-fa...200392-p2.html

    This might help you.
    OCOSA Communications | Since 2003
    http://www.ocosa.com
    Hosting, Connectivity, Professional Services

  12. #12
    Join Date
    Dec 2005
    Location
    United States
    Posts
    503
    Check your MySQL logs /var/log/mysql.
    Jumpto Media | Your Technology Experts!
    ■ Experts in setting up, configuring, securing, and managing Linux & Windows servers.
    ■ Experts with almost all control panels, scripts, apps, and softwares.
    ■ Experts Guaranteed Work.

  13. #13
    Join Date
    Sep 2013
    Posts
    48
    Quote Originally Posted by ocosa View Post
    Well, did you have any server issues recently. Going back and reading your logs in depth sounds more like an InnoDB corruption.

    Quick Google search popped up this:

    http://forums.cpanel.net/f5/mysql-fa...200392-p2.html

    This might help you.
    Thanks
    Code:
    [email protected] [~]# mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.5.34-cll MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> \u mysql
    No connection. Trying to reconnect...
    Connection id:    1
    Current database: *** NONE ***
    
    Database changed
    mysql> update user set password=PASSWORD("7463574635") where User='root';
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id:    2
    Current database: mysql
    
    Query OK, 0 rows affected (0.01 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    
    mysql> flush privileges;
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id:    1
    Current database: mysql
    
    Query OK, 0 rows affected (0.04 sec)
    
    mysql> quit
    Bye
    [email protected] [~]# /etc/init.d/mysql stop
    Shutting down MySQL..The server quit without updating PID file (/var/lib/mysql/*hostname*.pid).                               [FAILED]
    [email protected] [~]# /etc/init.d/mysql start
    Starting MySQL                                             [  OK  ]
    But it did not work and the problem was solved.
    Please Help

  14. #14
    Join Date
    Jan 2004
    Location
    Texas, United States
    Posts
    131
    Nixtree gave the solution to you. Your MySQL root password is most definitely out of sync with WHM.

    Have you already followed that step "correctly" yet? if you have and it didn't help. PM and i'll further help you out.

  15. #15
    Join Date
    Jul 2003
    Location
    Earth
    Posts
    1,692
    Thread moved from Managed Hosting and Services forum to Hosting Security and Technology.

    DirectorioVPS List of VPS plans around the world
    ComunidadHosting The Largest Web Hosting Forum In Spanish!

Similar Threads

  1. Replies: 23
    Last Post: 09-05-2013, 12:50 AM
  2. MYSQL Is Offline, need help ASAP!
    By breatheheavy in forum Systems Management Requests
    Replies: 6
    Last Post: 03-07-2012, 04:21 PM
  3. The MySQL server is currently offline.
    By kteo in forum Dedicated Server
    Replies: 7
    Last Post: 03-03-2012, 07:44 AM
  4. Replies: 11
    Last Post: 06-30-2008, 01:11 PM
  5. MySQL monitor shows MySQL as offline when it's not
    By surrealer in forum Hosting Security and Technology
    Replies: 11
    Last Post: 01-18-2007, 01:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •