MySQL installation and configuration - detailed tutorial

I use it 8.0.17 edition , Enter first mysql In the official website （Mysql Its official website -->https://www.mysql.com/）, Here are the detailed steps ：

After downloading, put the installation package into a folder and unzip

Open the command line as Administrator (cmd), Must be an administrator , Otherwise, the following commands require permission , There is an error ！

　1, Go down to mysql Of bin Under the table of contents ：cd /d D:\mysql\mysql-8.0.17-winx64\bin

　2, install mysql Service for ：mysqld --install

　3, initialization mysql,mysqld --initialize --console    ad locum , Initialization produces a random password , As shown in the picture box below , Remember this password , We'll use that later

4, Turn on mysql Service for net start mysql

5, validate logon ,mysql Is the installation successful ,   mysql -u root -p    Pay attention to the random password generated above , Excluding spaces before symbols , Otherwise, it will fail to log in ), If it's the same as the figure below , It means your mysql Installed successfully ！

6, Change Password     alter user 'root'@'localhost' identified with mysql_native_password by '123456';

7, Verify that the password was modified successfully exit

If you are entering the installation command mysqld install
Problems arise The service already exists
This is because it has been installed before mysql Clean and not deleted . Run as administrator again , Input    sc query mysql    Take a look at the name mysql Service for , It is found that the command has been installed before     sc delete mysql    Delete the mysql