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

Install the unzipped version of MySql database under Windows 10

Step 1: Unzip 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 the path and add ;D:\MyGreenSoftware\mysql-5.7.10-winx64\bin at the end

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

(Here you need to create a data folder under D:\MyGreenSoftware\mysql-5.7.10-winx64\data)

[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 (first create a txt file, add the above four lines of code to it, 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 changed).

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 displays: [Note] A temporary password is generated for root@localhost: XXXXXXX
XXXXXX is the randomly generated password (copy and save it)

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

Step 6: Change your password (the random string just generated is hard 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>
Then execute set password for root@localhost = password('123456');
Your password has been changed to 123456

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.