Apache Friends Support Forum

Hello. I hope you guys can help me out here as I'm literally at the end of my tether. I accidentally changed a password while playing around in phpmyadmin, and now it has completely locked me out and no matter what I try, I just can't get it working again.

I've tried just about every solution Google has to offer and nothing is working out for me. I've edited the config file, I've re-installed Xampp, I've re-installed mysql, and still I get this annoying message every time. I think I've completely messed it up now.

------------------------------------------

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Connection for controluser as defined in your configuration failed.

------------------------------------------

I'm running Xampp 1.7.3 on Ubuntu 10.4.

How do I go about fixing this, or maybe a better option would be to just wipe the lot and start again. But how?

any help at all will be greatly appreciated. Thanks.

did you gefork 'root' ???

or some other user's password???

Good Luck

Thanks for the reply.

gefork? Sorry, I don't understand.

What I did was click on 'generate password'. I assumed it was only for that database, but as it turns out it's for the whole of mysql. I have no idea what the password is. But anyway, I reinstalled mysql and it asked me for another password. which I entered, but even so, it's still not working.

It's driving me mad. How can I wipe everything? It seems that even if I reinstall, it still remembers the old password.

I just want the whole thing to go away now. I've accepted that I've lost my old databases, that's not a problem. I just want it working again, but no matter what I try, it just won't bloody do it. I'm moments away from reinstalling Ubuntu, because I need this working asap.

Thanks again for any help.

gefork = destroy LOL its a polite version of f**k up.

If it was all of MySQL then it was the 'root' PW.

MySQL has a special command line option to fix 'root' --skip-grant-tables

I will have a recover recipe in just a bit. or you can read this post elsewhere they have the jist of the thing, be sure to read down to MeanderingCode's post he has the right fixes

http://goodsarves.blogspot.com/2010/07/ ... xampp.html

Good Luck

Thanks for the link, but It's not explained very well.

Look, I'm stupid. Incredibly stupid. So stupid, that things like this have to be explained like you're talking to a 5 year old. I don't get step 2. It's not working. What exactly in step 2 do I type into the terminal? It just says there's an error 1045: access denied.

Sorry to burden you with my stupidity, but you're my only hope right now. Thanks for any help.

Is there any way I can just wipe all trace of mysql off this god damn pc, and start a fresh? It seems a bit pointless mucking around with passwords when there's no databases there anyway.

OK -

Assuming you are on Ubuntu - start Term/Console

Code: Select all

su
(enter your superuser password)
 rm -rf /opt/lampp

poof - all gone!

If you didn't do this previously its why things were still there.

Good Luck

I've done this twice now and I still get the same error message. What's going on? Can I not just remove everything? And I mean everything! All traces of xampp, all traces of mysql, all passwords and all databases....EVERYTHING! I just want it all to go away. What files do I need to delete? No matter what I try, I get the same error message over and over again. Nothing is working.

I think I would be better off just deleting Ubuntu and starting again. It sounds extreme, but I've run out of ideas. Why does it have to come to this? Is there no better way to just reset everything? EVERYTHING!!!!!!!

what error message are you getting in Term???

Maybe the best thing would be to just leave it all for today ~ its not going anywhere ~

Good Luck

Fair enough. Thanks anyway.

Finally sorted. Here's how I completely removed mysql:

- aptitude remove mysql-client
- aptitude remove mysql-server
- aptitude remove mysql-common

- rm -rf /etc/mysql
- find / -iname ‘mysql*’ -exec rm -rf {} \;

I then did a clean install and everything works fine now. Thanks for your help.