I'm having problems with connecting to a remote database

Question

Hi,I'm trying to set up a remote connection to a MySQL database. The remote/testing server is all set up ok, but when I come to add a mySQL connection it connects to the site then throws back a "HTTP Error Code 403 Forbidden". My hosting is set up to accept remote connections as long as username/password are correct (which they are!).There's possibly a problem with the port which should be 3306, but I can't find anywhere to check/change this? Is this what I should be looking for or do I need to try another way of connecting?

Ben M · Answer

My hosting is set up to accept remote connections as long as username/password are correct (which they are!).

First off that is a very risky setup. I'm surprised your host would allow it. The server should only allow connections from specific addresses.

There's possibly a problem with the port which should be 3306, but I can't find anywhere to check/change this? Is this what I should be looking for or do I need to try another way of connecting?

When you enter in the database information, you would need to use the hostname:port if you are using a non-standard port for your SQL server. DW doesn't explicitly state this but that's the way it's done. Typically though you really should not work on remote data while working on a local site because any mistakes are made, there is no undo button. It's recommended that you download a copy of the database for use on your testing server and then connect to the testing server.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.