Managing MySQL database via Workbench

This article will show you how to manage MySQL database via Workbench. The 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.

1. Locate your target deployment

Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.

2.Get connection string information

Go to the DB & User page by clicking the "Manage" button on the Home page or the My Applications page.

Scroll down to the Connection Information section to get the connection string for your database.

3.Connect to databases using Workbench

We can download MySQL workbench tool at https://www.mysql.com/products/workbench/.

Start MySQL workbench tool and setup a new database connection as the screenshot shows.

Fill in the requested information to connect the database. Connection name – The name that will be shown in MySQL Worbench (Does not affect connection) Connection method – Select “Standard TCP/IP” Hostname – The IP address or hostname for the server Port – Port information is defined in the control panel Username – Usually root, but any account with similar privileges will work Username – Click “Store in Vault” Password – Enter your password and click “OK”.

4. Edit and manage your database

Click on the created connection to connect to your database, and now you are ready to manage your database as you like.

Copyright © 2019 Cloud Clusters Inc.Revised on 11/25/2020

results matching ""

    No results matching ""