We are trying to deploy a Drupal application on our production server.
We see this strange error
Lost connection to MySQL server at ''Access denied root@ipaddres password(yes) after deploying.
We made all necessary corrections in
settings.php and also give
GRANTs to the webserver to access the database. The webserver and the database server are physically two different machines.
We are able to connect to the database server from our web server through the command line.
There is no firewall enabled on either server.
Any update we make to the database means the site goes down and displays an
ACCESS DENIED error.
Can any one guide me to resolve this issue?