Mysql 5.7.13 installation and configuration method graphic tutorial (win10 64-bit), 5.7.13win10

Source: Internet
Author: User
Tags change settings dedicated server

Mysql 5.7.13 installation and configuration method graphic tutorial (win10 64-bit), 5.7.13win10

This article provides a graphic tutorial on how to install and configure winx64 in mysql 5.7.13 for your reference. The details are as follows:

(1) download the MySQL program. You can download it from the MySQL official website or click here to download it.
(2) decompress the mysql-5.7.13-winx64.zip file to the directory you want to install. In my example
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 my. ini.
(4) Create a New mysqlData folder for the edisk.
(5) Clear the content in my. ini and copy the 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 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) as an administrator, go to cmd (below all) and run the cd command to go to the bin folder under the mysql directory.
(7) run the following command to install the mysql service:

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

Prompt after successful installation: Service successfully installed

(8) to generate the data directory and initialize the data, run the following command:

mysqld --initialize

After this command is executed, the files and folders required by MySQL are 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:

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

The temporary password is root @ localhost: followed by # 98um: =-RfbI.

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

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

mysql -uroot -p

(13) enter the initial password to connect to the mysql database and change the password as follows:

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

(14) Enter exit to exit MySQL.
(15) use a new password to enter mysql to execute the command in the same command program:

mysql -uroot -p123456

Enter MySQL and enter SQL:

select * from information_schema.TABLES t limit 3;

Check whether the installation is normal.

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

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.