after creating a new partition in my ubuntu(which was mounted on media)...my mysql server stop running. If I do a "sudo /etc/init.d/{service} start it is giving an error mysql changed to upstart stop and it cannot start..also on the terminal when typing the command mysql -u root -p its throwing an error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). when i checked /var/run/mysqld/mysql.sock...it was missing from there...may i know what will be the cause...is it due to wrongly mounted partition? how will i resolve it?

Hi
If u don,t have that file on that place then, u create that manualy and restart the service and try to reset the root password...
thx

yup i did dat.....even i tried a lot on /etc/mysql/my.cnf file....der was no luck...and the main error i have noticed that my eth0 connection was not detecting a that time.

you will not be able to connect to mysql server unless it is running and the .sock file has been created.
Where is your .err log??
Can you tail that log after an attempt to start the server and paste them here please

Hi,

Could you please give me the mysql error log to analyze further? Also check give me the following commands output.

1.df -h
2.fdisk -l
3.ls -alt /


Thanks,
Jai