MySQL 5.7.13 installation and configuration method graphic tutorial (win10 64 bit)

This article shares with you the graphic tutorial of MySQL 5.7.13 winx64 installation and configuration method 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 it. (2) Unzip the mysql-5.7.13-winx64.zip file to the directory you want to install it. In my case,
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 folder called mysqlData on drive E.
(5) Clear the contents of my.ini and copy the following content 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 installation, 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 an administrator and use the cd command to enter the bin folder under 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, prompt: Service successfully installed

(8) To generate the data directory and initialize the data, execute the following command:

mysqld --initialize

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

(9) The file structure in the E:\mysqlData folder is as follows:
Folders: mysql, performance_schema, sys
Files: 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 temporary password is root@localhost: followed by #98um:=-RfbI.

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

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

mysql -uroot -p

(13) After entering the initial password to connect to the MySQL database, 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;

You can verify whether it is installed normally.

(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 full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.