In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.