URGENT!!! Pls help to correct the Error while connecting to mysql

SuMoNiNa · 03-24-2009, 12:06 AM

Hi,

I have installed fedora 10 initially mysql was installed. On some instance i removed mysql using yum. I have reinstalled mysql again successfully, but the error i get when trying to invoke mysql is
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The mysql daemon(mysqld) is not visible in /etc/init.d

Pls help,

Thanks

SuMoNiNa

acid_kewpie · 03-24-2009, 03:47 AM

This is not urgent for us, please do not mark it as such. Looks like you've not installed the mysql server, only the client.

TB0ne · 03-24-2009, 10:42 AM

Quote:

Originally Posted by SuMoNiNa

Hi,

I have installed fedora 10 initially mysql was installed. On some instance i removed mysql using yum. I have reinstalled mysql again successfully, but the error i get when trying to invoke mysql is
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The mysql daemon(mysqld) is not visible in /etc/init.d

Pls help,

Thanks

SuMoNiNa

So you removed MySQL, and you're surprised it won't start?? Reinstall the missing server software, or restore your system from backups.

As has been pointed out...this isn't urgent for anyone but you. If you want "urgent" tech support, purchase a supported version of Linux (RedHat Enterprise, SuSE enterprise, etc.), and call them 24/7 with 'urgent' questions. We volunteer our time here, so don't tell us to hurry, because you broke something.

SuMoNiNa · 03-25-2009, 12:53 AM

I am extremely sorry for labelling my post as urgent. As u said i was in a hurry and there was no need for anyone else to be so.

I did not correctly interpret the importance of Urgent in this forum.

Thanks for the whole lot of support provided by the forum.

JaksoDebr · 03-25-2009, 05:20 PM

Quote:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

This error can also be caused if the mysql.sock file has no permission to be accessed by anyone except root and the creating user. MySQL usually runs as it's own user. After removing mysql that user might have been removed as well. Re-installing mysql will give you a new user with 'mysql' as the human-readable name, but the actual user ID (a number) could be different. The mysql.sock is created at runtime, so a standard package updater/remover tool will not remove that file, I guess, that's why it's still around.

Linux Archive