It should work. Just be sure to make a backup first of the DB first. And before making the changes to settings.php, make sure you are logged in as user 1 and have the site in maintenance mode. Change settings.php and clear the cache tables.
Earnie
On Mon, Sep 10, 2012 at 9:30 AM, Katie Legere legerek@queensu.ca wrote:
I want to change that main connection password to our drupal database (we've had a potential security breach) without effecting the user experience in a bad way.
I know the connection is in settings.php and how to use phpMyAdmin, mysql etc.
My question is... can I just create a new user and password in phpMyAdmin for my drupal database and then flip to that in my settings.php (during a time I don't expect anyone using it) and expect that all will be well or is there a better / safer process to follow? Has anyone done this?
Katie
-- [ Drupal support list | http://lists.drupal.org/ ]