Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Where does MySQL store user names and passwords?


Go to End


5 Posts   6297 Views

Avatar
Nuttydo

Community Member, 16 Posts

23 May 2009 at 2:42am

Edited: 23/05/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?

Avatar
Nuttydo

Community Member, 16 Posts

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!

Avatar
rbquirke

Community Member, 70 Posts

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.

Avatar
Howard

Community Member, 215 Posts

25 May 2009 at 9:29am

Or else add:

Security::setDefaultAdmin('admin','password');

to the _config.php file :)

Avatar
rbquirke

Community Member, 70 Posts

25 May 2009 at 9:53am

I always forget the simple solutions :)