php - What method does everyone use to change MySQL passwords in batches?

Question

MySQL password has not been changed for a long time. I changed it today and suddenly found a problem:
There are about a dozen websites on the server. Every time you change the password, you need to enter the configuration of each website program. Changing the password of each program in the file feels very troublesome and time-consuming.
I wonder how everyone solves this problem?

Answer 1

I usually bind my account to IP, so there are basically no security issues. You can also consider using it this way

Answer 2

Using the configuration center, simply write a web interface to obtain the mysql address, account, and password. When other websites start up, they can access the configuration center to obtain the configuration of the mysql connection and then connect to mysql