MySQL 5.7.21 winx64 installation and configuration method graphic tutorial under Windows 10

mysql 5.7.21 winx64 installation and configuration method:

Download the community version of MySQL, download address (you need to register an Oracle account before downloading)

Unzip

Configuring environment variables

Add the following to the system variable path: C:\mysql-5.7.21-winx64\bin (pointing to the bin path of mysql)

initialization

Open cmd as an administrator and enter the command (the data directory is created under the installation directory during initialization, otherwise it will report that the path does not exist):

mysqld --initialize --user=mysql --console

A temporary root password will be generated during initialization, and the user needs to remember it for subsequent logins.

Install

Continue to enter the command at the command prompt: mysqld -install

Start the service

net start mysql

Log in

mysql -uroot -p

Change root password

ALTER USER 'root'@'localhost' IDENTIFIED BY '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.