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
alternatively hunt and kill using
to list all open files.
then use
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
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.