mysql instalation problem
 

ok this is the story I have been trying to set up a mysql server on my computer. I am running mandrake linux 9.1 and I have installed mysql and when I try and set the password i get an error of : 'Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' '(2) Check that mysqld is running and the socket: '/var/lib/mysql/mysql.sock' exist!

I have been trying many differnt things trying to get this to work when I go to the folder that mysql.sock is to be in and it is not there!

if I could get some help that would be so cool!
thank
Steve

Well have you successfully started mysql? It has to be running before you can change passwords or the such.

safe_mysqld &

I have been able to start mysql...when I check my prossesses mysql is running

How are you trying to change the password then when you recieve the error?

when I am trying to change the password I am typing in the commmand prompt as root mysqladmin - u root password
am I just doing something wrong...did I maybe miss something in the install...
I used an RPM package to install so I don't understand why it won't work


never mind I got it to work

my mistake