To connect to your MySQL database remotely, enable remote access by following these steps:
I. Enable Remote MySQL Access from the Netfirms Control Panel
- Login to the Netfirms Control Panel at https://controlpanel.netfirms.com
- Click Hosting
- Choose Databases
- Click MySQL
- For the database you wish to connect to, click the corresponding plus sign located to the left of the Database Name
- From the Connection tab, refer to the Remote Connection section to select Allow from the Remote Access pull-down menu
- Click Update
II. Configure MySQL Connection Settings
You may use a MySQL client (ie. MySQL Front, HeidiSQL) or a Perl/PHP script or command line (% mysql -hmysql.netfirms.com -P3306 -pPassword -uUsername) to connect to your database remotely. Enter the following settings:
Database ID (as indicated in your Control Panel)
Username (as indicated in your Control Panel)
Password (as set by you in your Control Panel)
Host: mysql.netfirms.com
Port: 3306