This website uses cookies

Our website, platform and/or any sub domains use cookies to understand how you use our services, and to improve both your experience and our marketing relevance.

This website uses cookies

Our website, platform and/or any sub domains use cookies to understand how you use our services, and to improve both your experience and our marketing relevance.

Introducing Cloudways Community Forum. Start Discussions and Get Instant Help From Cloudways Community. JOIN NOW

How to Manage Your Databases Using MySQL Workbench Over SSHFebruary 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

Important Note:

  • Cloudways offers several options to access MySQL database, including web-based database manager and MySQL remote connections.
Have Questions? Ask From Our Helpful Community

Comments are closed.

Do you still need help?

Our Technical Support team is always at work.