mysql problem

Try this...

http://www.tech-recipes.com/mysql_tips762.html

 

I have same problem today ​

 

So did you see if your socket exists in tmp? Even if you don't know, just run through these commands


cd /var/lib/mysql
touch mysql.sock
chown mysql:mysql mysql.sock
chmod 1777 mysql.sock
ln -s /var/lib/mysql/mysql.sock /tmp
chmod 1777 /tmp
/scripts/mysqlup --force
/etc/rc.d/init.d/mysql restart

 

Hi

Mysql crash.. work within any minute ago, I have changed only a value on my.cnf .. and the try restart.. but crash.

If try to stop or restart nothing happen

I have try code posted but not work.. he freeze at
Preparing ....



all db is down :'(

any help ?

 

I have similar issue however it affects only 1 site.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/xxxxx/public_html/inc/class_db.php on line 12
Error Connecting to MySQL database

I am running mysql 5.0.67

Could it be mysql compatibility issue of the website? We recently migrated that site from a server with mysql 4 to current mysql5


Other info:
socks exists in /tmp/mysql.socks
my.cnf has nothing in it but
[mysqld]
skip-bdb

Thanks!

-John