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.

Installing SilverStripe

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

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

Where does MySQL store user names and passwords?


5 Posts   4322 Views


23 May 2009 at 2:42am (Last edited: 23 May 2009 2:43am), Community Member, 16 Posts

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?


23 May 2009 at 3:16am Community Member, 16 Posts

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!


23 May 2009 at 3:00pm Community Member, 70 Posts

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.


25 May 2009 at 9:29am Community Member, 215 Posts

Or else add:


to the _config.php file :)


25 May 2009 at 9:53am Community Member, 70 Posts

I always forget the simple solutions :)