LinuxQuestions.org
Register a domain and help support LQ
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 06-23-2007, 01:15 PM   #1
SpellChainz
LQ Newbie
 
Registered: Jun 2007
Posts: 8

Rep: Reputation: 0
mysql "cannot connect to socket error" on Redhat 9


hi

i have installed red hat 9 on my system ...gtk is working but mysql is not working when i connect to sql it gives the message "cannot connect to socket " and donot works can any1 give me some help....
 
Old 06-23-2007, 01:17 PM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,379

Rep: Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963
please do not mark threads as urgent. this is a voluntary site and it is considered rude to demand help. you also haven't said please or thankyou and your title gives no insight at all into the problem you are having. you are also trying to use a distribution that has been obsolete for almost 5 years...
 
Old 06-23-2007, 02:29 PM   #3
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,066

Rep: Reputation: 295Reputation: 295Reputation: 295
Do you start the MySQL server? Also, Red Hat 9 is old as the hills -- try running Fedora 7 or CentOS instead.
 
Old 06-24-2007, 10:11 AM   #4
SpellChainz
LQ Newbie
 
Registered: Jun 2007
Posts: 8

Original Poster
Rep: Reputation: 0
hello

i have checked mysql in add remove programs its already checked (I
selected mysql when i installed red hat 9).


Problem: I am getting the following error when I try to run mysql.
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'

and i can not mount my usb in red hat 9 ..as its a big probelm for
me....

plz do reply ..
thnxx
 
Old 06-24-2007, 11:17 AM   #5
Four
Member
 
Registered: Aug 2005
Posts: 298

Rep: Reputation: 30
Quote:
Originally Posted by SpellChainz
hello

i have checked mysql in add remove programs its already checked (I
selected mysql when i installed red hat 9).


Problem: I am getting the following error when I try to run mysql.
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'

and i can not mount my usb in red hat 9 ..as its a big probelm for
me....

plz do reply ..
thnxx
type in terminal
pkill mysqld
ps x | grep mysqld
if you see mysqld take the process id on the left and type
kill -s SIGKILL mysqld

next what you want to do is start mysqld. type
mysqld
now try connecting
if that doesn't work kill mysqld as outlined before and start it like so
mysqld --socket=/var/lib/mysql/mysql.sock

if that doesn't work see --datadir and --basedir and set them appropriatly too.
Also be patient thank you
 
Old 06-24-2007, 12:43 PM   #6
SpellChainz
LQ Newbie
 
Registered: Jun 2007
Posts: 8

Original Poster
Rep: Reputation: 0
hello..........

thnxx but my one answer is still pending how do i mount usb in red hat 9 ..i m having data in usb but i can't transfer it ...when i write "mount /dev/hda1 mnt/usb" it gives me the following message "u cannot ur not a root"....
thnnxx....
cheerz
 
Old 06-24-2007, 02:12 PM   #7
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,379

Rep: Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963
you asked a question about mysql, this thread is to answer that question. if you have a question about usb, please ask it in a separate thread, or things get very messy.
 
  


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
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 16 12-10-2012 02:34 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 01:52 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM


All times are GMT -5. The time now is 01:44 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration