Detailed tutorial on installing mysql-8.0.13 (zip installation) on windows 10 system

Installation Environment Description

•System version: windows10
•MySQL version: mysql-8.0.13-winx64.zip
• Download address: http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.13-winx64.zip

Unzip the installation package

• Unzip path: D:\develop\software
•After decompression, the mysql root directory is: D:\develop\software\mysql-8.0.13-winx64

Principle: The installation directory cannot contain spaces or Chinese characters.

Configuration Files

•Copy the my.ini file to the mysql root directory. The file path is: D:\develop\software\mysql-8.0.13-winx64\my.ini
•The content of my.ini is as follows:

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8mb4
[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=D:\\develop\\software\\mysql-8.0.13-winx64
# Set the storage directory for the MySQL database data. MySQL 8+ does not require the following configuration, the system can generate it by itself, otherwise an error may be reported # datadir=D:\\develop\\software\\mysql-8.0.13-winx64\\data
# Maximum number of connections allowed max_connections=20
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8mb4
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

Note: There is no need to set the data directory, it will be automatically generated, otherwise an error will be reported! Double slash! ! ! ! ! !

Initialize mysql

• Go to D:\develop\software\mysql-8.0.13-winx64\bin
• Execute mysqld --initialize --console

Note: Run the cmd program with administrator privileges, otherwise an error may occur

[Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 3yMoxa?*nMrl

Automatically generate temporary password: [3yMoxa?*nMrl]

E:\mysql-8.0.13-winx64\bin\mysqld.exe (mysqld 8.0.13) initializing of server has completed

Initialization completion prompt.

Register mysql service

mysqld install

Start mysql

net start mysql

Login to mysql

mysql -uroot -p

Note: Enter the temporary password generated above [3yMoxa?*nMrl]

Change password and modify password policy

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your password';

Note: Many MySQL client tools do not support the new password policy of MySQL 8, so use the original password policy.

Finish.

Summarize

The above is a detailed tutorial on how to install mysql-8.0.13 (zip installation) on windows 10. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!