How to handle db password change in a live service
Suppose I have a REST application running on a remote server which connects to a mysql database. Now let's say the password of the db has to be changed. What are the right methods and practices that has to be followed to avoid failure of requests.
One solution is to create a new user with same level of permissions as old and deploy. Once we ensure all the instances are connecting with the same username, we can delete the old username/password combo.