Installing mysql-5.7.5-m15-winx64

Win7 64-bit how to install the configuration mysql-5.7.5-m15-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/Downloads/MySQL-5.7/mysql-5.7.5-m15-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 in how to change settings. See # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # Do not EDIT the this FILE. It's a template which 'll be copied to the # Default location duringInstall, and would be replacedifYou #***upgrade to a newer version of MySQL. [Client] Default-character-set=UTF8 [mysqld] Port=3306Basedir="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= -Table_open_cache= thequery_cache_size=1M tmp_table_size=32M thread_cache_size=8Innodb_data_home_dir="d:\mysqldatabase\mysql-5.7.5-m15-winx64/data/"Innodb_flush_log_at_trx_commit=1innodb_log_buffer_size=128M innodb_buffer_pool_size=128M innodb_log_file_size=10M innodb_thread_concurrency= -InnoDB-autoextend-increment= +join_buffer_size=128M sort_buffer_size=32M read_rnd_buffer_size=32M Max_allowed_packet=32M Explicit_defaults_for_timestamp=trueSQL-mode="strict_trans_tables,no_auto_create_user,no_engine_substitution"#sql_mode=no_engine_substitution,strict_trans_tables################### #配置文件结束 ###################

View Code

The focus is on the following configuration, where the directory name for DataDir 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)

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):

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

Add Service command: mysqld install MySQL--defaults-file= "D:\mysql\mysql-5.7.5-m15-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

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:quit

Install mysql-5.7.5-m15-winx64