mysqld doesen`t start,what can i do?

by
Share this Article: Facebook2Google+0Twitter0LinkedIn0Reddit0Pinterest0StumbleUpon0Digg

 Question :  Mysqld  doesen`t start,what can i do?

Answer : Here is   the ultime   solultion ( tested in  Centos/RHEL/Fedora)

 [root@unixmen local]# /etc/init.d/mysqld    start

Output

Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:  [FAILED]

 

now  we  have  to check  why  in the  logs :

[root@unixmen local]# more  /var/log/mysqld.log 

Output

090410 16:04:55  mysqld started
090410 16:04:55  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: ‘open’.
InnoDB: Cannot continue operation.
090410 16:04:55  mysqld ended

090410 16:22:41  mysqld started
090410 16:22:41  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: ‘open’.
InnoDB: Cannot continue operation.
090410 16:22:41  mysqld ended

 mmmmmmmmmmmmmmmmmmmmmmmm

 

Do  this :


1.

/etc/init.d/mysqld stop

2.

yum -y remove  mysql mysql-server

3.

 rm -rf /var/lib/mysql

4.

 chmod 1777 /tmp

5.

 yum  -y install mysql mysql-server

6.

 /etc/init.d/mysqld restart

 

  now :

[root@unixmen local]# /etc/init.d/mysqld restart

Output

Stopping MySQL:  [FAILED]
Initializing MySQL database:  Installing MySQL system tables…
OK
Filling help tables…
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h unixmen password ‘new-password’
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[  OK  ]
Starting MySQL:  [  OK  ]
[root@unixmen local]#

 

Congratulation : Is working :)

For questions please refer to our Q/A forum at : http://ask.unixmen.com/

Share this Article: Facebook2Google+0Twitter0LinkedIn0Reddit0Pinterest0StumbleUpon0Digg