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.
Jacob, Raymond A Jr wrote: > 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 > application. So that when the application > is restarted automatically at night, the application will login to the > database with the new password with > a minimal disruption of service. > > Thank you, > Raymond > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
