MySQL 8.0.21 installation tutorial with pictures and text

1. Download the download link

Click download. You may need to log in to your Oracle account. Just log in.

2. Unzip and download to get an installation package

Just unzip it to a directory where you can find it. Mine is like this (you probably don't have the my.ini file)

3. Create my.ini

As shown in the figure, create a new file and change the suffix to ini. It is best not to change the file name. Open the file and copy and paste the following code into it

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=D:\\mysql-8.0.21-winx64
# Set the storage directory of mysql database data datadir=D:\\mysql-8.0.21-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 = 10
# The default character set used by the server is UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8

These two locations need to be modified according to your own installation path **(data remains unchanged)**

4. Environment Configuration Right-click My Computer and find Properties

Click this

continue

The variable value uses the address of your own bin directory

Then determine

5. Installation

Run cmd as administrator

Enter cd /d D:\mysql-8.0.21-winx64\bin (change to the address of your own bin directory later)

Enter mysqld --initialize --console . If the following screen appears, it is successful. Please remember the password at the end, otherwise it will be troublesome.

Then enter mysqld -install mysql

If the installation is successful, then the installation is successful.

Replenish:
1. If vcruntime140.dll error occurs during installation, go to the download address

Download the one that suits your computer.

This is the end of this article about the detailed graphic and text tutorial of mysql8.0.21 installation. For more relevant mysql8.0.21 installation content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!