MySQL 8.0.16 Win10 zip version installation and configuration graphic tutorial

This article shares with you the installation and configuration graphic tutorial of MySQL 8.0.16 Win10 zip version for your reference. The specific content is as follows

First go to the MySQL official website to download the latest version of MySQL

1. Select the community as shown in the picture

2. Click the download icon

3. Unzip to the specified disk

Example: F:\mysql8.0.16

4. Configure environment variables

MYSQL_HOME:F:\mysql8.0.16`

Add ;%MYSQL_HOME%\bin after the path

5. Add the file my.ini file

6. Put the following code into 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=F:\mysql8.0.16
# Set the storage directory of mysql database data datadir=F:\mysql8.0.16\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

Special attention: basedir and datadir, please modify them according to your actual installation directory

7. Open cmd.exe and run it as an administrator

7.1 Initialize the database

mysqld --initialize --user=mysql --console

Remember the assigned password:

7.2 Installation Service

mysqld --install MySQL

7.3 Start the service

net start MySQL

If the service is started successfully, everything is fine.

The first time you use mysql, you will be prompted to change the password

alter user 'root'@'localhost' identified by 'root' (new password)

After the modification is successful, you can log out and log in to mysql again

Other commands that may be used include:

Stop service

net stop MySQL

Deleting a service

sc delete MySQL (can be executed when a problem occurs)

Uninstall mysql

mysqld -remove

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.