MySQL Daemon failed to start

[belveder]

Hello,

I am using CentOS 6.5 on one VPS, and I'm having problems with MySQL service probably.

Code Select Expand

[root@capitano ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]


/var/log/mysqld.log

Code Select Expand


140715 14:24:17  InnoDB: Starting shutdown...
140715 14:24:22  InnoDB: Shutdown completed; log sequence number 14 443916331
140715 14:24:22 [Note] /usr/libexec/mysqld: Shutdown complete

140715 14:24:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140715 14:24:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140715 14:24:23  InnoDB: Initializing buffer pool, size = 8.0M
140715 14:24:23  InnoDB: Completed initialization of buffer pool
140715 14:24:23  InnoDB: Started; log sequence number 14 443916331
140715 14:24:23 [Note] Event Scheduler: Loaded 0 events
140715 14:24:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140715 14:28:25 [Note] /usr/libexec/mysqld: Normal shutdown

140715 14:28:25 [Note] Event Scheduler: Purging the queue. 0 events
140715 14:28:27  InnoDB: Starting shutdown...
140715 14:28:29  InnoDB: Shutdown completed; log sequence number 14 461965541
140715 14:28:29 [Note] /usr/libexec/mysqld: Shutdown complete

140715 14:28:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140715 14:28:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140715 14:28:32  InnoDB: Initializing buffer pool, size = 512.0M
140715 14:28:32  InnoDB: Completed initialization of buffer pool
140715 14:28:32  InnoDB: Started; log sequence number 14 461965541
140715 14:28:32 [Note] Event Scheduler: Loaded 0 events
140715 14:28:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140715 14:29:48 [Note] /usr/libexec/mysqld: Normal shutdown

140715 14:29:48 [Note] Event Scheduler: Purging the queue. 0 events
140715 14:29:48  InnoDB: Starting shutdown...
140715 14:29:53  InnoDB: Shutdown completed; log sequence number 14 467981897
140715 14:29:53 [Note] /usr/libexec/mysqld: Shutdown complete

140715 14:29:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140715 14:30:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140715 14:30:13  InnoDB: Initializing buffer pool, size = 512.0M
140715 14:30:13  InnoDB: Completed initialization of buffer pool
140715 14:30:13  InnoDB: Started; log sequence number 14 467981897
140715 14:30:13 [Note] Event Scheduler: Loaded 0 events
140715 14:30:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140715 14:33:52 [Note] /usr/libexec/mysqld: Normal shutdown

140715 14:33:52 [Note] Event Scheduler: Purging the queue. 0 events
140715 14:33:52  InnoDB: Starting shutdown...
140715 14:33:54  InnoDB: Shutdown completed; log sequence number 14 478829583
140715 14:33:54 [Note] /usr/libexec/mysqld: Shutdown complete

140715 14:33:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140715 14:34:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140715 14:34:04  InnoDB: Initializing buffer pool, size = 512.0M
140715 14:34:04  InnoDB: Completed initialization of buffer pool
140715 14:34:04  InnoDB: Started; log sequence number 14 478829583
140715 14:34:04 [Note] Event Scheduler: Loaded 0 events
140715 14:34:04 [Note] /usr/libexec/mysqld: ready for connections.

140715 14:34:04 [Note] Event Scheduler: Loaded 0 events
140715 14:34:04 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140715 14:37:33 [Note] /usr/libexec/mysqld: Normal shutdown

140715 14:37:33 [Note] Event Scheduler: Purging the queue. 0 events
140715 14:37:35  InnoDB: Starting shutdown...
140715 14:37:40  InnoDB: Shutdown completed; log sequence number 14 490683428
140715 14:37:40 [Note] /usr/libexec/mysqld: Shutdown complete

140715 14:37:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended





140715 14:22:02 [Note] Event Scheduler: Purging the queue. 0 events
140715 14:22:04  InnoDB: Starting shutdown...
140715 14:22:08  InnoDB: Shutdown completed; log sequence number 14 435519023
140715 14:22:08 [Note] /usr/libexec/mysqld: Shutdown complete

140715 14:22:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140715 14:22:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140715 14:22:11  InnoDB: Initializing buffer pool, size = 8.0M
140715 14:22:11  InnoDB: Completed initialization of buffer pool
140715 14:22:11  InnoDB: Started; log sequence number 14 435519023
140715 14:22:11 [Note] Event Scheduler: Loaded 0 events
140715 14:22:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140715 14:24:15 [Note] /usr/libexec/mysqld: Normal shutdown

140715 14:24:15 [Note] Event Scheduler: Purging the queue. 0 events
140715 14:24:17  InnoDB: Starting shutdown...
140715 14:24:22  InnoDB: Shutdown completed; log sequence number 14 443916331


Any hint what might be the problem?

I'm using Centos Webpanel as well.

Thanks.

[Sandeep]

what is the version of mysql ?

[belveder]

mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1


I can't even load CentOS Web Panel, because MySQL is not working.

Can anyone please assist?

[belveder]

Can I, for example, reinstall mysql on VPS, without losing existing databases, and would that fix this issue?

[Sandeep]

i'll recommend you to install mariadb

Installer with MySQL version 5.1

Code Select Expand

cd /usr/local/src
wget http://centos-webpanel.com/cwp-latest
sh cwp-latest

Installer with MARIA-DB 10.1

Code Select Expand

cd /usr/local/src
wget http://centos-webpanel.com/cwp-latest
sh cwp-latest -d mariadb

take backup of your database

[belveder]

Is there any way to fix this problem with MySQL Daemon?

All of the packages came with CWP installation and I didn't change anything.

Any assistance would be appreciated since my websites are useless now.

[Administrator]

your issue should be investigate by the linux support staff, you should contact your hosting provider our our managed support for assistance.

[belveder]

Hello,

What exactly from the list here: http://centos-webpanel.com/support-services

would be enough so you can take a look at my VPS?

[Igor S.]

Hello.

For one question/issue you should using "One Time support".

[pixelpadre]

I woke up today and was faced with the same problem.  mysql daemon failed to start

[Igor S.]

Hello.

Contact to your hosting support or CWP managed support.
It could have many reasons.

I woke up today and was faced with the same problem.  mysql daemon failed to start

[pixelpadre]

Gosh, I never thought of that!  Thanks for the helpful advise.

[pixelpadre]

For whatever reason, mysql crash.  Not sure if it was insufficient memory or if it was unnatural intervention by others.

But the way I was able to restart it was to rename the 3 files in mysql directory. (/var/lib/mysql)

ibdata1, ib_logfile0 and  ib_logfile1

Once that are renamed you should be able to shutdown or restart sql.  The bad news is, you may have lost all of your database tables like I did.  In the same directory, peak into one of your database folders and see if the tables are there.  If they are missiing some tables then you are going to have to import your tables from shell if they are large.  I copied the large dbase files into my server /tmp directory and then used the import command.  The key thing is to have a backup of my sql.  I fortunately had them in my server /backups directory.

[locvfx]

Just remove mysql and reinstall it

service mysqld stop
yum remove mysql
yum --enablerepo=remi install mysql-server
service mysqld start

Go ahead if you want to Upgrage to 5.7

service mysqld stop
yum install http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
yum install mysql
service mysqld start
mysql_upgrade
chkconfig mysqld on

[locvfx]

If you are facing the problem 'Access denied for user root' , you need to reset your root password

start mysql service in safe mode

service mysqld stop
mysqld_safe --skip-grant-tables

run SQL commands

use mysql;
SET GLOBAL default_password_lifetime = 0;
SET PASSWORD = PASSWORD('YOUR_PASSWORD_HERE');
FLUSH PRIVILEGES;

Note: your password must have enough security level (capital letter, small letter, number,and special character *#..)

update your CWP password, the location of theses files:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnf

nano /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
nano /root/.my.cnf

Note: change your password in two files above

Finally, start your mysqld

service mysqld start

Or reboot your server if necessary