To test locally, you will need to use the Local MySQL server as well. Crate a copy of the database on your local computer and set the Connection file to connect to the local MySQL server. It sounds like the remote MySQL server does not allow connections from outside sources.