MySQL - how to install on Windows Server

To install MySQL relational database management system on Windows Server, you need to buy a license and prepare the server.

Step-by-step instructions on how to install My Sql on Windows Server

Preparing the server means that you create it (if you have not done it before), specify a ready image of the operating system Windows and bind the license to the server. The result is the ability to work with Windows Server and connect to it via RDP (Remote Desktop Protocol) for remote access.

Step-by-step instructions for installing MySQL on Windows Server:

1. Download the distribution from the official MySQL database website. It is necessary to select Windows (x86, 32-bit) and MSI Installer. The developers also provide an option to download an automatic installer, but it works only if there is an Internet connection on the server (rare).
2. Start the installation by clicking on the corresponding button of the distribution. After clicking on the Install button, an information window appears to select the settings. In particular, specify the number of DBMS components: Client Only, Custom, Server Only. In this case, we specify Full - installation of all products, including MySQL Route, Workbench, Server, Shell, Connectors. If you want to select individual products, click on Custom and specify the settings.
3. Go to the tab with checking operating system requirements. Check here and click Execute. On the new page, once again check the status of the components (Ready to install) and click Execute.
4. Wait for the installation to complete. The window next to each component will show the Complete status (MySQL Route, Workbench, Server, Shell, Connectors and others).
5. Customize the configuration of the individual components. You can do this or click the exit button to use the default settings (or change them in the future). If you select configuration settings, you will see a drop-down menu with the Config Type selection. The system also asks you to set the settings: protocol type, ports, and others. Authentication method, roles and users, and many others (for each of the components) need to be set.

When the installation is completely finished, start the MySQL Server DBMS and check its performance. If everything is in order, it is necessary to perform basic configuration for further work, including with highly loaded projects.