Home > Database > Mysql Tutorial > body text

Super detailed MySQL8.0.22 installation and configuration

coldplay.xixi
Release: 2021-02-16 10:03:59
forward
3419 people have browsed it

Super detailed MySQL8.0.22 installation and configuration

##Free learning recommendation: mysql video tutorial

Hello everyone, today we will learn about the installation and configuration of MySQL8.0.22. Read it carefully, learn it carefully, super detailed

The first step

Enter MySQL official website to download, as shown below:

Super detailed MySQL8.0.22 installation and configuration

##Step 2

After the download is complete, extract it to a disk other than the c drive, as shown in the figure below:

Super detailed MySQL8.0.22 installation and configuration

The third step

#The decompressed directory does not have the my.ini file. It doesn’t matter. You can create it yourself in the installation root directory. Add my.ini

(create a new text file, change the file type to .ini), and write the basic configuration:

[mysqld]# 设置3306端口
port=3306# 设置mysql的安装目录
basedir=C:\Program Files\MySQL
# 设置mysql数据库的数据的存放目录
datadir=C:\Program Files\MySQL\Data
# 允许最大连接数
max_connections=200# 允许连接失败的次数。
max_connect_errors=10# 服务端使用的字符集默认为utf8mb4
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎default-storage-engine=INNODB# 默认使用“mysql_native_password”插件认证
#mysql_native_password
default_authentication_plugin=mysql_native_password[mysql]# 设置mysql客户端默认字符集default-character-set=utf8mb4[client]# 设置mysql客户端连接服务端时默认使用的端口
port=3306default-character-set=utf8mb4
Copy after login

Super detailed MySQL8.0.22 installation and configuration

Step 4

Initialize MySQL. During installation, to avoid permission issues, we try to run CMD as an administrator. , otherwise an error will be reported during installation, which will cause the installation to fail, as shown in the following figure:

![Super detailed MySQL8.0.22 installation and configuration](https://img-blog.csdnimg.cn/20201029110701159.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNzE1MzU0,size_16,color_FFFFFF,t_70#pic_center

Step 5

After opening, enter the bin directory of mysql, enter

cd and spaces your path , as shown in the following figure:

Super detailed MySQL8.0.22 installation and configuration

Step 6

Enter

mysqld --initialize - in the bin directory under the MySQL directory -console, as shown below:

Super detailed MySQL8.0.22 installation and configuration
Super detailed MySQL8.0.22 installation and configuration

##If it appears In this case, go to Baidu and search for

VCRUNTIME140_1.dll. Just download and install this program, as shown below:

Super detailed MySQL8.0.22 installation and configuration

1. Unzip the downloaded file and copy the unzipped VCRUNTIME140_1.dll file

2. Open the file explorer and enter
windows folder, enter the system32 folder, and paste it. After pasting, you will be prompted to require administrator rights, give it to him! !

Step 7

Install the MySQL service, enter

mysqld --install [service name] (the service name can be omitted and defaults to mysql) , as shown in the figure below:

##Eighth Step Super detailed MySQL8.0.22 installation and configuration

After the service is installed successfully, enter

net start mysql

(start the MySQL service) , as shown in the figure below:

Step 9Super detailed MySQL8.0.22 installation and configuration

##Connect to MySQL, I use Navicat to show it, as follows As shown in the picture:

Super detailed MySQL8.0.22 installation and configuration
Super detailed MySQL8.0.22 installation and configuration
Super detailed MySQL8.0.22 installation and configuration
Super detailed MySQL8.0.22 installation and configuration

#This way you can use MySQL

Conclusion

##This is the introduction to the installation and configuration of MySQL8.0.22. Everyone is welcome to give your advice, communicate with each other, and learn together

Related free learning recommendations:

mysql database(Video)

The above is the detailed content of Super detailed MySQL8.0.22 installation and configuration. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:csdn.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template