changing Database user

[leecolvin]

All

can someone please advise how you change the user that is used to connect to Mysql and also the rights the user requires on the said database

thanks
Lee

[Andreas]

The rights you have on your DB are set by your hoster.

Values to connect to your DB are stored in system/config/localconfig.php

You can change values directly in this file or open the install tool contao/install.php and set your DB data there.

[leecolvin]

Hi Andreas

thank you for you reply, to confirm if I set up the user in mysql and change the details in system/config/localconfig.php
with this take effect imediatley or will I need to restart the web server (apache) for it to read the localconfig.php file?

thanks

[Andreas]

No apache restart needed. On every contao call from BE or FE contao is conversing with the DB and first think contao does is reading your localconfig.php. If contao can not connect to your DB you will get errors.