MySQL Download configuration

Download

: https://www.mysql.com/

Go to the MySQL official website, choose Downloads, here is the Community Edition (there is Community Edition and Enterprise Edition), which has the installation version also has the decompression version (installs the version according to the fifth step), here the download is the decompression version according to fourth step.

Here if there is an account directly login, not the first registration, about login registration is not explained, log in directly after the download on the line.

2 configuration

After extracting the directory, add the My.ini config file in the current directory

My.ini configuration content is as follows

[mysql]default-character-set=utf8[mysqld]port=3306character_set_server=utf8# Extract Directory Basedir=d:\develop\ mysql-5.7.19-winx64# Extract Directory Data directory datadir=d:\develop\mysql-5.7.19-winx64\data# allow maximum number of connections max_connections=200# The default storage engine that will be used when creating new Default-storage-engine=innodb  Sql_mode=no_engine_substitution,strict_trans_tables

Run the command prompt as administrator (otherwise it will fail), enter the command mysqld-install the bin directory of the MySQL decompression directory

At this point, the net start MySQL command cannot be run, at which time the service cannot start and needs to be initialized first

Input Initialization Command mysqld--initialize (note here is double--, cannot be omitted), and then in the Start MySQL service, enter net start MySQL

MySQL Download configuration