Windows MySQL 8 zip installation

1. Download from the official website zip Installation package ：MySQL Official website
   
2. Unzip in a directory , I put it in D:\software, Modify the extracted file mysql-8.0.11-winx64 Under the my.ini file , Set up
   basedir = D:/software/mysql-8.0.11-winx64/
   datadir = D:/software/mysql-8.0.11-winx64/data/
3. about mysql5.7 Later versions , You need to run the following command on the command line first , Installation services , A temporary password will be generated ：

 mysqld --initialize --console

If prompted by the following Cant create directory … Failure , The first 2 Step basedir and datadir The file directory is a backslash /, And need to be on your own mysql-8.0.11-winx64 Create one in the directory data Folder .
The following tips , Indicates successful initialization , The temporary password is gvTuqg-PV4ek：

4. Installation services ,mysqld -install service name
   for example ： mysqld -install MySQL8

5. perform net start MySQL8 start-up mysql,MySQL8 It is the service name named by itself , If not, the default is mysql.
   Note that if more than one... Is installed on the machine mysql, Because there is a line in the configuration file enable-named-pipe, Named pipes are enabled , And the default service names are MySQL, therefore , When you initialize the second mysql, Startup time , error , You can see err.log There's a hint in Can’t start server : Named Pipe “MySQL” already in use. Modify the configuration file , Add a setting , take socket Property is set to your service name （ Because your second mysql The service name must have been modified , Will not duplicate the first service name ）, therefore , Be sure to use your second mysql Service name of .
   socket=MySQL8
   socket=MySQL

6. Log in with the generated password mysql, for example ：mysql -uroot -pgvTuqg-PV4ek Sign in .-pgvTuqg-PV4ek It's my temporary password .

7. Be careful ： stay mysql5.7 In the environment , Although it can be set default_authentication_plugin To change the authentication encryption method , But it's not usually set . stay mysql8.0 Next , Default becomes default_authentication_plugin=caching_sha2_password, Including the one you just initialized root The user is also the authentication encryption method , The result is that unless you drive with a new protocol , For example, you must use 8.0 Self contained mysql Client only , At present, many database tools and link packages do not support “caching_sha2_password”, So you can't connect to the database , Cause incompatibility , fortunately , It can be changed back to the old way . modify my.ini
   default_authentication_plugin=mysql_native_password
   And then restart

8. After logging in, first modify root For localhost Password
   ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘root’;

9. If you need a remote connection , You need to create a for ’%' Users of

create user 'root'@'%' identified by '123456';

10. Create the corresponding database

create database test;

11. by test Database creation user

CREATE USER 'testuser'@'localhost' IDENTIFIED BY '123456';

12. Grant users access to the corresponding database
    The first is localhost user , The second is for remote users

GRANT ALL PRIVILEGES ON xx_db.* TO 'testuser'@'localhost';
GRANT ALL PRIVILEGES ON xx_db.* TO 'testuser'@'%' ;

13. use navicat Unable to connect to the database , Execute the following command

alter user 'root'@'%' identified with mysql_native_password by 'root';
alter user 'root'@'localhost' identified with mysql_native_password by 'root';