MySQL 8.0.20 installation tutorial and detailed tutorial on installation issues

Original address: https://blog.csdn.net/m0_46579864/article/details/105981304

Download the MySQL installation package from the official website

1. Download link as follows:

MySQL version 8.0.20

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-20.html

Other versions: MySQL 8.0.16

2. The MySQL 8.0.20 version compressed package is decompressed as shown below:

Add and configure the my.ini file

Add the my.ini file in the original decompression root directory :
Create a new text file, that is, a Notepad file, and name it my.ini (that is, the extension is in ini format). If you cannot change the extension, click here to learn more about the solution.

Write the following basic configuration in the my.ini file :

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of MySQL basedir=D:\\Program Files\\MySQL
# Set the storage directory of mysql database data#datadir=D:\\Program Files\\MySQL\\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 utf8mb4
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

3. After the configuration file is processed, the files in the root directory are as follows:

4. Notes :
MySQL versions below 8.0.18 need to manually configure the Data folder (remove the # sign from the front of the datadir line that I commented out, as shown below). The path filled in is the path location where you want to install MySQL!

datadir=D:\\Program Files\\MySQL\\Data

Configure system variables and initialize MySQL

1. Create the installation location for MySQL:
Create a Program Files folder on drive D, create a MySQL folder under it, and then copy the MySQL files you just unzipped and the my.ini file you just added to this folder. The effect is as follows (you can also install it on other disks, but pay attention to the path of the configuration file in the my.ini file):

2. Configure the system environment variable Path

Add the path of the bin folder to the path variable, then save and exit. Click Go to learn how to open the system environment.

3. Initialize MySQL
Run cmd as an administrator. Click here to learn how to run cmd as an administrator.

4. Execute the command to enter the bin directory of the MySQL installation location:
If the installation location is not the system drive (C drive), then you need to add /d to the command. If it is the system drive (C drive), you do not need to add /d.

cd /d D:\Program Files\MySQL\bin

5. Execute the MySQL installation command:

mysqld --initialize --console

After successful installation, please remember the initial password of the data layer:
The password is root@localhost:

Install and start MySQL

1. Execute the command to install the MySQL service:

mysqld --install

2. Execute the command to start the MySQL service:

net start mysql

Navicat connects to MySQL and changes its password

1. Open Navicat and connect to the database you just created

2. Change the data password (remember the new password)
After the database connection is successful, a password change window will pop up. Just enter the new password in this window!

Click to learn the basic usage of Navicat

Common problems and solutions during installation

1. MySQL installation was not initialized properly:

That is, the account and password column does not appear, as shown in the figure below. The reason for this is that there is a problem with the encoding format of the configuration file my.ini (when directly copying someone else's my.ini file, some systems will change the original encoding format), which causes garbled characters to appear when calling in the command line window and cannot be recognized normally.

Solution:

a. Delete the original my.ini file and create a new Notepad document in the root directory of the MySQL installation location;
b. Save the newly created Notepad file as my Notepad file in the directory. The encoding format of the document when saving is ANSL

c. Then change the extension of the my.txt file to ini, enter the configuration information and click Save, then re-initialize the MySQL installation in the command box to solve the problem.

2.mysql.exe - System Error (due to VCRUNTIME140_1.dll not found...)

The reason for this type of error is that the system lacks a common command plug-in. This problem can be solved by downloading and installing it.

Related software download links

1. Navicat 15 version

Summarize

This is the end of this article about the MySQL 8.0.20 installation tutorial and the detailed tutorial on how to solve installation problems. For more relevant MySQL 8.0.20 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!