Graphic tutorial for installing MySQL 5.6.35 on Windows 10 64-bit

1. Download MySQL Community Server 5.6.35

Download address: http://dev.mysql.com/downloads/mysql/5.6.html

2. Unzip the MySQL archive

Unzip the downloaded MySQL compressed package to a custom directory. I put it in D:\Program Files\MySQL\

Add environment variables (I think you only need to add them to user variables, and try not to modify system variables)

Variable Name: MYSQL_HOME

Variable value: D:\Program Files\MySQL

That is the custom decompression directory of mysql.

Then add %MYSQL_HOME%\bin to Path

Register Windows system service

Register MySQL as a Windows system service

The operation is as follows:

1) Right-click the start menu and select "Command Prompt (Administrator)"

2) Enter the service installation command:

mysqld install MySQL –defaults-file="D:\Program Files\mysql-5.6.11-winx64\my-default.ini"

After the installation is successful, a message will pop up saying that the service has been successfully installed.

If D:\Program Files\MySQL\bin>mysqld install MySQL –defaults-file="D:\Program Files\MySQL\my-default.ini" appears
The service already exists!
The current server installed: “D:\Program Files\MySQL\bin\mysqld” –defaults-file="D:\Program Files\MySQL\my-default.ini” MySQL

Indicates that the service has been registered and can be removed.

The command to remove the service is: mysqld remove

5. Start MySQL service

Method 1:

The command to start the service is: net start mysql

Method 2:

Open the management tool service and find the MySQL service.

Start the service by right-clicking and selecting Start or directly clicking Start on the left.

6. Change the root account password

When the installation is just completed, the default password of the root account is empty. At this time, you can change the password to the specified password. For example: 123456

Method 1:

c:>mysql –uroot 
mysql>show databases; 
mysql>use mysql; 
mysql>UPDATE user SETpassword=PASSWORD("123456") WHERE user='root'; 
mysql> FLUSH PRIVILEGES; 
mysql>QUIT

Method 2:

Use third-party management tools to change passwords. Such as Navicat for MySQL

The above is the graphic tutorial for installing MySQL5.6.35 on Windows 10 64-bit introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!