Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Each time I change the MySQL db password, and update the dbconfig file, the website is down.

I also flush privileges

Any idea why?

share|improve this question
2  
How do you change the password? Which command, or GUI? What do you mean by 'down'? Exactly which error are you getting? –  Martijn Heemels Oct 17 '10 at 7:45

2 Answers 2

Given the sparsity of information provided, I'm guessing between changing the password in the database server and the config on the file system, the web server application is being hit by clients and for that period, the password being incorrect, the application cannot render the content without a database connection.

I'd recommend first changing the db password via your tool of choice, then update the file and flush the db privileges as close to simultaneously as possible.

Of course, this begs the question why you are changing the password so frequently that it is an issue, but I'll leave that to others to find out why. :)

share|improve this answer

What type of web application framework are you currently using? Depending on the framework, you may need to restart your web server to bring in the new changes to your database configuration within your application. You may want to try this procedure:

  • Change the password for your MySQL user
  • Run FLUSH PRIVILEGES; in MySQL
  • Restart your web application
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.