Forums

Trouble connecting to MySQL remotely through VBA

strConn = "Driver={MySQL ODBC 5.3 ANSI Driver};Server=mitchprice.mysql.pythonanywhere-services.com;Database=mitchprice$forex;UID=mitchprice;PWD=MYPASSWORDHERE;"

Gives me a "can't connect to server" error.

This code will work though different web host. Any thoughts please? Thanks!

Couple of issues - suggest you search this forum for something like 'mysql remote'.

We don't expose user databases to the internet. You can use an ssh tunnel to connect securely from outside if you have a paid account.