☆☆☆☆☆☆☆ Windows7 Configuring the Free-install version mysql5.7.21☆☆☆☆☆☆☆

• 1. Download the installation package

• 2. Unzip to the local directory

F:\mysql-5.7.21-winx64

• 3. Add MySQL environment variable

Mysql_home = F:\mysql-5.7.21-winx64

• 4. Modify the PATH environment variable

Path variable, the end of the new ;%mysql_home%\bin;

• 5. Manually create the relevant folder/file (the contents of the file is empty)

F:\mysql-5.7.21-winx64\xudebiaof:\mysql-5.7.21-winx64\xudebiao\dataf:\mysql-5.7.21-winx64\xudebiao\logf:\ Mysql-5.7.21-winx64\xudebiao\log\mysql-error.logf:\mysql-5.7.21-winx64\xudebiao\tmpf:\mysql-5.7.21-winx64\ Xudebiao\tmp\mysql.sock

• 6. Create a new My.ini configuration file

# for advice The change settings see# http://dev.mysql.com/doc/refman/5.7/en/ server-configuration-defaults.html# * * * does not EDIT the this FILE. It's a template which'll be copied to the# * * * default location during install, and would be replaced if you# * * * Upgrade To a newer version of MySQL. [client]port=3306socket=f:\mysql-5.7.21-winx64\xudebiao\tmp\mysql.sockdefault-character-set=utf8[mysqld]# Remove leading # and set to the amount of RAM for the most important data# caches in MySQL. Start at 70% of all RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128m# Remove Leading # to turn on a V ery important data Integrity option:logging# changes to the binary log between backups.# log_bin# These is commonly set, Remove the # and set as required.# Basedir = ..... # DataDir = ... # ... # port = ... ... # server_id = ... ... # socket = ..... user= Mysqlbasedir=f:\mysql-5.7.21-winx64datadir=f:\mysql-5.7.21-winx64\xudebiao\dataport=3306socket=f:\ Mysql-5.7.21-winx64\xudebiao\tmp\mySql.sockmax_connections=1000max_connect_errors=1000table_open_cache=1024max_allowed_packet=128mcharacter_set_ Server=utf8collation-server=utf8_general_cilower_case_table_names=1log_error=f:\mysql-5.7.21-winx64\xudebiao\ Log\mysql-error.logslow_query_log=1long_query_time=1slow_query_log_file=f:\mysql-5.7.21-winx64\xudebiao\log\ Mysql-slow.logsymbolic-links = 0# Remove Leading # To set options mainly useful for reporting servers.# the server default S is faster for transactions and fast selects.# Adjust sizes as needed, experiment to find the optimal values.# Join_buff Er_size = 128m# Sort_buffer_size = 2m# read_rnd_buffer_size = 2msql_mode=no_engine_substitution,strict_trans_tables   

• 7. Preparation of the work done

• 8. Execute the Install command

Administrator run the command prompt to enter F:\mysql-5.7.21-winx64\bin The first step to perform the initialization operation: Mysqld--initialize-insecure The second step of performing the installation service operation: MYSQLD Install the third step to start the MySQL service: net start MySQL "Under normal circumstances, you will be prompted to succeed directly. If it fails, the 5th step above clears the data (F:\mysql-5.7.21-winx64\xudebiao\data ) directory, execute command again "

• 9. Modify the initial password

Mysql-u root-p First time login no password, enter the password when the direct return

Set password = password (' 1990xxxx ');

• 10. Login Test

• 11. Confirm the encoding format UTF8

Show variables like '%character% ';

OK, you can drive on the road ~

☆☆☆☆☆☆☆ Windows7 Configuring the Free-install version mysql5.7.21☆☆☆☆☆☆☆