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.
Your MySQL credentials can be retrieved from the Access Detail section under the Application Management area.
Step 3(b): Set Up a New Connection
Please follow the steps below to Setup A New Connection
Type the Connection Name: Mysql Connection
Select Standard TCP/IP over SSH — from Connection Method
SSH Hostname : 220.127.116.11:22
SSH Username: sykrrffspf
SSH password: Click on the store in vault and enter Your_SSH_Password and click ok
MySQL Hostname : 127.0.0.1
MySQL username: sykrrffspf
MySQL Server Port: 3306
MySQL Password: Click on the store in vault and enter Your_Mysql_Password
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.
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.