Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: zapiy on March 11, 2008, 01:44:36 PM

Title: Admin forgotten Password
Post by: zapiy on March 11, 2008, 01:44:36 PM
I have made a mistake as rushed an install and for got to jot down the password that was created for the admin user. How can i correct this?
Title: Re: Admin forgotten Password
Post by: greyknight17 on March 11, 2008, 03:12:35 PM
Click on the forgot password link and check your email. If you have another admin, you can ask them to reset the password for you.
Title: Re: Admin forgotten Password
Post by: zapiy on March 11, 2008, 04:44:50 PM
I rushed the install and did not input an email.

My host has an autoinstall system hence my prob
Title: Re: Admin forgotten Password
Post by: greyknight17 on March 11, 2008, 05:15:11 PM
Surprised it didn't require the email regardless.....

OK. Just register a new name for now. We will make this new account the administrator account so you can get in and reset the password for the other account.

Go into phpMyAdmin (http://www.simplemachines.org/community/index.php?topic=21919.0) and click on your database. Then click on the SQL tab and copy paste the following code and run it:

UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'yourusername';

Replace yourusername with the new account name you just created. That will make it one of the administrators now. You can go into the default administrator's profile and reset the password from there.
Title: Re: Admin forgotten Password
Post by: zapiy on March 11, 2008, 06:00:03 PM
I dont have phpmyadmin installed. I looked at installing it but it looks a little difficult.
Title: Re: Admin forgotten Password
Post by: greyknight17 on March 11, 2008, 07:05:35 PM
What does your host provide you with in terms of browsing the database tables? There should be a SQL section for you to run queries like the one I gave you above.

If this is just a new install, you can just delete it and create a new one if it makes it easier on your end.

The manual install it not very difficult. The hardest part for most users is probably the database. You just have to know a little on how to create a new database and assign a user to it.

If you are interested, here is a brief breakdown on the installation steps:

1. Download the Full Installer Package (http://www.simplemachines.org/download/) and save it to your computer.

2a. You can either extract the files to your computer now and upload them to your webhost or....

2b. Upload that full install zip file to your webhost and then in their control panel choose to extract the file contents.

3. Once that's done, you need to go into your database section and create a new database for the forum. Then create a new username and password in the database. Assign this new username to the database and give it full privileges. Make sure you remember the information entered here.

4. Go to your browser and now point it to http://www.yoursite.com/install.php (replace yoursite.com with your actual site and correct the path to the install.php if that's not where you installed it). Enter your forum and database information (you just did this earlier) and you should be on your way to using SMF shortly.
Title: Re: Admin forgotten Password
Post by: zapiy on March 11, 2008, 10:07:18 PM
I have installed the phpmyadmin files but i am struggling with the config setup...
Title: Re: Admin forgotten Password
Post by: greyknight17 on March 11, 2008, 10:21:15 PM
What part are you having problems with? Did you create the database already and assign a user to it with full privileges?
Title: Re: Admin forgotten Password
Post by: zapiy on March 11, 2008, 10:23:21 PM
When i run the setup script i get an error concerning the config file...
Title: Re: Admin forgotten Password
Post by: zapiy on March 11, 2008, 10:31:11 PM
Error
MySQL said: 

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Title: Re: Admin forgotten Password
Post by: sherpa サイバー侍 on March 11, 2008, 11:43:52 PM
Is this your own self builded server or you are hosting your site with some hosting company?
Title: Re: Admin forgotten Password
Post by: zapiy on March 12, 2008, 01:12:54 AM
Just sorted it.

Just reinstalled everything. did not wont to but it had to be done.

cheers for your advice...