How to Install MySQL Server on Windows 10 13
0

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.

Starting the MySQL installer

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.

Choosing a MySQL Installation Type

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

MySQL installation

Then click Next .

MySQL installation

Go to the setup phase – click Next .

MySQL server setup

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

Choosing the type of MySQL server installation

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

Setting network parameters for MySQL server

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

Configure authentication settings for MySQL server

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 .

Setting a password for root and creating users

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.

Setting up the MySQL service on Windows

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

Setting up plugins and extensions for MySQL

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

Applying Settings for MySQL


COMPLETION OF THE INSTALLATION AND HEALTH CHECK

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

Finishing MySQL Server Installation

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.

MySQL Server Health Check

What is Sed Linux Command and How to Use it?

Previous article

Top 25 Best Productivity and Time Tracking Apps

Next article

You may also like

Comments

Leave a Reply