Jump to:

23453 Posts in 18902 Topics by 2877 members

General Questions

SilverStripe Forums » General Questions » Change Mysql user password and database

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

Page: 1
Go to End
Author Topic: 2608 Views
  • shotaway
    Avatar
    Community Member
    2 Posts

    Change Mysql user password and database Link to this post

    Hi ya Ive been try to change my mysql user and password. I have set a new user up fine but when i change the _config.php to the new credentials I get a error..

    First off I copy'd the database to a new name and created a new user with full priv's to access this new database..
    changing the _config.php file and hitting db/build?flush=1 cause 20 odd tables to be created, and loosing all mycontent. the db is a exact cp. untill SS updates the tables and makes some more blank tables and not using the original ones. the making of the new 20 odd table could be a red herring as it blog tables mainly that are created..

    Ive also tried to change just the user and pass to the old DB I get a SS error page and are unable to access the site..

    if anyone knows the correct procedure for this please shed some light on it..

    thanks

    Shotaway

  • shotaway
    Avatar
    Community Member
    2 Posts

    Re: Change Mysql user password and database Link to this post

    Yes _config.php is the only place for the mysql credentials.
    I was getting my databases in a muddle..
    All working fiine now.

    shotaway

  • Nachos
    Avatar
    Community Member
    18 Posts

    Re: Change Mysql user password and database Link to this post

    Just in order to help people having the same problem as me - in silverstripe 3.0 the database user and password is in the file _ss_environment.php, the database in mysite/_config.php.
    Have fun!

    2608 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.