MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:January 23 2006 2:40pm
Subject:Re: Can I change the password of a user on the server without interupting
the user's existing connections?
View as plain text  
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
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com
Thread
Can I change the password of a user on the server without interupting the user's existing connections?Raymond A Jr Jacob20 Jan
  • Re: Can I change the password of a user on the server without interuptingthe user's existing connections?Gleb Paharenko23 Jan