Step3: Install and Build MySQL

Last updated: 2020-04-25 12:11:03

    Overview

    This article describes how to install MySQL 8.0 on a CVM instance with Windows Server 2012 R2 Datacenter Edition 64bit.
    SQL Server is perhaps the most popular database software on Windows. However, it is commercial and requires you to obtain your own license. As an alternative, you can purchase CDB instances for Tencent Cloud SQLServer database.

    Procedure

    Downloading MySQL

    1. Log in to your CVM instance.
    2. Open a browser window and go to the official MySQL site to download the MySQL installation file.

    Installing MySQL

    1. Launch the MySQL installer by double-clicking the installation file. The Choose a Setup Type window appears. Select Developer Default and click Next, as shown in the following figure:
    2. In the Check Requirements window that appears, click Execute and resolve unmet requirements as shown in the figure below:
    3. Click Next.
    4. In the Installation window, click Execute to install the required packages, as shown in the figure below:
    5. Click Next when the package installation finishes to open the Product Configuration window.

    Configuring MySQL

    Configuring MySQL service

    1. In the Product Configuration window, click Next to open the High Availability window.
    2. Select Standalone MySQL Server / Classic MySQL Replication and click Next, as shown in the following figure:
    3. In the Type and Networking window, keep the default configuration. Click Next, as shown in the following figure:
      • TCP/IP network is enabled by default.
      • Port 3306 is used by default.
    4. In the Authentication Method window, keep the default configuration. Click Next, as shown in the following figure:
    5. Set a root password and click Next as shown in the following figure:
    6. In the Windows Service window, keep the default configuration and click Next, as shown in the following figure:
    7. In the Apply Configuration window, click Execute.
    8. Click Finish to complete MySQL configuration.

    Configuring MySQL Router

    1. In the Product Configuration window, click Next.
    2. In the MySQL Router Configuration window, keep the default configuration and click Finish, as shown in the following figure:

    Configuring MySQL samples

    1. In the Product Configuration window, click Next.
    2. In the Connect to Server window, input the root password. Click Check, as shown in the following figure:
    3. After the password is successfully authenticated, click Next, as shown in the following figure:
    4. In the Apply Configuration window, click Execute.
    5. Click Finish to complete the MySQL sample configuration.
    6. In the Product Configuration window, click Next.
    7. In the Installation Complete window, select the MySQL environment component you want to start and click Finish, as shown in the following figure:
      • If MySQL Workbench starts, MySQL is successfully installed, as shown in the following figure:
      • If MySQL Shell starts, MySQL is successfully installed, as shown in the following figure:

    Adding Security Group Rules

    Add an inbound rule to allow traffic on port 3306 to the security group that is bound to the CVM instance on which MySQL is installed.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help