user / password in database Topic is solved

Need help with the Administration of your Joomla! 2.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
MiKro2019
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Feb 15, 2019 12:56 am

user / password in database

Post by MiKro2019 » Fri Feb 15, 2019 1:04 am

Hi,

complete new to Joomla......

somebody did a web page in Joomla 2.5 a long time for a friend of mine. Now this somebody left town and no word on the username / password for the admin.

We have all other information, database with credentials, FTP, etc, etc.

I found the table ..._users in the database, but there is no chance to find an "MD5" field to change the password, also no username, only two user ID's.
I am now complete confused.
Can somebody help, please....

Thanks

User avatar
CyrusXxX
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Wed Oct 04, 2017 6:23 am
Location: Belgrade Serbia
Contact:

Re: user / password in database

Post by CyrusXxX » Fri Feb 15, 2019 9:24 am

Hello MIKro2019, here is the manual on how to set new password for admin user using mysql database:

https://docs.joomla.org/How_do_you_reco ... assword%3F
Joomla Serbian Latin Coordinator
https://volunteers.joomla.org/joomlers/ ... oran-nesic

Power is knowledge and knowledge is power.
https://regenesiscomputers.com

MiKro2019
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Feb 15, 2019 12:56 am

Re: user / password in database

Post by MiKro2019 » Fri Feb 15, 2019 4:40 pm

Thanks Cyrus,

please see attached picture. This is what I see when I open the "xxx_users" table, no name, no password etc.

What is wrong here???
joomla.png
You do not have the required permissions to view the files attached to this post.

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17431
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: user / password in database

Post by toivo » Fri Feb 15, 2019 5:04 pm

That file is the user table from JEvents, I believe. Your database should have a file called jvr_users, which is the Joomla users table.
Toivo Talikka, Global Moderator

MiKro2019
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Feb 15, 2019 12:56 am

Re: user / password in database

Post by MiKro2019 » Fri Feb 15, 2019 5:10 pm

Thanks, toivo.....

found it now and I will go on with the instructions in the previous post......

MiKro2019
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Feb 15, 2019 12:56 am

Re: user / password in database

Post by MiKro2019 » Fri Feb 15, 2019 5:26 pm

It worked!

Thank you toivo and CyrusXxX!


Locked

Return to “Administration Joomla! 2.5”