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....

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...

Do you start the MySQL server? Also, Red Hat 9 is old as the hills -- try running Fedora 7 or CentOS instead.

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

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

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.