mysql-8.0.15-winx64 decompression version installation tutorial and three ways to exit

1. Download from the official website and unzip

https://dev.mysql.com/downloads/mysql/

2. Set environment variables

Configure MYSQL_HOME to the MySQL decompression path and set %MYSQL_HOME%\bin in path

3. In the MySQL decompression path, create a new my.ini file to configure the initialization parameters:

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[mysqld]
#Set port 3306 port = 3306 
# Set the installation directory of mysql to basedir=D:\Java\mysql-8.0.15-winx64
# Set the storage directory of mysql database data datadir=D:\Java\mysql-8.0.15-winx64\data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

4. Initialize the database

Open the cmd command window as an administrator and enter the mysqld --initialize command to initialize the mysql data directory. After initialization, a data folder will be generated in the decompressed directory. In this folder, there is a file ending with .err. When opened, a randomly generated password will appear.

5. Installation service

# Register service mysqld --install
# Start the service net start mysql 

6. Change your password

ALTER USER USER() IDENTIFIED BY 'new password';

Login successfully with new password, done!

Problems encountered during installation

1. The service name is invalid

Cause of the problem: MySQL is not registered in the system, that is, there is no MySQL service in the current path.

Solution: Enter mysqld --install in the command line. If Service successfully install appears, it means the installation is successful.

2. Can log in in cmd, but not in Navicat

Tip: 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Cause of the problem: The encryption rule in versions before mysql8 is mysql_native_password, and after mysql8, the encryption rule is caching_sha2_password.

Solution: Restore the MySQL user login password encryption rule to mysql_native_password, or upgrade the Navicat driver

#Update the user's password rule ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; 
#Flush permissions FLUSH PRIVILEGES;

【Attached with small tips】

Quickly enter the administrator cmd

Add three ways to exit MySQL:

mysql > exit;
mysql > quit;
mysql> \q;

Summarize

The above is the detailed graphic installation tutorial of the mysql-8.0.15-winx64 decompression version introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time!