Connecting to MySQL Remotely Using Navicat
 | Please note that the following instructions are for advanced users only. Jumpline.com does not provide any support on using or installing applications downloaded from a third party, and provides this documentation for reference only. Please do not contact the Jumpline.com support department with questions regarding these instructions; refer to the documentation provided by the software developers. |
Navicat is a popular MySQL client program, provided by PremiumSoft at http://www.navicat.com/, which works with the Jumpline.com VDS Web Hosting copy of MySQL. Using Navicat, you can view and edit the contents of your database using a familiar spreadsheet style view. Support for Navicat is provided by PremiumSoft, but the following settings can be used to connect to your database using Navicat:
Inside of the Navicat connection wizard, under the General tab, enter the following information:- Connection Name - Enter the name that you wish to appear inside of Navicat for this saved connection
- Host name/IP address - Enter the domain of your account hosted with Jumpline.com
- Port - Enter 3306
- User name - Enter "root"
- Password - Enter the MySQL password for your hosting account that was selected when MySQL was installed
Under the SSH tab in the connection wizard, enter the following:- Use SSH Tunnel - Be sure that this option is selected
- Host name/IP address - Enter the domain of your account hosted with Jumpline.com
- Port - Enter 22
- Username - Enter the main username for your hosting account
- Authentication method - Select "Password"
- Password - Enter the main password for your hosting account (this is the same as is used for SSH or FTP connections)
You should now be able to open a connection to MySQL on your VDS using the saved connection in Navicat and browse the contents of your databases.
|
