MySQL Daemon failed to start.

[mohitengi]

I am not able to start mysql server...when i type command sevice mysqld start it says :--


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

so how to solve this problem ????

[EMOziko]

post /var/log/mysqld.log contnent.

[mohitengi]

all file can't be posted and i can't understand which part to be paste coz i am newbie to linux(fedora)..
.

[EMOziko]

post output of this command:
tail -n 20 /var/log/mysqld.log


p.s. you must be root

[mohitengi]

root@localhost mohit]# tail -n 20 /var/log/mysqld.log
110417 18:37:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110417 18:37:45 InnoDB: Initializing buffer pool, size = 8.0M
110417 18:37:45 InnoDB: Completed initialization of buffer pool
110417 18:37:45 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.
110417 18:37:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
110417 18:54:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110417 18:54:00 InnoDB: Initializing buffer pool, size = 8.0M
110417 18:54:00 InnoDB: Completed initialization of buffer pool
110417 18:54:00 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.
110417 18:54:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[Miikka]

You need to log as root to start mysql.

su -c "service mysqld start"

[EMOziko]

I think this is SELinux problem.
You can turn selinux off. but this is security application and turning it off is not recommended if you are running fedora on server.

you can turn off selinux by changing /etc/selinux/config file

SELINUX=enforcing to SELINUX=permissive

and reboot fedora.

[nostrad]

I have the same problem. I installed Fedora 14. Then I added a new disk and changed the MySQL data directory in my.cnf to point to a folder on this new disk.

I started getting SELinux error messages, which by following the help in those messages I managed to resolve.

But now after a reboot MySQL fails to start, it is something to do with SELinux.

Does documentation exist about how to resolve these errors?

Basically I need to know:

All the steps needed to successfully change the data directory for MySQL, including setting permissions, SELinux commands etc.


Regards,
ND

[Vector]

The guy with the first problem should not be getting those errors on a defualt install; so i assume he did something "different".

The second guy needs this:
http://thesocialexpo.com/?a=WCMS_Art...0693119&page=1

[abhijitsarangi]

please check if you are starting the service as root or not...

[kumardvel]

i am new to linux.
the following command worked for me please try which i got while googled

service mysqld stop
rm -rf /var/lib/mysql/*
service mysqld start
mysql_secure_installation

[osama3030]

i am new to linux.
the following command worked for me please try which i got while googled

service mysqld stop
rm -rf /var/lib/mysql/*
service mysqld start
mysql_secure_installation

Thank you 'kumardvel', I registered only to say thank you, it worked for me after hours and hours of trying google results