Shulou(Shulou.com)06/01 Report--

This article mainly tells you how to install and configure the decompressed version of MySql under windows10. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on how to install and configure the decompressed version of MySql under windows10 can bring you some practical help.

Install the decompressed MySql database under windows 10

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

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

(here you want to create your own data folder under D:\ MyGreenSoftware\ mysql-5.7.10-winx64\ data)

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

If you do not find the my-default.ini file, create a my.ini file (first create a txt file to add the above four lines of code to save and then change the file suffix to ini on the line) to create a new text file txt, and name it my.ini (note that the extension should also be modified).

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

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 the net start MySQL console when the service starts successfully

Step 6: change the password (what you just generated is a random string. It's hard to remember and change it to something you can easily remember.)

Execute the command mysql-u root-p in the CMD console, enter the random password you just saved, and after successful execution, the console will display mysql >

Then execute set password for root@localhost = password ('123456')

Your password has been changed to 123456

This is how to install and configure the decompressed version of MySql under windows10. If you want to know about other related issues, you can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.