Joomla Site - logon details stored where?

[speckytecky]

Can anyone point me toward where the log on details are stored within a Joomla site please. One of my sites seems to have corrupt log on details so I can't currently access back end. I can FTP it and see it on Plesk though.

[powdarrmonkey]

They're in the jos_users table in the database (it may have a slightly different name if you are or aren't using table prefixes).

[speckytecky]

Thanks powdermonkey - this is a newie to me so any further advice from folk on her would be appreciated.

I Googled jos_users and saw about generating a new password. However, I'm a tad stuck on where to go next. My DB is with SWGfL hosted on Linux with Plesk as the interface.

Looking round my Plesk page I can't see where it is I need to go to make the change?

They're in the jos_users table in the database (it may have a slightly different name if you are or aren't using table prefixes).

[powdarrmonkey]

Well you need some way of editing the database tables directly, and I don't know Plesk well any more. Most commonly, phpMyAdmin, which it might have installed already, or you can install it yourself as a web application (it's just PHP).

[rush_tech]

I can get access to it through plesk>>>select databases from the front screen>>>>click on your database from the list>>>>Webadmin should open up phpMyAdmin.

[speckytecky]

Thanks for the help - so far folks

OK, so in I went and edited the password bit on the database but still can't get into the site so am I right in thinking that it was my database password I changed? I get the logon box on the mysite\administrator page but just can't access the control panel as none of the logon / password combinations I try work? Changing the password in the database just doesn't seem to have made any difference.

[SimpleSi]

Sorry if teaching grandma but do you know you have to use a prog to generate an encrypted table entry?

Can't remember details but google tells you how to do it.

Done it myself a few times in the past

regards

Simon

[rush_tech]

I did this a while ago but I think I needed to generate the password as a MD5 string using something like this and paste that string into the password field

[speckytecky]

Thanks SimpleSi - this is a whole new crate of eggs to me so any pointers are taking me to unclimbed heights

Sorry if teaching grandma but do you know you have to use a prog to generate an encrypted table entry?

Can't remember details but google tells you how to do it.

Done it myself a few times in the past

regards

Simon

[moobsuk]

If you are using phpMyAdmin you can run a quick SQL query:

UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin" ;

Where it has new_password obviously type your new one here.
And make sure that the username who's password you want to change is admin.

And you should be good to go.

[speckytecky]

Thanks for all the excellent replies folks - now back in - I'd mark the original as solved but can't get into advanced edit to do so!