MySql 8.0.16-win64 Installation Tutorial

1. Unzip the downloaded file as shown below

.

2. Add the decompression directory to the environment variable

3. Create a new configuration file my.ini in the decompressed directory

[mysqld]
port=3306
basedir=D:\\DataBase\\MySql\\mysql-8.0.16-winx64 # Replace this with your own decompression directory datadir=D:\\DataBase\\MySql\\mysql-8.0.16-winx64\\Data
max_connections=200
max_connect_errors=10
character-set-server=utf8
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
[mysql]
default-character-set=utf8
[client]
port=3306
default-character-set=utf8

4. Run Cmd (remember to run it as an administrator) to unzip the MySql directory

5. Enter mysqld --initialize --console and record the initial password

6. Enter the command mysqld install to install the service

7. Enter the command mysql -u root -p and then enter the password to log in (the password here is the string pointed to by the arrow in step 5)

8. If the message "Can't connect to MySQL server on 'localhost' (10061)" is displayed, it means the service is not started.

9. Enter the command net start mysql to start the MySQL service

10. Enter the command mysql -u root -p again and enter the password to log in. If the login is successful, the following page will appear

11. Enter the command alter user root@localhost identified by 'new password'; to change the password

Summarize

The above is the MySql 8.0.16-win64 installation tutorial 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!