[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
Site Admin
Posts: 33202
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.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
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
Site Admin
Posts: 33202
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
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
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: 1357
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
Site Admin
Posts: 33202
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.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
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