Is remote MySQL access supported?
Yes, remote MySQL access is supported for the purposes of assisting in development from your local PC using a database manager such as Navicat or Dreamweaver. To enable Remote MySQL access please follow these steps:
- Login to your Synergy Wholesale System account.
- Using the menu select Hosting and click Manage.
- Select the applicable hosting service and in the drop down options click “External MySQL Access”.
- This page will confirm all of your MySQL connection information you should note down.
- Under “IP Addresses Allowed” you will find an option to Add a New IP Address, please complete this with the correct IP to provide access through our firewall.
- Once you have allowed your IP Address access through your Synergy Wholesale System account please login to your cPanel.
- Click the Remote MySQL” icon.
- Add your IP Address to this page as well to facilitate access on the database side.
Once you have completed those steps, you will be able to access MySQL remotely from the IP Address you designated. You will be required to authenticate with the database username and password. Please be aware if using a dynamic IP Address on your internet connection, access will cease upon an IP change and the steps will need to be re-completed.