Installation method of mysql-8.0.17-winx64 under windows 10

1. Download from the official website and unzip

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

After downloading, it is a zip compressed file: mysql-5.7.26-winx64.zip, then decompress this file;

After decompression, I put the decompressed files in D:\mysql-5.7.26-winx64;

2. Set environment variables

Configure MYSQL_HOME to the MySQL decompression path: D:\mysql-5.7.26-winx64, and set %MYSQL_HOME%\bin，若是win7系統，則需要這樣填寫：;%MYSQL_HOME%\bin如下圖所示：

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

[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:\mysql-8.0.17-winx64
# Set the storage directory of mysql database data datadir=D:\mysql-8.0.17-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. As shown in the following figure:

5. Installation service

Execute the following command in cmd

# Registering Services

mysqld --install

#To delete mysql, execute the command mysqld --remove mysql, as shown in the following figure:

# Start the service net start mysql, as shown below:

#Stop the service net stop mysql, as shown below:

Log in to the MySQL database and use the command: mysql -u root -p. The initial password is the password corresponding to the screenshot above: o/wU!>G8lgzr, as shown in the following figure:

6. Change your password

ALTER USER USER() IDENTIFIED BY '輸入新密碼'；

Summarize

The above is the installation method of mysql-8.0.17-winx64 under Windows 10 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. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!