LinuxQuestions.org - MySQL.sock

ok problems were not over, although I got the server running I still could not use it from the command line, I tried several different solutions nothing worked whenever i tried to run any command line programs like mysql or mysqladmin I got the above error.
I have finally cracked the problem wide open, only one thing remains, I write this in the hope that any other newbies like myself who have this problem can avoid the nightmare i have had. I say nightmare, but I love the challenge, that is why I chose a distro which isn't stable, steeper learning curve.

Ok here goes I owe all of this to other forums and other peoples expertise, I merely wanted to collect all of the info pertinent to me in one place.

first step was to kill any processes involving mysql

Code:

> killall mysqld

alternatively hunt and kill using

Code:

> lsof

to list all open files.
then use

Code:

> kill -KILL {pid}

where {pid} is the process ID number of any process of mysql, e.g. safe_mysqld

this should mean that you can start the server on port 3306 using

Code:

> mysql_install_db

> safe_mysqld &

you should NOT get a message saying mysqld ended. if you do your problem ain't the same as mine.

now when i tried to run any tools i was still getting the same old error I was always getting (and getting sick of)
after a little more searching I realised that the problem was that my computer was now called jelly no longer called localhost (the default) and I tried to start mysql with the following line

Code:

> mysql -h jelly

then to my surprise and joy up came

Code:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4 to server version: 3.23.58



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



mysql>

So it does work, with no reinstalling at all.
Next the localhost needs to be set to whatever yours is.