I am trying to access mysql.mydomain database from microsoft excel but I keep getting errors like error 40: cannot connect. A much similar error 26. Or latest, error 18: internal connection fatal error.
Has anyone on dreamhost attempted connecting their sql database to excel or could do so? It may be a simple manner of putting right settings in. I do not even know how to test if my remote access is working properly. Any info or links to guides are welcome other than dreamhost’s guide to third party database connection that i’ve read.
PS: I had already allowed remote access to my public IP in the database user setting. Even tried wildcard %.%.%.%