Can't reset password using Phpmyadmin Topic is solved

[DUVIT]

Hello I am using Joomla 3.x and I have a big problem.

Back in time with 2.5 I could reset admin password using phpmyadmin users table prefix...

With 3.x it does not work! I tried everything! Can't login to admin panel.

Gives error: Warning
Username and password do not match or you do not have an account yet.

Please help its urgent!!!

[sozzled]

See again (and read carefully) the instructions here: https://docs.joomla.org/How_do_you_reco ... e_Database

[AMurray]

It's the same process in Joomla 3.x as it was for 2.5 (nothing's changed in that respect) - in fact the link given by @sozzled indicates the process is for J! 2.5, 3.x and 4.x

[DUVIT]

It's the same process in Joomla 3.x as it was for 2.5 (nothing's changed in that respect) - in fact the link given by @sozzled indicates the process is for J! 2.5, 3.x and 4.x

See again (and read carefully) the instructions here: https://docs.joomla.org/How_do_you_reco ... e_Database

Ok guys I fixed the problem... Just realized I was editing the wrong _users table...

There was a second page in the tables list and the other _users table did the trick...

Unbelievable :S

[leolam]

Their are no 2 user tables "_users" in the database. You must have leftovers from your Joomla 2.5 migration.

Remove the incorrect table(s) from your database but make a backup first

Leo

[sozzled]

.. deleted by author ..

[leolam]

Careful, @leo:

The OP has "two _user tables", yes ... but one of them is used by the K2 component (_k2_users) and the other one is used by J!

He did not posted that so I am pretty much correct that Joomla has no 2 such tables ;-) Tnx Michael...You had gathered additional info I see

Leo

[sozzled]

I think I confused myself and you may have been right. There have been a couple of topics on this subject this week and the other topic referred to K2 (in the context of J! 1.5). Pardon my intrusion.

[leolam]

lol

Love you too

[sozzled]

However ...

A lot of people don't know how to keep their websites separate. People create two, three ... fifty (or more) websites on their servers and all of these websites use the same database. Sure, separate table prefixes, but everything is plonked into the one place. This may explain why there are "two _user tables".

So, if someone deleted "the other one", they may be crippling "the other one's" website. I'd be careful.

One of these days I'll write an article called something like "How to create a website and keep it at arm's length from all your other websites". I just haven't had the enthusiasm to spend time 'blogging.

[leolam]

One of these days I'll write an article called something like "How to create a website and keep it at arm's length from all your other websites". I just haven't had the enthusiasm to spend time 'blogging.

I might be very interested :-) see my signature

Leo