mySQL Fails to start, CentOS 5
I've been desparately searching the internet for help in trying to install mySQL on my CentOS 5 VPS. In trying to install most software, I need mySQL, and for some reason I cannot get it to start. I've tried installing it, removing it and reinstalling it with these commands:
but the following error message still appears:
yum install php-mysql mysql mysql-server
/sbin/chkconfig --levels 235 mysqld on
I tried editing the my.cnf file (I don't know what this is or how exactly to configure it, but I've researched and still don't know how).
[root_at_server01 mysql]# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
The my.cnf file is:
Note: I added the last 4 lines thinking it may help, but now I notice duplicates. I don't know how to configure this file, so help would be greatly appreciated! :)
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
# connection string for MySQL Cluster management tool
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/mysqld.pid
datadir = /var/lib/mysql
basdir = /var/lib/mysql
I checked the log file with
but the log file has no contents in it (it's empty) :?
I am running as root user and no luck, and no idea where to go from here.
I really appreciate any help that anyone can give --- if there's a command you want me to run and post the results, I'll do it!! :D
Thanks alot! :)