5 messages in com.mysql.lists.communityRe: Can't Start my MYSQL
FromSent OnAttachments
Chen Abella18 Jan 2006 23:45 
Colin Charles18 Jan 2006 23:55 
Chen Abella19 Jan 2006 00:10 
Colin Charles19 Jan 2006 00:43 
Chen Abella22 Jan 2006 23:47 
Subject:Re: Can't Start my MYSQL
From:Chen Abella (shan@yahoo.com)
Date:01/19/2006 12:10:35 AM
List:com.mysql.lists.community

We have reinstalled the MYSQL and the errors are still the same. And there's no mysql.sock file in my /var/lib/mysql

--- Colin Charles <col@mysql.com> wrote:

Chen Abella wrote:

Chen,

The right list for this is mys@lists.mysql.com

Everytime I start the mysql in the konsole:

# service mysqld start

Starting mysql was failed and an error will display:

Timeout error occured trying to start MySQL Daemon

What version of Linux this? What version of MySQL is this?

And When I type 'mysql -u root -p' with the correct password it would display an error like this:

ERROR 2002 (HY000)"Can't connect to local MySQL server throught socket '/var/lib/mysql.sock' (111)

Yes, this won't work, because you don't have the MySQL server running

And the status of MYSQLD in my service configuration is:

mysqld dead but subsys locked

This error message leads me to believe, typing:

service mysqld restart

This should "solve" your problem. This is similar to running service mysqld stop and service mysqld start, and should remove the stale socket file that exists.

-- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: 45@sip.mysql.com / +46 18 174 400 ext. 4528

Are you MySQL certified? www.mysql.com/certification

-- MySQL Community Mailing List For list archives: http://lists.mysql.com/community To unsubscribe:

http://lists.mysql.com/community?unsub=shan@yahoo.com

chEn

Send instant messages to your online friends http://uk.messenger.yahoo.com