Mysql 5.7.17 winx64 installation and configuration method graphic tutorial, 5.7.17winx64

Mysql 5.7.17 winx64 installation and configuration method graphic tutorial, 5.7.17winx64

Install mysql-5.7.17-winx64.zip in Windows

1. Download A. ZIP file from the official website.

2. decompress the package to a folder, which is represented by D: \ MySql.

3. Create my. ini configuration file under D: \ MySql \ mysql-5.7.17-winx64

Replace the yellow background color with your own content. Remember !!!

#################### Start of the configuration file ################# ##
[Client]

Default-character-set = utf8

[Mysqld]

Port = 3306

Basedir = "D: \ MySql \ mysql-5.7.17-winx64 /"

Datadir = "D: \ MySql \ mysql-5.7.17-winx64/data /"

Tmpdir = "D: \ MySql \ mysql-5.7.17-winx64/data /"

Socket = "D: \ mysql\ mysql-5.7.17-winx64/data/MySql. sock"

Log-error = "D: \ MySql \ mysql-5.7.17-winx64/data/mysql_error.log"

# 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

Innodb_data_home_dir = "D: \ MySql \ mysql-5.7.5-m15-winx64/data /"

Innodb_flush_log_at_trx_commit = 1

Innodb_log_buffer_size = 128 M

Innodb_buffer_pool_size = 128 M

Innodb_log_file_size = 10 M

Innodb_thread_concurrency = 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 ################## #

4. Add it to the PATH environment variable in Windows. Replace it with yellow !!!

D: \ MySql \ mysql-5.7.17-winx64 \ bin;(Note the extra points)

5. Open the Administrator's cmd and enter/bin in the directory where the files are stored. replace them with yellow !!!

mysqld install MySQL --defaults-file="D:\MySql\mysql-5.7.17-winx64\my.ini" 

6. Input in cmd

net start mysql

The MySQL service cannot be started and the service does not report any errors.

7. Solution

mysqld --romvemysqld --installmysqld --initializenet start mysql

8. Now mysql can be used normally. The cmd command for starting/stopping mysql is as follows:

net start mysqlnet stop mysql

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.