Lost admin password - bitten off more than I can chew..

[Bobson]

I'm stuffed.

I'm a web designer, who takes on the odd freelance project. A friend of mine's boyfriend needs a site for his company - he gave me a loose breif, and the plan was I'd design it, and another mate would code the backend.  Due to unfortunate circumstances he's dragged his feet and has now pulled out of the coding, leaving me with 3 days to turn this site around. The reason why 3 days, is because the guy is having a meeting with a company who are to partner with him.. the origional deadline was end of the month.  Bitten off way more than I can chew here. I'm only being paid three hundred quid for this too.. but I dont want to let them all down.

The entire thing now falls on me. I've been working all through the night for the last couple of days... its now 3.05am here.. and I've been up since 5am yesterday (although that was to hit deadlines for the day job). Match sticks under my eyes. Really impressed with CMSMS.. I can just get on with it - I can style it how I want.. really is sooo easy. Love being able to drop my CSS in and style the nav as I wish. I wasted hours of my time trying to get Joomla to work... such a head ache. But anyway, I'm rambling. 5 cans of red bull already, and I vowed never to drink that stuff ever again after that time I down'd 12 cans to get a uni project finished.

I've lost the password to my cmsms admin account... I cant get in, so does that mean all my work is lost? Or am I able to look in the database for it? and if so - where do I look. I've been poking around in PHPmyAdmin to no avail.

Also - the site has to have some kinda "sign up to our newsletter" feature, as well as a calandar of upcoming events feature, to go along with a sign up and leave your details with us feature. It's for youth training stuff. Basically I've got the site styled up.. I just need to work out how to add in these extra bits. I tried installing some modules earlier - before I lost the password etc.. but they didnt all seem to work.. or maybe I did something wrong.

Any help would be really appreciated.

Thanks..

I'm gonna get a couple of hours sleep..

[Dr.CSS]

I may be able to help, give me an email...

[Nullig]

In phpMyAdmin run this query:

Code: Select all

UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1;

It will reset your admin password to "admin"

Nullig

[Bobson]

Thankyou

Right - just trying to get the other bits and bobs working. You really have saved my bacon. Thanks

[lruther1]

The quote at the bottom appears to be exactly what I need. I am taking over as admin on a site. Developer no longer with the group, don't know admin password. Do have access to control panel as editor, but no admin privileges. I am very inexperienced and don't understand where to input the query.This is what I see when I access php/MyAdmin

CMS Made Simple Admin Console - Friends of Perch Lake

Main
Home
Content
Pages
Image Manager
Global Content Blocks
Extensions
Tags
User Defined Tags
My Preferences
My Account
User Preferences
Manage Shortcuts
View Site
Logout
Users & Groups » Users


Shortcuts
1. Add Shortcut
2. Edit Page: Newsletters
3. Manage Shortcuts
Current Users
Username Active
admin True
editor True Edit
CMS Made Simple 1.3.1 "Havana"
CMS Made Simple is free software released under the General Public Licence.

Am I going to right MyAdmin page, don't see where to input the query.This is how I did access MyAdmin

Code: Select all

http://www.friendsofperchlake.com/admin/listusers.php/MyAdmin

I have ZERO programming background. Anyone able to help me?

In phpMyAdmin run this query:

Code: Select all

UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1;

It will reset your admin password to "admin"

Nullig

[chandra]

It's meant "phpmyadmin" - the area for direct database access. (NOT inside CMSMS admin area)

Don't know how it is named on your host. But there should be area for inserting the SQL command.

If you need more help send me a PM.