How to manage your database using MySQL Workbench

Want to find out how to manage your database using MySQL Workbench? Here’s a step-by-step guide for you.

Emmad avatar
Written by Emmad
Updated over a week ago

Table of Contents

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.

How to Manage Your Databases Using MySQL Workbench Over SSH

Step 1: Download MySQL Workbench

As shown in the image above, simply click on the Download Now button to download the 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.

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.

Classic Interface

New Interface

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

Classic Interface

New Interface

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 the 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 the store in vault and enter Your_Mysql_Password

  10. Click on ok

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

Click on the created connection to connect to your database.

Step 5: Edit And Manage Your Database

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

Important Note

Cloudways offers several options to access the MySQL database, including a web-based database manager and MySQL remote connections.

That’s it! We hope this article was helpful. If you need any help, then feel free to search your query on Cloudways Support Center or contact us via chat (Need a Hand > Send us a Message). Alternatively, you can also create a support ticket.

Did this answer your question?