NYCPHP Meetup

[Mitch Pirtle]

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 <gatzby3jr at 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
>