Detailed graphic description of MySql8.023 installation process (first installation)

First, download the installation package from the MySQL official website. MySQL is open source, so just download it directly.
Here are the download steps:

Then select:

For personal use, I chose this:

After downloading, unzip the downloaded installation package and put it in your favorite location, then set the environment variables:

I am a win10 system, that is, this computer-properties-advanced system settings-environment variables:
Double-click Path in System Variables, and then click New:

Just copy the path of the unzipped bin directory into it!

Then the important step is: create a new text document file in the unzipped root directory and change the suffix to .ini
As shown in the figure:

Open my.ini as a text document and write the following content

[mysqld]
basedir=F:\Environment\mysql-8.0.23-winx64
datadir=F:\Environment\mysql-8.0.23-winx64\data\
port=3306

As administrator again! !
As administrator again! ! !
As administrator again! ! ! !
Open CMD

Change the path to the bin directory under mysql:
Input Statement

mysql -install

After the prompt is successful, enter the data file to initialize

mysql --initialize-insecure --user=mysql

After success, the data folder will appear in the mysql root directory. It should not exist originally!

Bypass password authentication:

mysqld --console --skip-grant-tables --shared-memory

Then open another cmd window with administrator privileges.

Switch to the mysql bin directory and start mysql.

net start mysql

Then use the command to enter the management interface

mysql -u root -p

After entering, use the following command to modify the root password. Please note! Mysql8.0 password modification is different from the previous one!

ALTER user 'root'@'localhost' IDENTIFIED BY 'new password';

After that, refresh it and restart it to use normally:

flush privileges;

The commands used in the above steps should be the following:

mysql -install //Install mysql
mysql --initialize-insecure --user=mysql //Initialize the data file net start mysql //Start the MySQL service mysql -u root -p //Use no password to change the root password ALTER user 'root'@'localhost' IDENTIFIED BY 'new password'; //Change the root password, Mysql8.0 mode flush privileges; //Refresh the database exit //Exit the MySQL management interface net stop mysql //Shut down the MySQL service

Note: For versions prior to 8.0, how to change the password if you forget it

Find the bin directory: mysqld --skip-grant-tables
Open a cmd window again and find the bin directory: mysql will enter the login state
5.7.22 Modify password statement: update user set authentication_string=password('123456') where user='root' and host='localhost';
5.6. Change password statement: update user set password=password('123456') where user='root' and host='localhost'; (I have not tried it, but it is written like this on the Internet)

This is the end of this article about the detailed graphic description of the MySql8.023 installation process (first installation). For more information about the MySql8.023 installation process, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!