Jump to:

4938 Posts in 16588 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Where does MySQL store user names and passwords?

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

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

Page: 1
Go to End
Author Topic: 4266 Views
  • Nuttydo
    Avatar
    Community Member
    16 Posts

    Where does MySQL store user names and passwords? Link to this post

    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?

  • Nuttydo
    Avatar
    Community Member
    16 Posts

    Re: Where does MySQL store user names and passwords? Link to this post

    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!

  • rbquirke
    Avatar
    Community Member
    70 Posts

    Re: Where does MySQL store user names and passwords? Link to this post

    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.

  • Howard
    Avatar
    Community Member
    215 Posts

    Re: Where does MySQL store user names and passwords? Link to this post

    Or else add:

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

    to the _config.php file

  • rbquirke
    Avatar
    Community Member
    70 Posts

    Re: Where does MySQL store user names and passwords? Link to this post

    I always forget the simple solutions

    4266 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.