MySQL latest version 8.0.21 installation and configuration tutorial~

Catalog

• • 1、 Download it zip Compressed package
  • 2、 Unzip to the directory you want to install
  • 3、 Add environment variables
  • 4、 newly build mysql The configuration file
  • 5、 install mysql service
  • 6、 Initialization data file
  • 7、 start-up mysql
  • 8、 Get into mysql Modify password in management interface （ Enter the password for the first time and press enter ）
  • 9、 restart mysql It can be used normally

RDBMS（Relational Database Management System）： Relational database management system

Official website ：https://www.mysql.com/

[ Failed to transfer the external chain picture , The origin station may have anti-theft chain mechanism , It is suggested to save the pictures and upload them directly (img-sg5R4pUt-1650586218955)(https://gitee.com/zhong_siru/images/raw/master/img/20200718152236.png)]

---

Installation recommendations ： Try not to use .exe Installation , Install with compressed package , It is more convenient for unloading in the future

Download address ：https://dev.mysql.com/downloads/mysql/

1、 Download it zip Compressed package

Then start downloading , Download complete , Got the compressed package

2、 Unzip to the directory you want to install

• Here is D:JAVA_EnvironmentMySQLmysql-8.0.21

3、 Add environment variables

• My computer –> attribute –> senior –> environment variable
• choice path add to ：mysql Install under directory bin Folder address

[ Failed to transfer the external chain picture , The origin station may have anti-theft chain mechanism , It is suggested to save the pictures and upload them directly (img-Espg85LO-1650586218956)(https://gitee.com/zhong_siru/images/raw/master/img/20200718152416.png)]

4、 newly build mysql The configuration file

• In your mysql Installation directory , newly build my.ini file , edit my.ini file , Be careful Replace path location

  [mysqld]
  basedir=D:JAVA_EnvironmentMySQLmysql-8.0.21
  datadir=D:JAVA_EnvironmentMySQLmysql-8.0.21data
  port=3306

D:JAVA_EnvironmentMySQLmysql-8.0.21 Change to your own directory

5、 install mysql service

• start-up Administrator mode Under the cmd, And switch the path to mysql Install under directory bin Catalog , Enter the following command

  cd d D:JAVA_EnvironmentMySQLmysql-8.0.21bin
  mysqld -install

[ Failed to transfer the external chain picture , The origin station may have anti-theft chain mechanism , It is suggested to save the pictures and upload them directly (img-l0zFQuqU-1650586218957)(https://gitee.com/zhong_siru/images/raw/master/img/20200718152434.png)]

6、 Initialization data file

• Enter the following command

  mysqld --initialize-insecure --user=mysql

7、 start-up mysql

net start mysql

[ Failed to transfer the external chain picture , The origin station may have anti-theft chain mechanism , It is suggested to save the pictures and upload them directly (img-vJdXkYcY-1650586218957)(https://gitee.com/zhong_siru/images/raw/master/img/20200718152528.png)]

8、 Get into mysql Modify password in management interface （ Enter the password for the first time and press enter ）

• Enter the first command below to enter the management interface （p There is no space after ！！）

• After entering the second command, change the password （ Finally, there must be a semicolon ）

  mysql -u root -p # Let you enter your password and enter directly
  ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘ Your password ’;

   The following results are successful ！
  

9、 restart mysql It can be used normally

# sign out mysql Management interface 
exit
# stop it mysql service 
net stop mysql
# Start mysql service 
net start mysql

---

If you want to see the typesetting better , Welcome to visit my personal blog ~
Click Here
thank you ~~

thank ~~