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.
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-18.104.22.168.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 command
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