Win7 64-bit how to install the configuration mysql-5.7.4-m14-winx64 (installation record)

1. Mysql-5.7.4-m14-winx64.zip Download

Official website: http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17-winx64.zip

2. Unzip to D:\mysql. (Specify the path yourself) 3, create a new My.ini profile under D:\mysql\mysql-5.7.4-m14-winx64

The contents are as follows:

################### #配置文件开始 ###################

# for advice The change settings

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

# * * * Don't EDIT 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]

Default-character-set=utf8

[Mysqld]

port=3306

Basedir = "d:/mysql/mysql-5.7.4-m14-winx64/"

DataDir = "d:/mysql/mysql-5.7.4-m14-winx64/data/"

Tmpdir = "d:/mysql/mysql-5.7.4-m14-winx64/data/"

Socket = "D:/mysql/mysql-5.7.4-m14-winx64/data/mysql.sock"

Log-error= "D:/mysql/mysql-5.7.4-m14-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:/mysql/mysql-5.7.4-m14-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

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

The focus is on the following configuration, where the directory name for DataDir must be: d:/mysql/mysql-5.7.4-m14-winx64/data/.

4, in the Windows System environment variable path, add the following content

D:\mysql\mysql-5.7.4-m14-winx64\bin; (note plus semicolon)

5. Registering MySQL as a Windows system service

To do this, execute the following command on the command line (you need to run the command line as an administrator):

Add Service command: mysqld install MySQL--defaults-file= "D:\mysql\mysql-5.7.4-m14-winx64\my.ini"

The Removal Service command is: mysqld remove

6. After the 5th step succeeds, open the system service management

You can see the MySQL system service (note here):

Need to configure the login property of the MySQL service administrator user login (not configured to start the report 1035 error from service management, the command line to start the report failed)

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

Shutdown mysql command for: net stop MySQL

7. Change the root password to 123456

Command line execution: Mysql–uroot

Mysql>show databases;

Mysql>use MySQL;
mysql> UPDATE user SET Password=password (' 123456 ') WHERE user= ' root ';

mysql> FLUSH privileges;

Mysql> QUIT

8, at this time can be on the local client connection (I use SQLyog), there is a system library called: MySQL 9, remote login configuration

Allow the root user to remotely log in anywhere and have any permissions to operate on any library, as follows:

1) Log in to MySQL first using the root user:

Command line execution: Mysql-u root-p

Enter password (password set in step 7th): 123456

2) Authorize the operation:

Mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION;

Overload Authorization Table:

Mysql>flush privileges;

Exit Mysql:quit

Win7 64-bit how to install the configuration mysql-5.7.4-m14-winx64 (installation record)