Learning projects need to use mysql, So today I want to sum up mysql Installation and use process of .

One 、 download MySQL

Mysql Official website download address

1、 Find the official website link : link https://www.mysql.com/
Click on MySQL Community Server（ Community Edition ）;

I chose 8.0.29 Version of

Choose to download a smaller compressed package

  After downloading, unzip it to the specified path .

Two 、 install MySQL

1、 establish MySQL Configuration file for , stay mysql Create a new folder my.txt file , Change the suffix to ini

  3、 ... and 、 Configuration environment

stay “ This computer ” find “ attribute ”, And find “ Advanced system setup ”.

And then find “ environment variable ”, stay “ User variables ” Find “path”, And then mysql Of bin Edit the directory into it

Enter as administrator cmd, Enter the installed mysql Of bin Catalog , Initialize database

mysqld --initialize --console

  install mysql service , The order is as follows ：

 mysqld install

start-up mysql service , The order is as follows ：

 net start mysql

initialization data Catalog , The order is as follows ：

 mysqld --initialize-insecure

Change Password

stop it mysql service

 net stop mysql

1. Skip the permission table and start the service ( In this way, there is no need to modify my.ini)

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

2. Enter the installed mysql Of bin Log in to the directory

D:\mysql\bin>mysql -u root -p

3. Leave password blank

mysql> UPDATE mysql.user SET authentication_string='' WHERE user='root' and host='localhost';  
// empty , Two single quotes , No space between , It looks like a double quotation mark .

4. Refresh

mysql> flush privileges;

5. Change Password

ALTER user 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'admin';
// In this space-time password state , Change password available alter Change Password 

After successfully changing the password, you can use the modified password to log in mysql 了 .

reference ：

MySQL Database installation and configuration nanny level tutorial （ With 8.0.29 For example ） If you have a hand _ Zeze lukewarm blog -CSDN Blog

newest mysql8.0.22 Forget the password solution _rust&python The blog of -CSDN Blog _mysql8.0 Check the password