I have a MySQL database set up with Hostway, how can I connect to it?
Apply OS : Windows
Apply Navicat Product : Navicat for MySQL, Navicat Premium
Apply Navicat Version No. : All
Navicat (Windows) can successfully connect to Hostway's MySQL database by using SSH Tunnel feature. We have done testing with Hostway's hosting account. It can work successfully.
With SSH tunnel feature, Navicat can connect with most hosting companies' MySQL databases unless their servers won't support remote SSH connection. Hostway's server supports SSH connection. It's not necessary to configure MySQL privileges system. For more information on SSH tunnel feature, please refer to our user manual - Connection Settings > SSH Settings.
In Hostway's Site Control panel, after you added your MySQL database, the database host address should be similar as "mysqlxx.siteprotect.com" . For our example, it is "mysql10.siteprotect.com" which assigned by Hostway.
In the Connection Window of Navicat, fill in the followings:
Connection Name: hostway
Host name/IP address: mysql10.siteprotect.com
User name: my_database_username
Host name/IP address: www.myhostway_domain.com
User name: My_ssh_username
If you use a SSH client program to login, you can use the command mysql -h mysql10.siteprotect.com -u username -p to access your MySQL database by command line. If you use Navicat to connect, you can fill in the same information in Connection Properties Window of Navicat.