MySql Failed

Installing, Configuring, Troubleshooting server daemons such as Web and Mail
Post Reply
ehaddad
Posts: 2
Joined: 2012/11/13 11:24:58

MySql Failed

Post by ehaddad » 2012/12/08 08:35:28

Dear Support,

As shown below i have an error occured on my mysql database when i was using cameras monitoring system which fully depends on it, i did nothing to the server as this error occured suddenly without any notice known that this server was working just fine for this last month.

My operating system which installed on my server is : CentOS 5.5


LOGs

timeout error occurred trying to start mysql daemon. starting mysql failed
121208 11:13:08 [ERROR] Can't start server : Bind on unix socket: Address already in use
121208 11:13:08 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
121208 11:13:08 [ERROR] Aborting
121208 11:13:08 InnoDB: Starting shutdown...
121208 11:13:09 InnoDB: Shutdown completed; log sequence number 0 43655
121208 11:13:09 [Note] /usr/libexec/mysqld: Shutdown complete


I really appreciate your help and thanks in advance for your support.

Regards,

mecha_godzilla
Posts: 27
Joined: 2010/09/27 23:10:43

MySql Failed

Post by mecha_godzilla » 2012/12/08 23:18:52

The suggestion from those error messages is that the MySQL daemon is already running. If you type

# ps ax | grep -i mysql

at the command line what kind of output do you get? You could also try

# service --status-all | grep -i mysql

Also, whenever the MySQL daemon is stopped the mysql.sock file in the

/var/lib/mysql

directory isn't present.

You could also try running

# netstat -tulnp

to see what services are bound to which ports - the default MySQL port is 3306.

If the MySQL daemon appears to be running but isn't working then you may want to manually kill the process it's associated with, or (perhaps) manually delete the mysql.sock file - although I'm not sure what the effect of this would be so don't do this without seeking the opinion of a better informed person first as instability may result! Can you connect to MySQL from the command line, or through a web application like phpMyAdmin?

Post Reply