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.