Shulou(Shulou.com)06/01 Report--

1. Decompress MySQL8.0.16

The dada folder and my.ini configuration file are added manually after decompression, as shown in the following figure

2. The new configuration file my.ini is placed in the D:\ Free\ mysql-8.0.16-winx64 directory

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=D:\ Free\ mysql-8.0.16-winx64# set mysql database data storage directory datadir=D:\ Free\ mysql-8.0.16-winx64\ data# maximum number of connections max_connections=200# allows the number of connections to fail. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=20# server of the database system from this host. The default storage engine default-storage-engine=INNODB# that will be used when creating a new table is the 8-bit latin1 character set character-set-server=utf8# ignores the password # skip-grant-tables.

As shown in the figure:

3. Initialize MYSQL configuration

As an administrator, open Windows PowerShell and go to the D:\ Free\ mysql-8.0.16-winx64\ bin directory and execute the following command:

Mysqld-initialize-console

After successful execution, it is shown in the following figure:

Where [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: is followed by the initialization password, namely diK3i1dH=k8b

After initializing the Mysql configuration, the relevant files are generated in the data directory, as shown below

4. Install the MySQL service and start the service

The command to install the service is: mysqld-- install service name. Since my computer has been configured to install the mysql service, use mysql8 as the service name here, as shown below

Mysqld-install mysql8

The start service command is: net start service name

Net start mysql8

The screenshot is as follows

5. Log in to MySQL and change the root password

Log in with the default assigned password (that is, diK3i1dH=k8b)

Mysql-uroot-pdiK3i1dH=k8b

After logging in successfully, change the password to password

Alter user 'root'@'localhost' IDENTIFIED BY' password'

Just refresh it.

Flush privileges

As shown in the following figure

6. Log in again

The new password can also log in successfully!

Summary

The above is the illustration of the installation and configuration tutorial of the free installation version of MySQL8.0.16 under Win10 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.