LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-24-2009, 01:06 AM   #1
SuMoNiNa
LQ Newbie
 
Registered: Mar 2008
Posts: 9

Rep: Reputation: 0
Unhappy URGENT!!! Pls help to correct the Error while connecting to mysql


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
 
Old 03-24-2009, 04:47 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977Reputation: 1977
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.
 
Old 03-24-2009, 11:42 AM   #3
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 20,717

Rep: Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091
Quote:
Originally Posted by SuMoNiNa View Post
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.
 
Old 03-25-2009, 01:53 AM   #4
SuMoNiNa
LQ Newbie
 
Registered: Mar 2008
Posts: 9

Original Poster
Rep: Reputation: 0
Sorry for labelling the post as URGENT.

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.
 
Old 03-25-2009, 06:20 PM   #5
JaksoDebr
Member
 
Registered: Mar 2009
Distribution: Fedora, Slackware
Posts: 104

Rep: Reputation: 21
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

Last edited by JaksoDebr; 04-02-2009 at 06:23 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
I've got an error massage when i install MySql,urgent novmcgrady Linux - Software 1 05-12-2005 09:37 PM
Error connecting to MySQL from PHP anindyanuri Linux - Software 18 04-24-2005 10:30 AM
mysql error, urgent please help chadi Linux - General 1 11-12-2004 07:56 AM
http 405 error when connecting mysql to Dreamweaver Onemessedupjedi Linux - Software 0 08-15-2004 10:39 PM
Mysql is not connecting from servlet.But connecting from java, help pls Harish_f Linux - General 0 05-08-2002 04:21 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:10 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration