Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to install and configure MySQL8.0.22

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

The editor will share with you how to install and configure MySQL8.0.22. I hope you will get something after reading this article. Let's discuss it together.

The first step

Go to the official website of MySQL to download, as shown below:

Step two

After entering the download, extract it to a disk other than disk c, as shown in the following figure:

Step three

There is no my.ini file in the extracted directory. You can create the my.ini added under the installation root directory (create a new text file and change the file type to .ini) and write to the basic configuration:

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=C:\ Program Files\ MySQL# set the data storage directory of mysql database datadir=C:\ Program Files\ MySQL\ Data# allow the maximum number of connections max_connections=200# allows the number of connections to fail. The character set used by the max_connect_errors=10# server defaults to the default storage engine default-storage-engine=INNODB# that utf8mb4character-set-server=utf8mb4# will use when creating new tables using the "mysql_native_password" plug-in authentication # mysql_native_passworddefault_authentication_plugin=mysql_native_ password [MySQL] # setting the mysql client default character set default-character-set=utf8mb4 [client] # setting the default port port=3306default-character-set=utf8mb4 when the mysql client connects to the server

The fourth step

Initialize MySQL to avoid permission errors during installation. We try to run CMD as an administrator, otherwise an error will be reported during installation, resulting in installation failure, as shown in the following figure:

Step five

After opening it, enter the bin directory of mysql, and enter cd + space + your path, as shown below:

Step six

Enter mysqld-- initialize-- console under the bin directory under the MySQL directory, as shown in the following figure:

If this happens, just go to Baidu search VCRUNTIME140_1.dll to download and install the program, as shown in the following figure:

1. Extract the downloaded file and copy the extracted VCRUNTIME140_1.dll file

two。 Open File Explorer, enter the windows folder, enter the system32 folder, paste can be, paste will prompt the need for administrator permissions, give him!

Step 7

To install the MySQL service, enter mysqld-- install [Service name] (the service name can be mysql by default), as shown in the following figure:

Step 8

After the service is installed successfully, enter net start mysql (start the service of MySQL), as shown below:

Step 9

Connect to MySQL, which I will show with Navicat, as shown in the following figure:

So you can use MySQL.

After reading this article, I believe you have a certain understanding of "how to install and configure MySQL8.0.22". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report