What is MySQL Workbench?
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.
Where can I get MySQL Workbench?
You can obtain a copy of MySQL Workbench here: MySQL Workbench Download
How do I connect to my database using MySQL Workbench?
Before connecting connecting to your database using MySQL Workbench, you'll have to first get the host name or the IP address of the Hostek MySQL server your database is on.
- Login to your control panel
- Under Databases, Click on MySQL.
- You can find the host next to the database name.
You should be able to use your domain name as the host. However in order to connect externally to your database with programs such as MySQL workbench you'll need to enable remote MySQL access to your database.
Depending on your cPanel theme, the location and text may be different. The screenshots below are from the themes x3 and paper lantern.
- Login to your cPanel
- Under Databases go to Remote MySQL.
- If you have a specific static IP you want to grant remote access to, you can enter it here and click on "Add Host". Otherwise you can grant remote access from any IP by entering % as the host and click on Add Host.
Configuring MySQL Workbench
- Open MySQL Workbench on your local machine
- Click on the (+) icon
- Fill in the connection details and you can optionally store your password in the vault.
How to use MySQL Workbench to backup your MySQL database
- Click on Server in the menu and then click on Data Export
- Click the box next to the Schema (also known as a database) that you are wanting to export. (Optionally, you can change the location where the file is going to be dumped)
- Press the 'Start Export' button
How to use MySQL Workbench to Restore your MySQL database
- Click on Server in the menu and then click on Data Import
- Click on the button next to the "Import From Self-Contained File" textbox and select the MySQL dump file you want to import and select the target schema (also known as a database) or alternatively you can create a new schema.
- Press the 'Start Import' button