This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › MySQL › MySQL 8.0.36 installation tutorial under Windows
View: 3436|Reply: 2

[Source] MySQL 8.0.36 installation tutorial under Windows

[Copy link]
Posted on 4/11/2024 7:52:21 PM | | | |
Needless to say, MySQL database Programmers know, how to install MySQL 8.0.36 service on Windows?

Download:The hyperlink login is visible., select "mysql-8.0.36-winx64.zip" to download, as shown in the figure below:



Extract to a specified directory according to your needs, for example:C:\Database\mysql-8.0.36-winx64to create a new my.ini file under the directory and configure it as follows:

Go to the bin folder and initialize it with the following command:



Remember the generated password and start installing the MySQL service with the following command:

Start the service with the following command:

Add the MySQL bin path to the environment variable and go to the console via mysqld. (omitted)



After entering, you need to change the password, otherwise the error will be as follows:

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
The command to change the password is as follows:

(End)





Previous:Download and install the configuration tutorial for Windows Maven
Next:Website module requirements

Related Posts
 Landlord| Posted on 4/11/2024 7:54:59 PM |
Caching SHA2 password and MySQL native password are two different plugins used in the MySQL database management system for authentication. The main difference between these two plugins is the hashing algorithm and security they use

distinguish

MySQL native password: This is the default authentication plugin for earlier versions of MySQL, which uses the SHA1 hash function to hash passwords and store them in the database. When a user tries to log in, the system will hash the entered password the same and then compare it to the stored hash. If the two match, the user is authorized to log in. However, the security of SHA1 has been questioned many times in recent years, so MySQL introduced new authentication plugins in subsequent releases

Caching SHA2 password: This is the default authentication plugin for MySQL 8.0 and later. It uses the more secure SHA-256 hash function. In addition to providing increased security, this plugin also introduces a new feature – password caching. This means that once a user successfully logs in, their password (to be precise, the hash of the password) is cached. Therefore, if the user tries to log in again, the system can perform password verification directly from the cache without having to go through the full hashing process again. This can greatly improve the performance of the system
 Landlord| Posted on 4/12/2024 2:24:41 PM |
CentOS 7 uses rpm to install the MySQL database
https://www.itsvse.com/thread-10242-1-1.html
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com