"Mysql" Installation mysql-5.7.5 guide

• Because students need to install MySQL, the installation process, all the way to Baidu, here to record a step-playing. It will be used in the future.

1.mysql-5.7.5-m15-winx64.zip Download

　　　　　Official website:http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-5.7.5-m15-winx64.zip Direct Thunder this address

　　2. Unzip to D:\MySqlDataBase 3. Create a new My.ini profile under D:\MySqlDataBase\mysql-5.7.5-m15-winx64

################### #配置文件开始 ################### # for advice in how to 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'll be replaced if you # * * * Upgra De to a newer version of MySQL. [Client] Default-character-set=utf8 [mysqld] port=3306 basedir = "d:\mysqldatabase\mysql-5.7.5-m15-winx64/" DataDir = " d:\mysqldatabase\mysql-5.7.5-m15-winx64/data/"Tmpdir =" d:\mysqldatabase\mysql-5.7.5-m15-winx64/data/"socket =" D : \mysqldatabase\mysql-5.7.5-m15-winx64/data/mysql.sock "log-error=" D:\mysqldatabase\mysql-5.7.5-m15-winx64/data /mysql_error.log "#server_id = 2 #skip-locking max_connections=100 table_open_cache=256 query_cache_size=1m tmp_table_ size=32m thread_cache_size=8 innodb_data_home_dir= "d:\mysqldatabase\mysql-5.7.5-m15-winx64/data/" Innodb_flush_ Log_at_trx_commit =1 innodb_log_buffer_size=128m innodb_buffer_pool_size=128m innodb_log_file_size=10m innodb_thread_concurrency=16 innodb-autoextend-increment=1000 join_buffer_ Size = 128M Sort_buffer_size = 32M Read_rnd_buffer_size = 32M Max_allowed_packet = 32M Explicit_defaults_for_timestamp=tru E sql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution" #sql_mode =no_engine_substitution, strict_trans_tables################### #配置文件结束 ###################

4. In the Windows System environment variable path, add the following:

　　　　　　D:\mysql\mysql-5.7.5-m15-winx64\bin; (note plus semicolon)

5. Open cmd to go to the installation path of the bin file Plus, and then enter the instruction "Mysqld-install" 6. Then continue to enter the command "net start MySQL" in Cmd to show that the MySQL service has started successfully 7. Enter Mysql-u root in cmd -P to start working on the database.

"Mysql" Installation mysql-5.7.5 guide