MySQL 5.7.17 winx64 free installation version configuration method graphic tutorial

Recent experience in installing mysql5.7.17 free installation version

1. Download and decompress

https://pan.baidu.com/s/1mi4UHtA

2. Set environment variables

path:

Configuration File

Copy my-default, paste it in the root directory and rename it to my

Inside my configuration file

Mainly modify basedir, datadir, port
Note: data is generated by itself and does not need to be created.

4. Command Prompt Operation (DOC) Note: Must be an administrator

1. Initialization

mysqld --initialize --user=mysql --console
Note: At this time, a random password (localhost) will be generated during initialization. Be sure to remember it.
2016-05-08T02:58:53.791057Z 1 [Note] A temporary password is generated for root@
localhost: UiS<C(.i(0yg

2. Installation

Then you will be prompted:
Service successfully installed.

3. Start the service: net start MySQL
Will prompt success
The service was started successfully.

4. Change password

5. Enter the previous random password

6. Then enter the password modification statement

set password for root@localhost = password('new password');

7. Stop service
net stop mysql
That's all.

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.