LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   problem starting mysql daemon (https://www.linuxquestions.org/questions/linux-newbie-8/problem-starting-mysql-daemon-938326/)

linuxandtsm 04-05-2012 12:37 PM

problem starting mysql daemon
 
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.


All times are GMT -5. The time now is 12:47 PM.