In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Development >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly explains "how to install and configure mysql 8.0.26". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to install and configure mysql 8.0.26.
1. Download MySql
Go to the official website and click the link to download.
Click the location shown below after the drop-down:
Start downloading, which may take a while.
Unzip it after the download is complete, and remember the path.
two。 Configure mysql
Preparatory work:
1) first create the configuration file my.ini in the above directory and copy the following code into the file
2). Set the data storage directory to the newly created data folder directory.
3) the installation directory is set to the previously downloaded directory
[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=F:\ mysql-8.0\ mysql-8.0.26-winx64# set the data storage directory of mysql database datadir=F:\ mysql-8.0\ data# allow maximum number of connections max_connections=200# allow the number of connection failures. 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
1) as an administrator, open the DOS window in the bin directory where mysql is unzipped:
Execute the above command and remember the password (system random):) aM9kIked5=Q
2) install and start the login mysql service:
3) execute the SQL statement to change the database password:
ALTER USER 'root'@'localhost' IDENTIFIED BY' the new password you want to set'
3. Configure environment variables
Right-click on this computer-> Properties-> Advanced system Settings-> Environment variables
Find the path where you downloaded the bin directory that extracted mysql:
And then determined all the way.
4. Inspection
You can log in with your own password:
At this point, I believe you have a deeper understanding of "how to install and configure mysql 8.0.26". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
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.