MySQL8. 0 installation / uninstallation tutorial [window10 version]

First step Download installation package

1、 visit MySQL Official website ：https://dev.mysql.com/downloads/mysql
2、 Select the installation package version , Download resources , See the figure below for details

The second step Unzip the installation package

1、 Unzip the installation package downloaded in the first step
2、 Move the unzipped folder to the specified directory , You can then rename the folder , It's ok if you don't change it , Here's the picture

The third step Configuration environment

1、 Enter the MySQL Install... In package bin Catalog , And copy this path , My is ：C:\APP\MySQL\mysql8\bin
2、win key + D key Return to the system desktop , Right click This computer , Choose attribute , Enter the system panel interface
3、 choice Advanced system setup , Choose senior + environment variable , Enter the environment configuration interface , Here's the picture ：

4、 Enter environment variable configuration , The specific steps are as follows ：



5、 After the environment is configured , Click ok , Close the system pop-up window
6、mysql Create a new file in the installation directory my.ini（ The file suffix should be correct ）, And write the following contents into the file ：

#  Server configuration 
[mysqld]
#  Set up 3306 port 
port=3306
#  Set up mysql Installation directory 
basedir=C:\APP\MySQL\mysql8
#  Set up mysql Database data storage directory 
datadir=C:\APP\MySQL\mysql8\data
#  Maximum connections allowed 
max_connections=200
#  Number of connection failures allowed （ This is to prevent someone from trying to attack the database system from the host ）.
max_connect_errors=10
#  The character set used by the server defaults to UTF8
character-set-server=utf8
#  The default storage engine that will be used when creating a new table 
default-storage-engine=INNODB
#  By default “mysql_native_password” Plug in authentication 
default_authentication_plugin=mysql_native_password
#  Client configuration 
[mysql]
#  Set up mysql Client default character set 
default-character-set=utf8
[client]
#  Set up mysql The default port when the client connects to the server 
port=3306

default-character-set=utf8

Step four install

1、 Open the command line window ： Get into mysql In the installation directory of bin Catalog , Click in the path box , Enter the command ：cmd, Open the command line run window , Here's the picture ：


2、 Initialize database
2.1 Enter the command... In the command line window ：

mysqld --initialize --console

If there is a pop-up error after running the above initialization command ： Because we couldn't find it vcruntime140_1.dll, Can't continue executing code . Re installing the program may fix this problem , Click here to see the solution .

2.2 After the execution of the above command , The system automatically generates the initialization account and password , recorded .

If you accidentally turn it off cmd Window or didn't remember the account password , Delete the initialized data Catalog , You can execute the initialization command once .

5、 ... and 、 Installation services

1、 With Run as Administrator cmd Command line window , Switch to MySQL Install under directory bin Catalog ：

cd C:\APP\MySQL\mysql8\bin

2、 Run the install Service Command ：

mysqld --install [ service name ]  #  The default service name here is mysql, You can customize 

After installation , Open the service window and you can see your customized service .


3、 Start the service ：

net start MySQL8  # MySQL8 Custom service name for you 

4、 Out of Service ：

net stop MySQL8  # MySQL8 Custom service name for you 

6、 ... and 、 Connect to database

1、 open cmd Command line window , Enter the following command ：

mysql -u root -p  # mysql -u  Account  -p

2、 Change account password , Enter the following command ：

alter user 'root'@'localhost' identified with mysql_native_password BY ' New password ';
#  Example ：alter user 'root'@'localhost' identified with mysql_native_password BY '123456';

3、 Enter the command ：quit, Exit database
4、 Use the new password , Repeat the first step , Log back into the database .

7、 ... and 、 uninstall

1、 Use Run as Administrator cmd, close mysql service ;
2、 Delete mysql service ：

sc delete  service name 
 perhaps  
mysqld remove  service name 

3、 Delete mysqlDB Directory file （ Install mysql when my.ini Specified directory ）