MySQL 8.0.14 installation and configuration method graphic tutorial

This article records the installation and configuration process of MySQL 8.0.14 for your reference. The specific contents are as follows

1. Download

Address: Download address

Find the zip file.

2. Configure environment variables

Configure the unzipped path to the environment variable

3. Installation

Create a new my.ini configuration file in the unzipped folder

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=C:\Program Files\MySQL\mysql-8.0.14-winx64
# Set the storage directory of mysql database data datadir=C:\Program Files\MySQL\mysql-8.0.14-winx64\Data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed.
max_connect_errors=10
# The default character set used by the server is UTF8
character-set-server=UTF8MB4
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
#Default authentication is done with the "mysql_native_password" plugin #mysql_native_password
default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=UTF8MB4
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=UTF8MB4

Note: Configure the default character set to use UTF8MB4, otherwise an error will be reported. UTF8MB4 allows a character to have a maximum of 4 bits. Since 3 bits will cause an error, 4 bits are added. This version cannot be installed without using mb4.

Run cmd as administrator

cd Switch directory to the mysql bin directory

run

mysqld --initialize --console

A password will be generated after root@localhost

Then run

mysqld --install
net start mysql

Complete the installation.

When using navicat to connect, you will be prompted to reset the password.

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.