The topic of this article is not supported by our customer support department, however for your convenience we have provided third party material to assist you in troubleshooting potential issues related to this topic.

Important Note: Please note that the following instructions are for advanced users only. OpenSourceHost 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 OpenSourceHost 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 (available at http://www.navicat.com/), which works with the OpenSourceHost 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 OpenSourceHost
• 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 OpenSourceHost
• 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.