Page 1 of 1

Best practice for database password change?

Posted: Tue May 14, 2019 1:22 pm
by hehemrin
When I change the database password (eg MySQL), Joomla must know it in the "configuration.php" file, right.
Is best practise to first change password and then manually update it in the configuration.php file? Or is there a better method?

Re: Best practice for database password change?

Posted: Tue May 14, 2019 1:44 pm
by paulala
This is a good resource:

https://www.itoctopus.com/how-to-change ... -in-joomla

Remember you don't change the password of the database, you change the password of the user with the privileges to access the database.

Re: Best practice for database password change?

Posted: Tue May 14, 2019 2:07 pm
by hehemrin
Thanks Paula!
And Yes, correct, it is the password of the connected user that actually is changed.

Re: Best practice for database password change?

Posted: Fri May 17, 2019 3:27 pm
by hehemrin
Adding info in this thread that the resource above from itoctopus does not mention the issue that configuration.php is not writable by default (at least that is the case with many hosts).

Another forum thread discuss this. My experience is that changing from 444 to 644, then upload, and change back to 444, as discussed in that thread, works. Here is the thread: viewtopic.php?t=964601

Nobody else has commented my questions - probably that means there is no fundamentally different process to do the password change than I sketched in my question which was inline with the itoctopus proposal.