Web Hosting

Please find below our list of Web Hosting guides to help with your hosting account.

How to connect to MySQL using MySQL WorkBench

This article was posted in: Web Hosting
p>This is a brief guide to connecting to MySQL using an SSH Tunnel within the MySQLWorkBench application provided by the MySQL website. This has the advantage that is is secure, and does not require us to add your IP address of the firewall to allow access.

Create a new connection within MySQLWordBench as follows

SSH Hostname : This can usually be your domain name, or your Home Server name.
SSH Username : This is your cPanel username
SSH Password : Click the Store in Keychain button and enter your cPanel password
Username : Enter the MySQL username here
Password : Click the Store in Keychain button and enter your MySQL user's password

All other settings should remains as shown in the screenshot.