Tips for changing password on a production mySQL server

I’ve been wanting to change my password on my production server, but have hesitated because I’m not sure if I would run into any snags. Other than doing the change late at night, when few people are on my website, are there any other things that I should be considering?

Thanks!

I’m not sure what the done thing is, but one possible solution is to have multiple login information in your application, and have the application try them in turn until it is successful. So that if one log in fails (the old password), it’ll then try the new password. This would appear pretty seamless to the website user.

Once you’ve made the change, you can remove the old credentials from your application and it’ll just use the new one.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.