Ah, sorry for double/quick/self replying post. Apparently they set up a table prefix and it wasn't jos_users, but <prefix>_users.
Thank you very very very much for your help! On Tue, Nov 10, 2009 at 1:08 PM, Brian O'Connor <gatzby...@gmail.com> wrote: > Hello, > > Sorry for the late reply, there was something wrong with the phpMyAdmin > setup on the server. > > I changed the md5 hash of the password to what you gave me (as well as > other strings as well), but I'm getting an incorrect username / password. > > Is there something else in the user table that would prevent the admin from > logging in? > > Thanks, > Brian > > On Thu, Nov 5, 2009 at 10:26 PM, Mitch Pirtle <mitch.pir...@gmail.com>wrote: > >> Take a look in configuration.php and grab the following variables: >> >> $host >> $user >> $db >> $password >> >> That is your database access information. Now to change your admin >> password. When you connect to your database, go to a table called >> jos_users and look for the admin user: >> >> select id, name, username, password from jos_users; >> >> Somewhere in those results should be a user called 'admin' in the >> 'username' column. Now change that password to 'changeme' like this, >> and note that I had to run the string 'changeme' through MD5 first as >> all passwords in Joomla are hashed: >> >> update jos_users set password = '4cb9c8a8048fd02294477fcb1a41191a' >> where username = 'admin'; >> >> Now you can login to the Joomla backend as admin / changeme, and >> IMMEDIATELY change your password. >> >> -- Mitch >> >> On Thu, Nov 5, 2009 at 7:42 PM, Brian O'Connor <gatzby...@gmail.com> >> wrote: >> > Hey Guys >> > >> > This is slightly off topic but I don't know where else to turn. >> > >> > I just inherited a client who had their site developed in Joomla, and >> when >> > it came time for the developer to turn over the access things apparently >> > went south and the administrative password for Joomla was never given to >> the >> > client. Now, he can't update his site. He has access to the server >> with >> > all the source code, so I'm relatively sure the password can be reset. >> > However, I'm having trouble finding the variables I need in order to >> connect >> > tot he database and reset the variables. >> > >> > where do I look in order to find out what database information the site >> is >> > using, and once I find that file, what specific variables am I supposed >> to >> > look at? >> > >> > Thanks in advance, >> > Brian O'Connor >> > >> > -- >> > Brian O'Connor >> > >> > _______________________________________________ >> > New York PHP Users Group Community Talk Mailing List >> > http://lists.nyphp.org/mailman/listinfo/talk >> > >> > http://www.nyphp.org/Show-Participation >> > >> _______________________________________________ >> New York PHP Users Group Community Talk Mailing List >> http://lists.nyphp.org/mailman/listinfo/talk >> >> http://www.nyphp.org/Show-Participation >> > > > > -- > Brian O'Connor > -- Brian O'Connor
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
