mysql-8.0.17-winx64 deployment method

1. Download mysql-8.0.17-winx64 from the official website and choose Zip file format to download

2. Unzip to the target path. In my case, it is the root directory of drive E, that is, E:\mysql8

3. Create my.ini in the root directory with the following content:

[mysqld]
#Port port = 3306
#mysql installation directory basedir = E:/mysql8
#mysql data storage directory datadir = E:/mysql8/data
#Maximum number of connections allowed max_connections = 1024
#The server uses the character set character-set-server = utf8 by default
#Default storage engine default-storage-engine = INNODB
#Service unique identifier server_id = 1
#Whether to enable slow query slow_query_log = 1
#Specify the path and name of the slow query log file slow_query_log_file = E:/amp/mysql8/data/mysql-slow.log
#SQL statements will be recorded only if their execution time exceeds this value long_query_time = 10
#Error log log-error = E:/mysql8/data/mysql-err.log
#Open binlog log-bin = E:/mysql8/data/mysql-bin
#sql mode sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#Note here that the default password verification plugin for mysql8 has been changed to caching_sha2_password
#For compatibility with the previous one, change back to mysql_native_password
default_authentication_plugin = mysql_native_password
[mysql]
default-character-set = utf8
[client]
port = 3306
default-character-set = utf8

4. The administrator runs CMD, first cd\ and then enter E: to enter the E drive, and then enter the target bin directory, that is, E:\mysql8\bin

5. Execute mysqld --initialize-insecure

6. Execute mysqld --install mysql

7. Execute net start mysql, and it will prompt that the service has been started successfully, indicating that the Mysql service is OK

8. Command line input:

mysql -u root -p

You can log in successfully and the message welcome to the mysql monitor will appear! , it means the login is successful.

9. Close the current command line and restart cmd.exe

Type mysqladmin -u root -p password

Press Enter.

When "Enter password:" appears, just press Enter. If no password is set, there is no password by default.

Then "New password:" appears, enter the new password and press Enter.

Then "Confirm new password:" will appear to confirm the password, just press Enter.

After changing the password, the next time you log in,

Type mysql -u root -p , then enter the set password to log in.

Summarize

The above is the mysql-8.0.17-winx64 deployment method 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!