MySQL 5.7.20 compressed version download and installation simple tutorial

1. Download address:

http://dev.mysql.com/downloads/mysql/

1. Go to the official website to download, the latest version should be displayed, select the second one (mysql5.7.20-winx64.zip)

2. After downloading, decompress it directly to the custom directory. The decompressed directory is the installation directory

2. Configure environment variables

1. Add new environment variables, for example:

Variable Name: MYSQL_HOME

Variable value: D:\mysql\mysql5.7.20-winx64

2. Modify the environment variable PATH

Add %MYSQL_HOME%\bin after PATH. Note: Adding new variable values ​​needs to be separated by ;

3. Add my.ini configuration file

1. There is no my.ini configuration file and data folder in the downloaded compressed file. You need to manually create a new text my.ini in the bin directory. If it is placed in the root directory, data cannot be automatically generated (which pitted me for a long time). The content of my.ini is as follows:

[client]
default-character-set=utf8
 [mysqld]
#Unzip directory basedir = %MYSQL_HOME% 
#Unzip directory datadir = %MYSQL_HOME%\data
 port = 3306 
 default-character-set=utf8

4. Initialize mysql and start the mysql service

1. Run the command line cmd as an administrator and enter the bin directory (be sure to enter the bin directory)

Example: cd D:\mysql\mysql5.7.20-winx64\bin

2. Enter the command: mysqld

--initialize-insecure (生成無密碼的root用戶)

A data folder will be generated in the root directory, which contains files

3. Start the service: net start mysql, stop the service: net stop mysql

The mysql service has been started successfully.

4. Set mysql password

mysqladmin -u root password 密碼

5. Success

Others: Remove the service command in the bin directory (mysqld --remove)

Summarize

The above is the simple tutorial for downloading and installing the compressed version of MySQL 5.7.20 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!