Use MySQL Workbench to Manage MySQL on Windows Server 2016

Leave your reply

Introduction

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).

Requirements

  • 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.

Install MySQL Workbench on Windows Server 2016

Click to download the web-community version of the Installer.

Install MySQL Workbench on Windows Server 2016

Install MySQL Workbench

Open the 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.

Install MySQL Workbench on Windows Server 2016

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.

Install MySQL Workbench on Windows Server 2016

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.

Install MySQL Workbench on Windows Server 2016

Click Local instance MySQL to access your MySQL installation.

Install MySQL Workbench on Windows Server 2016

Click Server Status to view information about the MySQL installation, including features, traffic, CPU usage, and more.

Install MySQL Workbench on Windows Server 2016

Add and Manage MySQL Users

Click Users and Privileges to add and manage MySQL users.

Install MySQL Workbench on Windows Server 2016

Manage Existing MySQL Users

Click an account in the User Accounts window to view and edit details about the account.

Install MySQL Workbench on Windows Server 2016

For example, to change a MySQL user's password, select that account in User Accounts. Then enter the new password twice, and click Apply.

Install MySQL Workbench on Windows Server 2016

Add New MySQL Users

To add a new MySQL user, click Add Account.

Install MySQL Workbench on Windows Server 2016

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.

Install MySQL Workbench on Windows Server 2016

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.

Install MySQL Workbench on Windows Server 2016

Fill out a name for the new database, then click Apply.

Install MySQL Workbench on Windows Server 2016

Click Apply to create the database.

Install MySQL Workbench on Windows Server 2016

The new database will be created.