Hello! Today we show the installation process of MySQL server version 8.0 on Windows 10 using the automatic installer. Before that, we already talked about how to install a MySQL server on CentOS 7 , now we decided to touch on a slightly more well-known platform.

INSTALLATION

So, let’s begin. As I mentioned earlier, we will use the automatic installer, which must be downloaded at the following link: https://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-8.0.11.0.msi

The file “weighs” about 200 MB, and it already has everything you need for installation. Double-click on the executable file, accept the terms of the license agreement (checkmark) and click Next.

Next, select the type of installation, of which there are several – installation of a ready-made “developer kit”, installation of only the server, only the client, full installation (first option + additional tools) and custom. In our case, we choose the server installation.

Next, click Execute and wait for the installation to complete.

Then click Next .

Go to the setup phase – click Next .

Since we show the simplest installation, we select the first option, just as in the screenshot – a separate MySQL server and click Next .

We configure network parameters – for demonstration purposes we left everything by default.

Then we configure authentication parameters – select the first option and click Next .

Set the root password for the server – the harder the better. We recommend using at least a 12- character password containing letters, numbers, and special characters. Also at this stage, you can add users – for example, we added the user asterisk .

Next, configure the properties of the MySQL service – specify the name of the service, startup options, and from which account you need to run this service.

Next, configure the plugins and extensions – at this stage we left everything by default, because we demonstrate the basic installation of the server.

Next, you need to apply the settings – click Execute and wait.

COMPLETION OF THE INSTALLATION AND HEALTH CHECK

Done! Now it remains to click Finish two times – congratulations! You have installed a MySQL server.

Now let’s check its performance. To do this, open the application that was installed with the server – MySQL 8.0 Command Line Client . You will need to enter the root password that you specified during installation and then run the commandshow databases;

It is very important not to forget the semicolon in the commands, as in the example above.

As a result, you should see several default databases created – mysql , performance_schema , information_schema and sys . To exit, enter the command exit.