MySQL Workbench

From Hostek.com Wiki
Jump to: navigation, search


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.

Windows

  1. Login to your control panel
  2. Under Databases, Click on MySQL.
    Mysqlicon.png
  3. You can find the host next to the database name.
    Mysqlscreen.png

Linux

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.

  1. Login to your cPanel
  2. Under Databases go to Remote MySQL.
    x3 Theme Paper Lantern Theme
  3. 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.
    x3 Theme Paper Lantern Theme

Configuring MySQL Workbench

  1. Open MySQL Workbench on your local machine
  2. Click on the (+) icon
    Mysqlworkbench.png
  3. Fill in the connection details and you can optionally store your password in the vault.
    Mysqlworkbenchlogin.png

How to use MySQL Workbench to backup your MySQL database

Mysqlworkbenchexportmenu.png Mysqlworkbenchdataexport.png

  1. Click on Server in the menu and then click on Data Export
  2. 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)
  3. Press the 'Start Export' button


How to use MySQL Workbench to Restore your MySQL database

Mysqlworkbenchimportmenu.png Mysqlworkbenchdataimport.png

  1. Click on Server in the menu and then click on Data Import
  2. 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.
  3. Press the 'Start Import' button