MySQL 5.7.9 install free version

1. MySQL official website: http://dev.mysql.com/downloads/ Download

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/79/6E/wKiom1aQrJOwGKAaAAHGPNJvoVo791.png "title=" capture. PNG "alt=" Wkiom1aqrjowgkaaaahgpnjvovo791.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/79/6D/wKioL1aQrUbDvqZCAAB0jcuFi3w243.png "title=" capture. PNG "alt=" Wkiol1aqrubdvqzcaab0jcufi3w243.png "/>

2. in the Windows System environment variable path, add the following:

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

3. Create a My.ini directory file under the D:\Program files (x86) \mysql-5.7.9-winx64 directory

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/79/6D/wKioL1aQrgGjY3zUAADpgHZf9yU460.png "title=" capture. PNG "alt=" Wkiol1aqrggjy3zuaadpghzf9yu460.png "/>

4.My.ini content is as follows:

[Client]

Default-character-set=utf8

[Mysqld]

port=3306

Basedir = "D:\Program Files (x86) \mysql-5.7.9-winx64/"

DataDir = "D:\Program Files (x86) \mysql-5.7.9-winx64/data/"

Tmpdir = "D:\Program Files (x86) \mysql-5.7.9-winx64/data/"

#socket = "D:\Program Files (x86) \mysql-5.7.9-winx64/data/mysql.sock"

Log-error= "D:\Program Files (x86) \mysql-5.7.9-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:\Program Files (x86) \mysql-5.7.9-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=true

Sql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution"

#sql_mode =no_engine_substitution,strict_trans_tables

################### #配置文件结束 ###################

5. Registering MySQL as a Windows system service

Open cmd to IT administrator to execute permissions

Go to the CD D:\Program Files (x86) \mysql-5.7.9-winx64\bin directory

Execution: mysqld install MySQL--defaults-file= "D:\Program Files (x86) \mysql-5.7.9-winx64\my.ini"

6. Initializing the date directory

Mysqld--initialize-insecure

7. Start the MySQL service:

Start MySQL command at the command line for: net start MySQL

--Close MySQL the command is: net stop MySQL

--Removal of MySQL service: mysqld remove

8. Change the root password to root

command line execution: Mysql–uroot

Mysql>show databases;

Mysql>use MySQL;

Mysql>set password for [email protected] = password (' root ');

mysql>exit;

9. log in with the new password OK

complete.

MySQL 5.7.9 install free version