MySQL 5.7.17 winx64 installation and configuration method graphic tutorial

Windows installation mysql-5.7.17-winx64.zip method record <

1. Go to the official website and download the .zip file.

2. Unzip to a folder, here I use D:\MySql

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

The yellow background color needs to be replaced with your own content, remember!!!

#####################Configuration file begins###################
 [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=1M
 tmp_table_size=32M
 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=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_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 Windows PATH environment variable, and pay attention to the replacement in yellow!!!

D:\MySql\mysql-5.7.17-winx64\bin; (note the semicolon)

5. Open the administrator's cmd, enter the /bin directory where the files are stored, and pay attention to the replacement in yellow!!!

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

6. Enter in cmd

net start mysql

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

7. Solution

mysqld --romve
mysqld --install
mysqld --initialize
net start mysql

8. Now you can use mysql normally. The cmd command to start/stop mysql is as follows

net start mysql
net stop mysql

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:

MySQL 5.7.17 installation and configuration method graphic tutorial
mysql5.7.17.msi installation graphic tutorial
Tutorial on installing mysql5.7.17 on windows10
MySQL 5.7.17 installation and configuration graphic tutorial
MySQL 5.7.17 installation and configuration method graphic tutorial (windows)
MySQL 5.7.17 installation and configuration method graphic tutorial (CentOS7)
MySQL 5.7.17 installation and configuration tutorial for Mac
MySQL 5.7.17 winx64 installation and configuration graphic tutorial
MySQL 5.7.17 installation and configuration method graphic tutorial under win7
MySQL 5.7.17 installation and configuration method graphic tutorial under Windows 10
Mysql5.7.17 winx64.zip decompression version installation and configuration graphic tutorial
MySQL 5.7.17 winx64 decompression version installation and configuration method graphic tutorial

<<: Example code for implementing concurrent request control in JavaScript/TypeScript

>>: Summary of basic usage of js array