Detailed tutorial on installing MYSQL under WINDOWS

1. Download the installation package

-Choose the appropriate version according to your computer system: https://dev.mysql.com/downloads/mysql/

2. Configure environment variables

2.1 Unzip the downloaded compressed package

2.2 Environment variables

How to enter Win 10 computer

3. Generate data file

In the directory where you unzipped the files, eg: F:\Program Files\mysql-8.0.17-winx64\bin, run cmd as an administrator

Execute mysqld --initialize-insecure --user=mysql to generate the data directory under the eg directory

4. Install MySQL

Execute the command: mysqld -install

5. Start the mysql service

net start mysql

6. Log in and change password

When you log in for the first time, there is no password, just enter, mysql -u root -p

View user command: select user,authentication_stringfrom mysql.user;

Because the encryption rule in versions before MySQL 8 is mysql_native_password, and after MySQL 8, the encryption rule is caching_sha2_password,

So if you want Navicat to connect to MySQL, you must modify the MySQL user login password encryption rule to restore it to mysql_native_password.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #Modify encryption rules ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #Update the user's password FLUSH PRIVILEGES; #Refresh permissions ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password'; Modify the password in this way

7. Use navicat to connect to mysql

Summarize

The above is a detailed tutorial on how to install MYSQL under WINDOWS. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!