Page 3 of 4
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/14 06:36:33
by RoxXxerSL
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
message appears as MySQL daemon is not running.
Pls Help me to solve this MySQL problem.
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/14 10:02:21
by TrevorH
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.
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/14 11:33:31
by RoxXxerSL
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
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/14 12:35:56
by TrevorH
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
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/15 02:57:49
by RoxXxerSL
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.
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/15 05:54:12
by Whoever
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.
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/15 06:40:35
by RoxXxerSL
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.
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/15 06:47:06
by gerald_clark
You could run "rpm --setperms" for each file listed in "rpm -qa".
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/15 12:21:57
by TrevorH
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.
Re: [SOLVED] CentOS 6.5 - MySQL Daemon failed to start.
Posted: 2015/02/16 04:26:01
by RoxXxerSL
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 ]
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'. ? ?