Mysql 5.7.5 m15 winx64 installation and configuration method graphic tutorial, m15winx64

Mysql 5.7.5 m15 winx64 installation and configuration method graphic tutorial, m15winx64

From the last installation of MySQL has been in the past for a long time, win7 64-bit under how to install the configuration of mysql-5.7.5-m15-winx64 ?. In fact, these steps may be missing. Record it. (Refer to some blogs on the Internet .)

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

2. decompress the package to D: \ MySqlDataBase

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

The content is as follows:

#################### Start of the configuration file ################# ### For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** do not edit this file. it's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade 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/Tables "# server_id = 2 # skip-locking max_connections = 100 table_open_cache = 256 query_cache_size = 1 M tmp_table_size = 32 M thread_cache_size = 8 bytes =" D: \ MySqlDataBase \ mysql-5.7.5-m15-winx64/data/"rows = 1 rows = 128 M rows = 128 M innodb_log_file_size = 10 M rows = 16 innodb-autoextend-increment = 1000 join_buffer_size = 128 M sort_buffer_size = 32 M read_rnd_buffer_size = 32 M max_allowed_packet = 32 M 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 #################### end of configuration file ################# ##

 

Key PointsIs the configuration in which the directory name of datadir must be: D: \ MySqlDataBase \ mysql-5.7.5-m15-winx64/data /.

4. Add the following content to the windows environment variable path:D: \ mysql \ mysql-5.7.5-m15-winx64 \ bin;(Note the extra points)

5. Register mysql as a windows system service
The specific operation is to execute the following command in the command line (you need to run the command line as an administrator ):
Switch to the bin directory. Otherwise, the service directory is specified as C: \ Program Files \ MySQL Server 5.7 \ mysqld.
Add service command: mysqld install MySQL -- defaults-file = "D: \ mysql \ mysql-5.7.5-m15-winx64 \ my. ini"
Command: mysqld remove

6. After step 1 is successful, Open System Service Management
You can see the mysql System Service
Start mysql in the command line: net start mysql
Run the following command to disable mysql: net stop mysql.

7. Change the root password to wenthink.
Command Line execution:

mysql –urootmysql>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 log on Remotely Anywhere and have any operation permissions on all databases. The specific operations are as follows:
1) log on to mysql using the root user on the local machine:
Command Line execution: mysql-u root-p
Enter the password (the password set in step 1): wenthink
2) perform authorization:
Copy codeThe Code is as follows: mysql> grant all privileges on *. * TO 'root' @ '%' identified by 'youpassword' with grant option;
Reload authorization table: mysql> flush privileges;
Exit mysql: quit

The above is the installation and configuration method of mysql 5.7.5 winx64. I hope it will be helpful for your learning.