mysql service does not start [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

开发者_JAVA技巧

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 11 years ago.

Improve this question

The Mysql service on my newly set up development server does not start!

It is running on CentOS 5.

Every time I restart the service, it tells me that MySQL Daemon failed to start.

I have checked in the error log and this is what I see being repeated:

*"110801 11:28:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 196 110801 11:36:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 197 110801 11:36:14 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 198 ^G/usr/libexec/mysqld: File '/var/log/mysql/binary_log.index' not found (Errcode: 13) 199 110801 11:36:14 [ERROR] Aborting"*

mysql.sock file is located inside /var/lib/mysql but when I view the file, it is empty.

owner of the mysql related files is mysql and permissions are 660 or higher.

edit: I have also uninstalled and reinstalled mysql and that did not solve it either.

I am pretty damn stumped! Can anyone help? Mind you, I'm no expert, so if there's something obvious I have missed, punch me where it won't bruise.

Thanks in advance.

EDIT: IT'S BEEN SOLVED!!! It turns out, I had played with the permissions on all files, but on my.cnf. It was set to 755 and that stopped it from being accessed. I switched it to 777 and the service started!! If someone can suggest alternatives to this solution, however, I'm all ears. (Now I can go and have breakfast...) M.