Google Plus

mysqld doesen`t start,what can i do?

Written by Mel Kham on . Posted in Frequently Asked Questions

 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

Related posts:

  1. HowTo install MySQL on AIX 5.3
  2. MySQL recover root Password
  3. install apache2 php and mysql in ubuntu

8 Comment(s)

Mel Kham

Founder of Unixmen, Living in Amsterdam. Am working in my free time to help people to understand the Opensource and to explain them in easy way how to make the fist steps to the the light. Working day and night with my Co-founder Zinovsky to keep this website live even with less resources.
  • kalyan

    :D This is grate tutorial/solution..
    Its really working fine

    Thank u,

  • Poornima

    I got the same error when I tried to start MySQL but by log file contains something like this:

    080401 05:33:29 mysqld started
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    080401 5:33:29 InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait…
    080401 5:33:30 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait…
    080401 5:33:30 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait…
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    080401 5:33:30 InnoDB: Started; log sequence number 0 0
    080401 5:33:30 [Note] /usr/libexec/mysqld: ready for connections.
    Version: ’5.0.22′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
    080401 6:08:48 [Note] /usr/libexec/mysqld: Normal shutdown

    080401 6:08:48 InnoDB: Starting shutdown…
    080401 6:08:49 InnoDB: Shutdown completed; log sequence number 0 43655
    080401 6:08:49 [Note] /usr/libexec/mysqld: Shutdown complete

    080401 06:08:49 mysqld ended

    080401 06:13:17 mysqld started
    080401 6:13:17 InnoDB: Started; log sequence number 0 43655
    080401 6:13:17 [Note] /usr/libexec/mysqld: ready for connections.
    Version: ’5.0.22′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
    080401 8:14:25 [Note] /usr/libexec/mysqld: Normal shutdown

    080401 8:14:25 InnoDB: Starting shutdown…
    080401 8:14:26 InnoDB: Shutdown completed; log sequence number 0 43655
    080401 8:14:26 [Note] /usr/libexec/mysqld: Shutdown complete

    080401 08:14:26 mysqld ended

    Soo do you think I should follow the same procedure?

    Thanx in advance..it will be a great help if you can solve it!

  • Poornima

    Couldnt post in the main part of the log file! Here it goes…

    Number of processes running now: 0
    080503 14:51:33 mysqld restarted
    080503 14:51:33 InnoDB: Started; log sequence number 0 43655
    080503 14:51:33 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 28)
    080503 14:51:33 [ERROR] Can’t start server: can’t create PID file: No space left on device

    But I do have lot of space in my machine. Sp What do I do?

  • pirat9

    please follow the steps one by one ; and post completely the logs of the issue in the forum

  • Anonymous

    hello please help me releive from this error… i installed mysql server and client package. when i start my mysql by service mysql start. it throw follwing error

    Starting mysqld daemon with databases from /var/lib/mysql
    090812 16:01:44 mysqld ended
    :(

  • pirat9

    Hi Anonymous ;
    is My tutorial not working for you ?

  • barf

    Thanks for the tip. Care to explain why the first yum install of this software didn’t work.

  • David Bass

Like us on Facebook

This week Top Posts

Write for us

Recent Posts

Recent Posts

Recent Comments

Edson Carlos

|

In debian no found. I need link download install in linux debian

jacky can

|

You can actually unzip your secret archive by leaving out the -t option, instead using:

unzip newPhoto.jpg

DragonFartOutLoud

|

it went to china.

DragonFartOutLoud

|

great review! i’ve been using it as my main OS since Beta 1 release. its been a awesome ride so far :)

jet li

|

i try the method, and i unzip the image contain zip secret, i dont find the file that i was hide, where it go? and how to open it? :s

 

Favorite Links

Unixmen Archive

Tags Cloud

android apache browser Centos chrome Debian eyecandy Fedora firefox games gaming gnome google karmic koala kde libreoffice Linux linux distribution LinuxMint lucid lynx maverick meerkat media player mysql Natty Narwhal news oneiric ocelot openoffice opensource opensuse oracle ppa Precise Pangolin release RHEL security server software themes tools ubuntu unix upgrade virtualbox windows wine

Unixmen Twitts

IDG Tech Network
Copyright © 2008-2013 Unixmen.com .
Maintained by Anblik .