Sharing the installation and configuration method of mysql5.7.13 under win10 64-bit system

This article mainly shares with you the graphic tutorial on the installation and configuration method of mysql 5.7.13 under win10 64-bit. Interested friends can refer to it.

The example of this article shares with you mysql 5.7.13 winx64 The installation and configuration method graphic tutorial is for your reference. The specific content is as follows

(1) Download the MySQL program. You can download it from the MySQL official website, or click here to download
(2) Unzip mysql-5.7. 13-winx64.zip file to the directory you want to install, my example is
D:\program\mysql-5.7.13-winx64. The directory structure is as follows:
Folder: bin docs include lib share
File: COPYING README my-default.ini
(3) Copy the file my-default.ini to the same directory and rename it to my .ini.
(4) Create a new mysqlData folder on the E drive.
(5) Clear the content in my.ini and copy it again.

[client] 
no-beep 
# pipe 
# socket=mysql 
port=3306 
[mysql] 

default-character-set=utf8 

# For advice on how to change settings please see 
# http://dev.mysql.com/doc/refman/5.6/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. 
[mysqld] 
explicit_defaults_for_timestamp = TRUE 

# Remove leading # and set to the amount of RAM for the most important data 
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 
innodb_buffer_pool_size = 2G 

# Remove leading # to turn on a very important data integrity option: logging 
# changes to the binary log between backups. 
# log_bin 

# These are commonly set, remove the # and set as required. 

basedir="D:\program\mysql-5.7.13-winx64\" 
datadir="E:\mysqlData\" 

port=3306 
server_id=1 

general-log=0 
general_log_file="mysql_general.log" 
slow-query-log=1 
slow_query_log_file="mysql_slow_query.log" 
long_query_time=10 
log-error="mysql_error_log.err" 
default-storage-engine=INNODB 
max_connections=1024 
query_cache_size=128M 
key_buffer_size=128M 
innodb_flush_log_at_trx_commit=1 
innodb_thread_concurrency=128 
innodb_autoextend_increment=128M 
tmp_table_size=128M 

# Remove leading # to set options mainly useful for reporting servers. 
# The server defaults are faster for transactions and fast SELECTs. 
# Adjust sizes as needed, experiment to find the optimal values. 
# join_buffer_size = 128M 
# sort_buffer_size = 2M 
# read_rnd_buffer_size = 2M 

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" 
character-set-server=utf8 
innodb_flush_method=normal

(6) Enter cmd as administrator (all of the following) and use the cd command to enter the bin folder in the mysql directory.
(7) Execute the command to install the mysql service:

mysqld --install MySQL --defaults-file=D:\program\mysql-5.7.13-winx64\my.ini

After successful installation, the prompt: Service successfully installed

(8) In order to generate the data directory and initialization data, execute the following command:

mysqld --initialize

After this command is executed, the files and folders used by MySQL will be generated in the E:\mysqlData folder created above.

(9) The file structure in the E:\mysqlData folder is as follows:
Folder: mysql, performance_schema, sys
File: auto.cnf DESKTOP-SDK08IO.pid ib_buffer_pool ib_logfile0 ib_logfile1 ibdata1 ibtmp1 mysql_error_log.err mysql_slow_query.log

(10) Find the following line in the mysql_error_log file in the E:\mysqlData folder:

The code is as follows:

2016-08-02T23:09:18.827488Z 1 [Note] A temporary password is generated for root@localhost: #98um:=-RfbI

Temporary password It is #98um:=-RfbI after root@localhost:.

(11) Start the service net start mysql in the same command line program.

(12) Open a new command post program, enter the D:\program\mysql-5.7.13-winx64\bin folder, and execute the command:

mysql -uroot -p

(13) Enter the initial After entering the mysql database with the password, change the password as follows:

set password=password('123456');
flush privileges;

(14) Enter exit to exit MySQL.
(15) After the same command, use the new password to enter mysql and execute the command:

mysql -uroot -p123456

After entering MySQL, enter SQL:

select * from information_schema.TABLES t limit 3;

to verify whether the installation is normal.

(16) Go to the MySQL official website to download and install Workbench, so that you can use the MySQL graphical interface.

The above is the detailed content of Sharing the installation and configuration method of mysql5.7.13 under win10 64-bit system. For more information, please follow other related articles on the PHP Chinese website!