Installation and configuration tutorial of MySQL 8.0.16 under Win10

1. Unzip MySQL 8.0.16

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

2. Create a new configuration file my.ini and place it in D:\Free\mysql-8.0.16-winx64 directory

[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:\Free\mysql-8.0.16-winx64
# Set the storage directory of mysql database data datadir=D:\Free\mysql-8.0.16-winx64\data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 20
# 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
# Ignore passwords# skip-grant-tables

As shown in the figure:

3. Initialize MYSQL configuration

Open Windows PowerShell as an administrator, enter D:\Free\mysql-8.0.16-winx64\bin directory, and execute the following command:

mysqld --initialize --console

After successful execution, the following figure is shown:

Among them, [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: is followed by the initialization password, i.e. diK3i1dH=k8b

After initializing the Mysql configuration, relevant files will be 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 already installed the mysql service, I use mysql8 as the service name, as shown below

mysqld --install mysql8

The command to start the service is: net start service name

net start mysql8

As shown in the following screenshot

5. Log in to MySQL and change the root password

Log in using the default assigned password (i.e. diK3i1dH=k8b)

mysql -uroot -pdiK3i1dH=k8b

After successful login, change the password to password

alter user 'root'@'localhost' IDENTIFIED BY 'password';

Just refresh it

flush privileges;

As shown in the figure below

6. Log in again

The new password can also log in successfully!

Summarize

The above is the installation and configuration tutorial of the free version of MySQL8.0.16 under Win10 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!