Tim_H
#1
In PRODUCTION I can connect to 2 different mysql databases on the same server.
When I set both of those into STAGING (using the same settings) I get this error:
( Why does it say Password NO ? )
My IT Admin says that server is not blocking by IP addresses.. but it seems like that would be a likely cause? What else could it be?
Hey @Tim_H! This error looks like it may be coming from your database side, actually.
After a bit of Googling, it seems like there are a few things we can look into:
https://community.rstudio.com/t/failed-to-connect-to-database-error-access-denied-for-user-error-when-trying-to-connect-to-aws-database/145021
Copied from a comment on that forum:
1-
username="root"
password= "YOUR_PASSWPRD"
As in no need to put the actual password, only copy "YOUR_PASSWORD"
2-If still doen´t work remove database
3-Check that your IP address is added to the server permissions/security
4-Check that the DB is available and public connection is allowed