Shulou(Shulou.com)06/01 Report--

First of all, we need to install vc++2013 first, or else we may not find the msvcr110.dll file.

Http://www.microsoft.com/zh-cn/download/details.aspx?id=40784

1. Download (operating system is Windows Server 2016 data Center Edition)

Https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-winx64.zip

two。 Installation configuration

After the decompression is completed, put it in C:\ Program Files\ mysql-5.7.19

Add environment variabl

PATH=C:\ Program Files\ mysql-5.7.19\ bin

Configure the MySQL configuration file C:\ Program Files\ mysql-5.7.19\ my.ini

[mysqld] basedir=C:\ Program Files\ mysql-5.7.19datadir=C:\ Program Files\ mysql-5.7.19\ data#bind-address = 127.0.0.1log-error=C:\ Program Files\ mysql-5.7.19\ data\ mysqld.logpid-file=C:\ Program Files\ mysql-5.7.19\ data\ mysqld.pidsymbolic-links=0skip-host-cacheskip-name-resolvecharacter-set-server=utf8back_log=50max_connections = 3000binlog_cache_size = 4Mtable_open_cache = 2500max_connect_errors = 30max _ allowed_packet = 32Mmax_heap_table_size = 128Msort_buffer_size = 16Mthread_cache_size = 16tmp_table_size = 128Mslow-query-log=1long_query_time = 6log_queries_not_using_indexes = 1slow-query-log-file=C:\ Program Files\ mysql-5.7.19\ data\ slow.loginnodb_buffer_pool_size = 1Ginnodb_flush_log_at_trx_commit = 1innodb_log_files_in_group = 2lower_case_table_names=1server-id=1log-bin=mysql-binsync_binlog = 1expire_logs_days = 15#replicate-ignore-db = mysql#replicate-do-db = shopbinlog_stmt_cache_size = 1048576#auto_increment_increment=2#auto_increment_offset=1#read_only = 1 [mysql] default-character-set = utf8

Initialize the database

Make sure the C:\ Program Files\ mysql-5.7.19\ data directory is available and empty

C:\ Program Files\ mysql-5.7.19\ bin\ mysqld-- initialize

If prompted that msvcp120.dll or msvcr120.dll is missing, install vc++ version 2013

Https://www.microsoft.com/zh-cn/download/details.aspx?id=40784

Registration service

C:\ Program Files\ mysql-5.7.19\ bin\ mysqld install

Modify the password

Mysqld-- defaults-file= "C:\ Program Files\ mysql-5.7.19\ my.ini"-- console-- skip-grant-tablesUPDATE user SET authentication_string=password ("123456"), host= ": 1" WHERE User= "root"

This password is not available yet. Close the window above to start the mysql database, and then start the service.

Net start mysql

Mysql-uroot-p123456

Set password=password ("db_password")

When the installation is complete, you will find that the version after 0000, date type and datetime type cannot be set to DEFAULT'0-00-00'.

At this time, you only need to modify the mysql_mode.

Inquire first

Select @ @ session.sql_mode

Delete NO_ZERO_IN_DATE and NO_ZERO_DATE later; otherwise,

Sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Add to the database configuration file and restart.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.