MySQL 5.7.5 M15 winx64 Installation Configuration method graphics and text tutorial _mysql

It's been a long time since we last installed MySQL, Win7 64-bit how to install the configuration mysql-5.7.5-m15-winx64? In fact, the steps are these, there may be forgotten. Simply record it. (Refer to some blogs on the web.) ）

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

2. Extract 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 on ' How to ' change settings, please. # http://dev.mysql.co m/doc/refman/5.7/en/server-configuration-defaults.html # * * * does not EDIT this FILE. It's a template which'll be copied to the # * * * * * * * * * * * * * * * * * * * * location during install, and would be replaced if u

 Pgrade to a newer version of MySQL. [Client] Default-character-set=utf8 [mysqld] port=3306 basedir = "d:\mysqldatabase\mysql-5.7.5-m15-winx64/" da

 Tadir = "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_CAC he=256 query_cache_size=1m tmp_table_size=32m thread_cache_size=8 innodb_data_home_dir= "D:\MySqlDataBase\mys ql-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_concurrenc

 y=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 Windows System environment variable path, add the following content D:\mysql\mysql-5.7.5-m15-winx64\bin; (Note plus semicolon)

5, the MySQL registration for Windows system Services
The specific action is to 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"
Removal Service command:mysqld remove

6. After the 5th step is successful, open system service Management
Can see the MySQL system service
To start the MySQL command at the command line:net start MySQL
turn off MySQL command as:net stop MySQL

7. Change the password of root 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
allows the root user to log on remotely from anywhere, with any library operation rights, as follows:
1 login to MySQL with root user on this machine first:
Command-line execution:mysql-u root-p
Enter password (password set in step 7th):Wenthink
2) To authorize the operation:

Copy Code code as follows:

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

Overload Authorization Table: Mysql>flush privileges;
Exit MySQL: quit

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

This is the MySQL 5.7.5 winx64 installation configuration method, I hope to help you learn.