Summary of MySQL5 green version installation under Windows (recommended)

1 Download MySQL

Download address: http://downloads.mysql.com/archives/get/file/mysql-5.7.11-winx64.zip.

2 Installation process

2.1 Unzip mysql-5.7.11-winx64.zip to a directory.

The directory I unzipped is D:\mysqlDev\

2.2 Write the MySQL running configuration file my.ini, or modify the previous .ini file name to my.ini

Add the following content to my.ini:

[mysqld]
# Set the installation directory of mysql basedir = D:\mysqlDev\mysql-5.7.11-winx64\mysql-5.7.11-winx64
# Set the storage directory of mysql database data, must be data, or \\xxx\data
datadir = D:\mysqlDev\mysql-5.7.11-winx64\mysql-5.7.11-winx64\data
#Set port port = 3306
# Set the character set of the MySQL server to default-character-set=gbk
Note: If you do not see the character set string, you do not need to set [client]
# Set the character set of the mysql client to default-character-set=gbk

2.3 Install MySQL service

From the MS-DOS window, go to the directory D:\mysqlDev\mysql-5.7.11-winx64\mysql-5.7.11-winx64\bin and run the following command:

mysqld --install MySQL --defaults-file=D:\mysqlDev\mysql-5.7.11-winx64\mysql-5.7.11-winx64\my.ini

Note: There may be a problem here: Install/Remove of the Service Denied!

If this error is reported, try running cmd as an administrator

2.4 Start MySQL database

Still in the command window above, enter the command: net start MySQL

This starts the mysql service.

If the command does not work, click the computer on the desktop, then click "Manage", open the management tool, find the mysql service, and start it by right-clicking.

2.5 Deletion of Services

Execute mysqld --remove MySQL

The above is the summary of the installation of MySQL5 green version under Windows 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!