Windows Server 2008 64-bit MySQL5.6 installation-free version configuration method diagram

1 Download the MySQL 5.6 version compressed package from the official website, mysql-5.6.36-winx64.zip ;

2 Create a directory on drive D, such as D:\MySQL, and unzip mysql-5.6.36-winx64.zip to the directory, as shown in the following figure:

3 Modify the system Path variable and add D:\MySQL\bin, as shown in the following figure:

4 Run cmd as an administrator and switch to the D:\MySQL\bin directory.

Install the service mysqld –install

Start the service net start mysql

After the service is successfully started, log in through the mysql command line

mysql –u root –p

The initial root password is blank, just press Enter.

The whole process is shown in the figure below:

5 Change the root password

Follow these steps:

use mysql;
update user set password=password('yourpassword') where user='root';
flush privileges; 

Summarize

The above is the graphic description of the configuration method of the Windows Server 2008 64-bit MySQL5.6 free installation version 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!