How to Manage Your Databases Using MySQL WorkbenchFebruary 13, 2014

 

In this KB

  • What is MySQL Workbench
  • How to connect MySQL Workbench with your Cloudways server
  • How to manage and edit your database with MySQL Workbench

 

MySQL Workbench is a unified visual tool for database management. It provides data modeling, SQL development, and comprehensive administration tools for server configuration and user administration. MySQL Workbench is available for Windows, Linux, and Mac OS.

We recommend using it instead of our Cloudways MySQL Manager for databases bigger than 200MB.

To download the MySQL Workbench tool, click here.

Step 1. Download MySQL Workbench

As shown in the image above, simply click on the Download Now button to download the MySQL Workbench.

MySQL Workbench

Step 2. Using MySQL Workbench

To start using this tool, open the tool and select the New Connection option on the screen. It will make a new connection to the database server.

MySQL Workbench

Step 3(a). Get SSH and MySQL Credentials

Before making a connection, note down your Master (or Application) and MySQL credentials. Your Master Credentials are used as SSH username and password. If you are a team member, you will use your application credentials for the same.

Master credentials

Your MySQL credentials can be retrieved from the Access Detail section under the Application Management area.

Mysql acceess

Step 3(b): Set Up a New Connection

Please follow the steps below to Setup A New Connection

1- Type the Connection Name: Mysql Connection

2- Select Standard TCP/IP over SSH — from Connection Method

3- SSH Hostname : 54.84.197.182:22

4- SSH Username: sykrrffspf

5- SSH password: Click on store in vault and enter Your_SSH_Password and click ok

6- MySQL Hostname : 127.0.0.1

7- MySQL username: sykrrffspf

8- MySQL Server Port: 3306

9- MySQL Password: Click on store in vault and enter Your_Mysql_Password

10 Click on ok

Setup A New Connection

Step 4. Now Double-Click on the Connection You have Just Created

Click on the created connection to connect to your database.

Database Connection

Step 5: Edit And Manage Your Database

That’s it! Now you are ready to manage your database as you like.

Database Management

 

Have Questions? You can start a discussion on Community Forum

Comments are closed.

Still need help? Our support team is waiting to help you. Ask them now