MySQL Workbench is a convenient visual administration tool designed for database architects and developers to perform server configuration, database migrations, user administration, and other MySQL tasks through a graphic user interface (GUI).
- A Cloud Server with Windows 2016.
- MySQL installed and running.
Note: MySQL is installed and running on a standard Windows installation by default. If your server was created with a minimum installation, you will need to install and configure MySQL before you proceed.
Download the MySQL Installer
Connect to the server with Remote Desktop. Open a browser window and go to the MySQL Windows Download Page.
Click MySQL Installer.
Click to download the web-community version of the Installer.
Install MySQL Workbench
mysql-installer-web-community file, which you have downloaded. This will launch the MySQL Installer wizard.
Click Add... to add Workbench to the Install list.
Click to expand Applications > MySQL Workbench > MySQL Workbench 6.3. Select MySQL Workbench 6.3.7 - x64 and click the arrow to add it to the list of Products/Features To Be Installed.
Click Next. Then click Execute to install MySQL Workbench.
Using MySQL Workbench
See the official MySQL Workbench Manual for more in-depth information on using MySQL Workbench.
To launch MySQL Workbench, click Start > MySQL > MySQL Workbench.
Click Local instance MySQL to access your MySQL installation.
Click Server Status to view information about the MySQL installation, including features, traffic, CPU usage, and more.
Add and Manage MySQL Users
Click Users and Privileges to add and manage MySQL users.
Manage Existing MySQL Users
Click an account in the User Accounts window to view and edit details about the account.
For example, to change a MySQL user's password, select that account in User Accounts. Then enter the new password twice, and click Apply.
Add New MySQL Users
To add a new MySQL user, click Add Account.
Fill out the user details. At a minimum, you will need to fill out the Login Name and Password fields. Click Apply to create the user.
Create a Database
What many of us would call a "database," MySQL Workbench refers to as a "schema." To create a new database, click the "Create a New Schema" icon on the toolbar.
Fill out a name for the new database, then click Apply.
Click Apply to create the database.
The new database will be created.