Can't reset password using Phpmyadmin Topic is solved

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.
Post Reply
DUVIT
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu May 28, 2020 6:04 pm

Can't reset password using Phpmyadmin

Post by DUVIT » Thu May 28, 2020 6:06 pm

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!!!

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 9999
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Can't reset password using Phpmyadmin

Post by sozzled » Thu May 28, 2020 7:56 pm

See again (and read carefully) the instructions here: https://docs.joomla.org/How_do_you_reco ... e_Database
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
AMurray
Joomla! Champion
Joomla! Champion
Posts: 6467
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Can't reset password using Phpmyadmin

Post by AMurray » Thu May 28, 2020 10:05 pm

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
Regards,
--------------------------------------------------------------
A Murray
Help you I can, yes!. Post your question, you should. Keep it on topic you must!
Use the Forc....Forum Post Assistant my young Padawan!

DUVIT
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu May 28, 2020 6:04 pm

Re: Can't reset password using Phpmyadmin

Post by DUVIT » Fri May 29, 2020 1:01 am

AMurray wrote:
Thu May 28, 2020 10:05 pm
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
sozzled wrote:
Thu May 28, 2020 7:56 pm
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

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20247
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Can't reset password using Phpmyadmin

Post by leolam » Tue Jun 02, 2020 8:39 am

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 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 9999
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Can't reset password using Phpmyadmin

Post by sozzled » Tue Jun 02, 2020 8:46 am

.. deleted by author ..
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20247
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Can't reset password using Phpmyadmin

Post by leolam » Tue Jun 02, 2020 8:49 am

sozzled wrote:
Tue Jun 02, 2020 8:46 am
Careful, @leo: :eek:

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 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 9999
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Can't reset password using Phpmyadmin

Post by sozzled » Tue Jun 02, 2020 8:51 am

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.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20247
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Can't reset password using Phpmyadmin

Post by leolam » Tue Jun 02, 2020 8:52 am

lol

Love you too :)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 9999
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Can't reset password using Phpmyadmin

Post by sozzled » Tue Jun 02, 2020 9:04 am

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.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20247
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Can't reset password using Phpmyadmin

Post by leolam » Tue Jun 02, 2020 10:03 am

sozzled wrote:
Tue Jun 02, 2020 9:04 am
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
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services


Post Reply

Return to “Administration Joomla! 3.x”