Re: Can I change the password of a user on the server without interupting the user's existing connections?

2006-01-23 Thread Gleb Paharenko
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.

Can I change the password of a user on the server without interupting the user's existing connections?

2006-01-20 Thread Jacob, Raymond A Jr
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