Win7 64-bit how to install the configuration mysql-5.7.7-rc-winx64

It's been a long time since MySQL was last installed. Steps these, there may be forgotten. Simply record it. (Refer to blogs on some networks.) ）

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

Official website:

Http://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.7-rc-winx64.zip

2. unzip to D:\MySqlDataBase

3. Create a new my.ini configuration file under D:\MySqlDataBase\mysql-5.7.5-m15-winx64

The contents are as follows:

# for advice The change settings

# http://dev.mysql.com/doc/refman/5.7/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.

# [MYSQLD]

# Remove Leading # and set to the amount of RAM for the most important data

# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove Leading # to turn on a very 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 = ...

# Remove Leading # To set options mainly useful for reporting servers.

# The server defaults is faster for transactions and fast selects.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

# Sql_mode=no_engine_substitution,strict_trans_tables

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

[Client]

port=3307

Default-character-set=utf8

[Mysqld]

port=3307

Character_set_server=utf8

Basedir = "e:\database\mysql\mysql-5.7.7-rc-winx64/"

DataDir = "e:\database\mysql\mysql-5.7.7-rc-winx64/data/"

Tmpdir = "e:\database\mysql\mysql-5.7.7-rc-winx64/data/"

Socket = "E:\database\mysql\mysql-5.7.7-rc-winx64/data/mysql.sock"

Log-error= "E:\database\mysql\mysql-5.7.7-rc-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= "e:\database\mysql\mysql-5.7.7-rc-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 DataDir directory name must be:

D:\MySqlDataBase\ mysql-5.7.5-m15-winx64/data/.

4. in the Windows system environment variable path, add the following:

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

Variable name: mysql_home

Variable Value: D:\Program files\mysql-5.7.5-m15-winx64

This is the custom unzip directory for MySQL.

Add%mysql_home%\bin in Path again

5 , the MySQL registered as Windows System Services

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

need to switch to bin directory, otherwise the service directory will be specified as C:\Program files\mysql\mysql Server 5.7\mysqld

The Add Service command is:

Mysqld Install MySQL--defaults-file= "D:\mysql\mysql-5.7.5-m15-winx64\my.ini"

The Removal Service command is:

Mysqld Remove

Mysqld Install MySQL5.7.7--defaults-file= "E:\Database\MySQL\mysql-5.7.7-rc-winx64\my.ini"

Mysqld Remove MySQL5.7.7

net start MySQL5.7.7

net stop MySQL5.7.7

6. after step 5 succeeds, open System services management

You can see the MySQL system service

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

Shutdown mysql command for: net stop MySQL

7. Change the root password to wenthink

Command line execution: Mysql–uroot

Mysql>show databases;

Mysql>use MySQL;
Mysql>update user SET Password=password (' Wenthink ') WHERE user= ' root ';

Mysql>flush privileges;

Mysql>quit

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 (the password set in step 7th): Wenthink

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:

Mysql>quit

Win7 64-bit how to install the configuration mysql-5.7.7-rc-winx64