problem starting mysql daemon

linuxandtsm · 04-05-2012, 12:37 PM

Hi all,

I have installed mysql rpms via YUM on CentOS 5 box and trying to start mysql daemon but getting timed out error below

Code:

 /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

but when i check with service commnad it shows mysqld is running

Code:

service mysqld status
mysqld (pid 24915) is running...

and when i try to access mysql via below command and also getting the error

Code:

mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Earlier this system was having mysql running but i had removed those rpms and also the /var/lib/mysql dir.

Please help me!

Kustom42 · 04-05-2012, 12:41 PM

/var/lib/mysql removed?! That contains your mysql table which MySQL needs to run. Take a look at /var/log/messages and /var/log/mysql/mysqld.log(or wherever your my.cnf file has mysql logging set to).

linuxandtsm · 04-05-2012, 12:46 PM

Hi Kustom42,

I removed it after removing old MySql rpms and not after the new install.

Kustom42 · 04-05-2012, 01:32 PM

Nobody can assist you until you provide the information in your mysql log file with the error.