4571 Posts in 1384 Topics by 1376 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 3216 Views |
-
Where does MySQL store user names and passwords?
23 May 2009 at 2:42am Last edited: 23 May 2009 2:43am
I have forgotten the administrator email and password. I want to log in to MySQL and find the database table where this is stored. Can someone tell me what it's called?
Reason: During installation, I entered the admin email and password I wanted. After successful installation, I tried to log in to the CMS but got the message that the email address and password are not correct. I tried to reinstall a number of times. Same result.
SS is pointed at a MySQL server where I had already previously installed SS. My thought was, maybe the new email/password wasn't accepted and it's looking for the old ones. So, I changed the Mysite details in the _config.php files to point at another MySQL server where I definitely knew the details. And it worked. So, if I can find the database table, it should work, no?
-
Re: Where does MySQL store user names and passwords?
23 May 2009 at 3:16am
Found it!
It's the Member area. I deleted all entries in the Member ID area in MySQL and reinstalled SS, entering the email address and password for the administrator I wanted and it worked.
Guys at SS - maybe for the next version get it to overwrite the administrator entry in MySQL to the one entered at install!
-
Re: Where does MySQL store user names and passwords?
23 May 2009 at 3:00pm
You didn't have to delete all the member entries.
The easiest way is to change the admin username to an email address you have access to and then use the forgot password link to reset the password. -
Re: Where does MySQL store user names and passwords?
25 May 2009 at 9:29am
Or else add:
Security::setDefaultAdmin('admin','password');
to the _config.php file
-
Re: Where does MySQL store user names and passwords?
25 May 2009 at 9:53am
I always forget the simple solutions
| 3216 Views | ||
|
Page:
1
|
Go to Top |
