NYCPHP Meetup

[Brian O'Connor]

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 <gatzby3jr at 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.pirtle at 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 <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
>> >
>> _______________________________________________
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20091110/c262fdf5/attachment.html>