Hello.
Changes to global privileges and passwords take effect the next time the
client connects. So, if your application doesn't reconnect you can
safely change password. Another possibility is to directly modify grant
tables, and perform FLUSH PRIVILEGES just before your application restarts.
I have three(3) instances of an application inserting data into a MYSQL (4.X)
database. I have to change the password.
I would like to know, if I can change the password of the application on the
server without disrupting existing
connections then modify the password in the startup file for the