I’ve had this problem with every application I’ve deployed which uses a DO Managed MySQL database.
The error I get in the application is:
An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user ‘{{user here}}’@‘{{ IP here }}’ (using password: YES)
If I ever add a new DB user and FLUSH PRIVILEGES it breaks any applications that use the DB. I have to repeat step 3 above to get them working again.
Does anyone know what is going on? It is becoming a real problem for me.