Author Topic: MySQL Daemon failed to start  (Read 6447 times)

0 Members and 2 Guests are viewing this topic.

Offline
*
MySQL Daemon failed to start
« on: March 24, 2016, 12:38:59 PM »
Hello,

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

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

/var/log/mysqld.log

Code: [Select]
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.

Offline
*****
Re: MySQL Daemon failed to start
« Reply #1 on: March 24, 2016, 01:53:46 PM »
what is the version of mysql ?

Offline
*
Re: MySQL Daemon failed to start
« Reply #2 on: March 24, 2016, 04:18:11 PM »
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?

Offline
*
Re: MySQL Daemon failed to start
« Reply #3 on: March 24, 2016, 04:51:11 PM »
Can I, for example, reinstall mysql on VPS, without losing existing databases, and would that fix this issue?

Offline
*****
Re: MySQL Daemon failed to start
« Reply #4 on: March 25, 2016, 03:57:08 AM »
i'll recommend you to install mariadb

Installer with MySQL version 5.1

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

Installer with MARIA-DB 10.1

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

take backup of your database


Offline
*
Re: MySQL Daemon failed to start
« Reply #5 on: March 25, 2016, 09:47:09 AM »
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.

Offline
*
Re: MySQL Daemon failed to start
« Reply #6 on: March 25, 2016, 09:53:06 AM »
your issue should be investigate by the linux support staff, you should contact your hosting provider our our managed support for assistance.
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: MySQL Daemon failed to start
« Reply #7 on: March 25, 2016, 01:52:42 PM »
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?


Offline
*****
Re: MySQL Daemon failed to start
« Reply #8 on: March 28, 2016, 03:32:28 PM »
Hello.

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

Offline
***
Re: MySQL Daemon failed to start
« Reply #9 on: June 06, 2016, 02:19:48 PM »
I woke up today and was faced with the same problem.  mysql daemon failed to start

Offline
*****
Re: MySQL Daemon failed to start
« Reply #10 on: June 14, 2016, 06:18:39 PM »
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

Offline
***
Re: MySQL Daemon failed to start
« Reply #11 on: June 18, 2016, 12:15:34 PM »
Gosh, I never thought of that!  Thanks for the helpful advise.

Offline
***
Re: MySQL Daemon failed to start
« Reply #12 on: June 18, 2016, 12:27:49 PM »
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.

Offline
**
Re: MySQL Daemon failed to start
« Reply #13 on: March 25, 2017, 08:39:39 PM »
Just remove mysql and reinstall it

Quote
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
Quote
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

Offline
**
Re: MySQL Daemon failed to start
« Reply #14 on: March 26, 2017, 05:00:05 AM »
If you are facing the problem 'Access denied for user root' , you need to reset your root password

start mysql service in safe mode
Quote
service mysqld stop
mysqld_safe --skip-grant-tables

run SQL commands
Quote
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
Quote
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




« Last Edit: March 26, 2017, 05:03:39 AM by locvfx »