[SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Issues related to applications and software problems
RoxXxerSL
Posts: 11
Joined: 2015/02/14 05:28:49

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by RoxXxerSL » 2015/02/14 06:36:33

I face the discussed problem in CentOS 6.5

Code: Select all

MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]


and I did the chmod changes as advised.

But

Code: Select all

[code][root@cmisserver ~]# getenforce
                                                         Enforcing
[/code]


Other services(ypserv,rpcbind,yppasswdd etc) working well.

phpMyAdmin also Up but cannot login because

Code: Select all

Cannot log in to the MySQL server
message appears as MySQL daemon is not running.

Pls Help me to solve this MySQL problem. :)

User avatar
TrevorH
Forum Moderator
Posts: 31065
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by TrevorH » 2015/02/14 10:02:21

Look in /var/log/mysqld.log for more errors. They may help you to fix the problem yourself or, if not, then post the last 20 or so lines here.
CentOS 6 died in November 2020 - migrate to a new version!
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 is dead, do not use it.
Full time Geek, part time moderator. Use the FAQ Luke

RoxXxerSL
Posts: 11
Joined: 2015/02/14 05:28:49

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by RoxXxerSL » 2015/02/14 11:33:31

Checked /var/log/mysqld.log

Code: Select all

150214 16:44:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150214 16:46:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150214 16:46:56 [Note] Plugin 'FEDERATED' is disabled.
150214 16:46:56 InnoDB: The InnoDB memory heap is disabled
150214 16:46:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150214 16:46:56 InnoDB: Compressed tables use zlib 1.2.3
150214 16:46:56 InnoDB: Using Linux native AIO
^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ib0iEPXa' (Errcode: 13)
150214 16:46:56  InnoDB: Error: unable to create temporary file; errno: 13
150214 16:46:56 [ERROR] Plugin 'InnoDB' init function returned error.
150214 16:46:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150214 16:46:56 [ERROR] Unknown/unsupported storage engine: InnoDB
150214 16:46:56 [ERROR] Aborting

150214 16:46:56 [Note] /usr/libexec/mysqld: Shutdown complete

150214 16:46:56 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

It seems InnoDB error. :( Pls Help

User avatar
TrevorH
Forum Moderator
Posts: 31065
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by TrevorH » 2015/02/14 12:35:56

Looks more like you have a problem with /tmp to me.
^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ib0iEPXa' (Errcode: 13)
Have you changed the permissions on /tmp or created a separate mount point post-install and mounted it on /tmp? The permissions for /tmp should be chmod 1777 /tmp
CentOS 6 died in November 2020 - migrate to a new version!
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 is dead, do not use it.
Full time Geek, part time moderator. Use the FAQ Luke

RoxXxerSL
Posts: 11
Joined: 2015/02/14 05:28:49

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by RoxXxerSL » 2015/02/15 02:57:49

Since I am new to CentOS and lack of knowledge I did a silly mistake two months ago. That is ,someone has deleted the /usr directory from the server. Then I installed the server again from the scratch.After that for the betterment , I changed the permissions to 700 except the /home . Then All the services could not be restarted. Then I changed the permissions to 755 (as i remember). Then the ypserv, rpcbind, httpd,yppassword and all the services required at that time restarted well.

I noticed that mysqld could not restarted. But at that time no use of mysql server.

But Today mysql server is wanted. :(

I think you understand the problem.

Please help me ASAP. :) :)

I did , BUT

Code: Select all

chmod 1777 /tmp
[root@cmisserver yp]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
[root@cmisserver yp]#
/var/log/mysqld.log

Code: Select all

150215 08:45:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150215 09:11:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150215  9:11:18 [Note] Plugin 'FEDERATED' is disabled.
150215  9:11:18 InnoDB: The InnoDB memory heap is disabled
150215  9:11:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150215  9:11:18 InnoDB: Compressed tables use zlib 1.2.3
150215  9:11:18 InnoDB: Using Linux native AIO
150215  9:11:18 InnoDB: Initializing buffer pool, size = 128.0M
150215  9:11:18 InnoDB: Completed initialization of buffer pool
150215  9:11:18 InnoDB: highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/error-creating-innodb.html
150215  9:11:18 [ERROR] Plugin 'InnoDB' init function returned error.
150215  9:11:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150215  9:11:18 [ERROR] Plugin 'InnoDB' init function returned error.
150215  9:11:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150215  9:11:18 [ERROR] Unknown/unsupported storage engine: InnoDB
150215  9:11:18 [ERROR] Aborting

150215  9:11:18 [Note] /usr/libexec/mysqld: Shutdown complete

150215 09:11:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
find /var/lib/ -printf '%m %p\n'

Code: Select all

755 /var/lib/mysql

660 /var/lib/mysql/db122135/Publisher.MYD
660 /var/lib/mysql/db122135/Author.frm
660 /var/lib/mysql/db122135/db.opt
660 /var/lib/mysql/db122135/Author.MYD
660 /var/lib/mysql/db122135/Book.MYI
660 /var/lib/mysql/db122135/Book.frm
660 /var/lib/mysql/db122135/Book.MYD
660 /var/lib/mysql/db122135/Author.MYI
660 /var/lib/mysql/db122135/Publisher.frm
700 /var/lib/mysql/ex122030
660 /var/lib/mysql/ex122030/Works.frm
660 /var/lib/mysql/ex122030/db.opt
660 /var/lib/mysql/ex122030/Dept.frm
660 /var/lib/mysql/ex122030/Emp.frm
Please help me ASAP. :) :)

Whoever
Posts: 1232
Joined: 2013/09/06 03:12:10

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by Whoever » 2015/02/15 05:54:12

RoxXxerSL wrote:Since I am new to CentOS and lack of knowledge I did a silly mistake two months ago. That is ,someone has deleted the /usr directory from the server. Then I installed the server again from the scratch.After that for the betterment , I changed the permissions to 700 except the /home . Then All the services could not be restarted. Then I changed the permissions to 755 (as i remember). Then the ypserv, rpcbind, httpd,yppassword and all the services required at that time restarted well.

I noticed that mysqld could not restarted. But at that time no use of mysql server.

But Today mysql server is wanted. :(

I think you understand the problem.

Please help me ASAP. :) :)
Reinstall once more and then, don't mess around with the permissions.

RoxXxerSL
Posts: 11
Joined: 2015/02/14 05:28:49

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by RoxXxerSL » 2015/02/15 06:40:35

Reinstall once more and then, don't mess around with the permissions.

I expect troubleshoot know-hows . If anyone knows how to t-shoot this ,help me. :)

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by gerald_clark » 2015/02/15 06:47:06

You could run "rpm --setperms" for each file listed in "rpm -qa".

User avatar
TrevorH
Forum Moderator
Posts: 31065
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by TrevorH » 2015/02/15 12:21:57

Something like

Code: Select all

for p in $(rpm -qa); do rpm --setperms $p; rpm --setugids $p; done
should reset all perms and ownership for all installed packages back to their defaults.
CentOS 6 died in November 2020 - migrate to a new version!
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 is dead, do not use it.
Full time Geek, part time moderator. Use the FAQ Luke

RoxXxerSL
Posts: 11
Joined: 2015/02/14 05:28:49

Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.

Post by RoxXxerSL » 2015/02/16 04:26:01

It was solved after visit
that was mentioned in the /var/log/mysqld.log . And removed ibdata and ib_logfile files.

So now

Code: Select all

service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                            [  OK  ]
:D

can log into mysql as root but,

Code: Select all

ERROR 1044 (42000): Access denied for user 'root'@'localhost'
So what should be the next step to grant privilege for root'@'localhost'. ? ? :)

Locked

Return to “CentOS 6 - Software Support”