Locked out of phpmyadmin. [Solved]

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Locked out of phpmyadmin. [Solved]

Postby Bagshot » 23. February 2012 20:21

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

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.
Bagshot
 
Posts: 7
Joined: 23. February 2012 20:13
Operating System: Ubuntu

Re: Locked out of phpmyadmin.

Postby JonB » 23. February 2012 21:55

did you gefork 'root' ???

or some other user's password???

Good Luck
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Locked out of phpmyadmin.

Postby Bagshot » 23. February 2012 22:02

Thanks for the reply.

gefork? Sorry, I don't understand. :oops:

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

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.
Bagshot
 
Posts: 7
Joined: 23. February 2012 20:13
Operating System: Ubuntu

Re: Locked out of phpmyadmin.

Postby JonB » 23. February 2012 22:35

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Locked out of phpmyadmin.

Postby Bagshot » 23. February 2012 23:02

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.
Bagshot
 
Posts: 7
Joined: 23. February 2012 20:13
Operating System: Ubuntu

Re: Locked out of phpmyadmin.

Postby Bagshot » 23. February 2012 23:09

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.
Bagshot
 
Posts: 7
Joined: 23. February 2012 20:13
Operating System: Ubuntu

Re: Locked out of phpmyadmin.

Postby JonB » 23. February 2012 23:16

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Locked out of phpmyadmin.

Postby Bagshot » 23. February 2012 23:40

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!!!!!!! :evil:
Bagshot
 
Posts: 7
Joined: 23. February 2012 20:13
Operating System: Ubuntu

Re: Locked out of phpmyadmin.

Postby JonB » 24. February 2012 00:10

what error message are you getting in Term???
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Locked out of phpmyadmin.

Postby JonB » 24. February 2012 00:14

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

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Locked out of phpmyadmin.

Postby Bagshot » 24. February 2012 00:18

Fair enough. Thanks anyway.
Bagshot
 
Posts: 7
Joined: 23. February 2012 20:13
Operating System: Ubuntu

Re: Locked out of phpmyadmin.

Postby Bagshot » 24. February 2012 09:57

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.
Bagshot
 
Posts: 7
Joined: 23. February 2012 20:13
Operating System: Ubuntu


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 25 guests