Tutorial on how to install and configure the decompressed version of MySql under Windows 10

This article mainly introduces the tutorial on the installation and configuration method of the decompressed version of MySql under Windows 10 in detail. It has certain reference value. Interested friends can refer to it. I hope it can help you.

Install the decompressed version of MySql database under windows 10

Step one:Extract the zip file to (my) D:\MyGreenSoftware\mysql-5.7.10- winx64

Step 2:Add environment variables (Windows 10 operating system): Right-click Computer->Properties->Advanced System Settings->Environment Variables Find path and edit path in Add ;D:\MyGreenSoftware\mysql-5.7.10-winx64\bin

at the end. Step 3: Add the configuration file in the directory where MySQL is decompressed (for example, mine is D: \MyGreenSoftware\mysql-5.7.10-winx64), find the my-default.ini file and add

(here you need to find it under D:\MyGreenSoftware\mysql-5.7.10-winx64\data Create a data folder)

[mysqld]
basedir=D:\MyGreenSoftware\mysql-5.7.10-winx64
datadir=D:\MyGreenSoftware\mysql-5.7.10-winx64\data 
port = 3306

If the my-default.ini file is not found, create a my.ini file yourself (create it first A txt file, add the above four lines of code, save it and then change the file suffix to ini) Create a new text file txt and name it my.ini (note that the extension must also be modified).

Step 4: Initialize the database, open CMD as an administrator and execute the following command (enter cmd and right-click to run the following command as an administrator) mysqld –initialize –user= mysql –console

The console appears: [Note] A temporary password is generated for root@localhost: XXXXXXX
XXXXXX is a randomly generated password (copy it and save it) )

Step 5:Add MySQL to the system service, open CMD as an administrator and execute the following command
mysqld –install MySQL and then execute net start MySQL console appears The service starts successfully

Step 6:Change the password (the string just generated is a random string that is difficult to remember, so change it to one that is easy for you to remember)
Execute the command mysql -u root -p in the CMD console and press Enter. Enter the random password you just saved. After successful execution, the console will display mysql>
and then execute set password for root@localhost = password ('123456');
Your password has been changed to 123456

Related recommendations:

Detailed graphic explanation of encoding settings for MySQL installation

MySQL installation graphic and text explanation

Summary of issues regarding MySQL installation methods and configuration methods

The above is the detailed content of Tutorial on how to install and configure the decompressed version of MySql under Windows 10. For more information, please follow other related articles on the PHP Chinese website!