Admin Login

[benefitdesign]

I was hoping someone could help with our admin login for php pages. Our developer has left the company that built our site, so I have no way of finding out what our admin login is. I have tried searching within the code and cannot find it. Is there any way to reset it?

I need to add/remove some users and without that login I don't know how to do it.

Thanks!

[chrisx84]

delete the user from the database itself, the default user table for qls is qls_users thats if u have db access, u can also remove some users that u need to remove that way as well. If ur able to remove the admin username then recreate it in register.php then once the account is made just go back into the db and modify group_id and mask_id in that username's row in the user table. If u dont have db access then u can do it with a simple php script.
mysql_query("DELETE FROM `qls_users` WHERE username = 'admin' ");
thats a example of what ur asking to do in php. i can provide a full page script on here if u need it.

[jeffr]

Another thought:

You can look in the database in the qls_users table to find out the admin's username. It should be the first one in the table. If you're not sure, look for the username with the mask_id set to 1 and probably the group_id set to 1.

Once you have the Admin's username identified, take a look at it's email address. If it's an email address you don't have access to, change it to yours.

Once you're set with the Admin's email address, run the change_password.php script. You'll get an email allowing you to change the password.

If you don't know the password to the database, check with your webhost. They may be able to reset it for you.

[Douglas]

I suggest the second method. no offense Chris

[Venkatswamy]

I suggest you that you also get to your webhost and change the database access username/password. Before your man left your company it was his/her duty to hand over these details before leaving. Protect your data. Specially if it contains personal details of your clients.

[benefitdesign]

Thanks everyone for your help. Can you please be more specific as far as where the user database is? I have searched through all of our php pages and cannot find it.

I have to add a new login by tomorrow.

HELP!

Thank you so much,
Amanda

[Josh]

Most people that use php also have a very helpful utility called phpMyAdmin installed on their server. phpMyAdmin presents the user with a visual representation of their database(s). Some web hosts have it accessible through a folder such as domain.com/phpmyadmin, while others make you connect through a port, such as domain.com:9190. If you use 1and1, they have it built into their system and you access it through the control panel.

If you cannot administer your database in this way, but you know the username and password used to access it, I can write a php script that will change the email so you can request a new password.

[benefitdesign]

I will try searching for phpMyAdmin .

The problem is I do not know the admin username or password or where to find it. Is there a place within the site that it is located? or a way to change it without knowing it?

Thank you!!!!