Step3: Install and Build MySQL

Recent Pages

Step3: Install and Build MySQL

Last updated: 2024-01-06 17:43:10

Overview
This document describes how to install MySQL 8.0.19 on a CVM instance with the Windows Server 2012 R2 DataCenter 64-bit English installed.
SQL Server is more popular on Windows. However, it is commercial and requires you to obtain your own license. As an alternative, you can purchase a TencentDB for SQL Server instance.
Directions
Downloading MySQL
1. Log in to your CVM.
2. Open a browser and go to the MySQL official website to download the MySQL installation file.
Installing MySQL
1. Double-click the MySQL installation file. The Choosing a Setup Type window appears. Select Developer Default and click Next, as shown below:
﻿
﻿
2. In the Check Requirements window that appears, click Execute and resolve unmet requirements.
3. Click Next.
4. In the Installation window, click Execute to install the required packages.
5. Click Next when the package installation completes to open the Product Configuration window.
Configuring MySQL
Configuring MySQL service
1. In the Product Configuration window, click Next.
2. In the High Availability window, select Standalone MySQL Server / Classic MySQL Replication and click Next, as shown below.
﻿
﻿
3. In the Type and Networking window, keep the default configuration, and click Next.
Note: 
TCP/IP network is enabled by default.
Port 3306 is used by default.
4. In the Authentication Method window, select Use Legacy Authentication Method(Retain MySQL 5.x Compatibility) and click Next.
In this document, this option is set to set up a WordPress website as an example. You can set it as needed.
﻿
﻿
5. Set the password for the root user and click Next.
﻿
﻿
6. In the Windows Service window, keep the default configuration, and click Next.
7. In the Apply Configuration window, click Execute.
8. Click Finish.
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.
﻿
﻿
Configuring MySQL samples
1. In the Product Configuration window, click Next.
2. In the Connect To Server window, input the root password, and click Check.
3. After the password is successfully authenticated, click Next.
﻿
﻿
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.
If MySQL Workbench as shown below starts, MySQL has been successfully installed.
﻿
﻿
If MySQL Shell as shown below starts, MySQL has been successfully installed.
﻿
﻿
Adding security group rules
Add an inbound rule to open the port 3306 to the security group that is bound to the CVM instance on which MySQL is installed.
For more information, see Adding Security Group Rules.