Connecting to MySQL via MySQL Workbench
From OCS Support Wiki
Contents |
Introduction
This guide will show you how to connect to your database remotely via MySQL Workbench.
Installing MySQL Workbench
Before you begin, you'll need to download and install MySQL Workbench on your computer. You can find the download on the MySQL Workbench download page (be sure and download version 5.2 or higher). Choose the appropriate package for your computer. MySQL Workbench currently runs on Windows, Linux, and MacOS.
Adding a Connection
To work with your MySQL database in MySQL Workbench, you'll need to add a connection so that the program knows how to connect to your database on our servers. To do this, start the program and click the New Connection button under the SQL Development section on the left hand side of the screen.
Once you've done this, you'll see a dialog asking for connection parameters. In the pick down box at the top titled Connection Method, choose "Standard TCP/IP over SSH" and you'll see a dialog similar to below. Fill in the values as given below, entering your password when necessary.
Replace www.yoursite.com with your domain name, and cpuser with your cPanel/Webmin username. When asked for a password, enter the same password you use to login to cPanel or Webmin.
Once you're done click Test Connection. If you encounter an error during the test please check your username and password. Otherwise, click OK to save your settings.
Connecting To Your Database
Once you have the connection entered, double click on it in the list of connections on the main page of MySQL Workbench. You are now ready to start working with the data in your database!
