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

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 of these, might be forgotten. Simply record it. (Refer to some blogs on the web.) ）

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

Official website Download Address: http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-5.7.5-m15-winx64.zip

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.com/ 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'll be replaced
 Rade to a newer version of MySQL. [Client] Default-character-set=utf8 [mysqld] port=3306 basedir = "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=100 table_open_cache=256 query_cache_size=1m Tmp_ta ble_size=32m thread_cache_size=8 innodb_data_home_dir= "d:\mysqldatabase\mysql-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_concurrency=16 innodb-autoextend-increment= 1000 join_buffer_size = 128M Sort_buffer_size = 32M Read_rnd_buffer_size = 32M Max_allowed_packet = 32M Explicit_defa Ults_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

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.