php - 大家都使用什么办法来批量修改MySQL的密码？

Question

MySQL的密码很久没有修改了，今天就修改了一下，忽然发现一个问题：
就是服务器上有大概十几个网站，每次修改完密码之后都需要进每个网站程序的配置文件里面修改每个程序的密码，感觉很是麻烦，而且也很费时间。
不知道大家是如何解决这个问题的呢？

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