Considerations for mysql 5.7.14 installation-Free Edition (excellent) and mysql5.7.14

Considerations for mysql 5.7.14 installation-Free Edition (excellent) and mysql5.7.14

Related reading:

MySql 5.7.14 installation tutorial (decompress Version)

Mysql 5.7.14 FAQs (recommended)

1. Extract

2. Copy the mysql-5.7.14-winx64 under Directory D: \ Program Files \ my-default.ini, put it in the same directory, the name is displayed as my. ini;

3. edit my. ini

# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.7/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.[client]default-character-set=utf8[mysqld]# 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 = 128M# 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 Files\mysql-5.7.14-winx64datadir = D:\Program Files\mysql-5.7.14-winx64\datatmpdir = D:\Program Files\mysql-5.7.14-winx64\datasocket = D:\Program Files\mysql-5.7.14-winx64\data\mysql.sockport = 3306# server_id = .....max_connections = 100table_open_cache = 256query_cache_size = 1Mtmp_table_size = 32Mthread_cache_size = 8innodb_data_home_dir = D:\Program Files\mysql-5.7.14-winx64\datainnodb_flush_log_at_trx_commit = 1innodb_log_buffer_size = 128Minnodb_buffer_pool_size = 128Minnodb_log_file_size = 10Minnodb_thread_concurrency = 16innodb-autoextend-increment = 1000# 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 join_buffer_size = 128Msort_buffer_size = 32Mread_rnd_buffer_size = 32Mmax_allowed_packet = 32Mexplicit_defaults_for_timestamp = truesql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

4. Create a data file under the decompressed Directory D: \ Program Files \ mysql-5.7.14-winx64 (no other operations in the folder)

5. Enter the cmd interface as an administrator (must be an administrator)

6. Switch to the mysql decompress directory \ bin to initialize the data directory.

Enter the command: mysqld -- initialize-insecure (generate a root user without a password)

Or: mysqld -- initialize (generate a root user with a random password)

7. Start the mysql service after initialization.

Enter the command: net start mysql

8. Start using mysql

Run mysql-u root-p.

9. Stop the mysql service.

Enter the command: net stop mysql

10. How do I log on after I forget the root password?

101 disable the running MySQL service.

10.2 open the DOS window and go to the mysql \ bin directory.

10.3 enter mysqld -- skip-grant-tables and press Enter. -- Skip-grant-tables indicates that the permission table authentication is skipped when the MySQL service is started.

10.4 open another DOS window (because the DOS window can no longer be moved) and go to the mysql \ bin directory.

10.5 enter mysql and press Enter. If yes, a MySQL prompt is displayed.>.

10.6 connect to the permission Database: use mysql ;.

10.7 Change password: update user set password = password ("123") where user = "root"; (do not forget the last plus points ).

10.8. Refresh permission (required): flush privileges ;.

10.9. quit.

10.10 log out of the system and log on again. Log On with the username root and the new password 123 you just set.

11. Modify the root user password

Versions earlier than 5.7:

update user set authentication_string =password( 'root') where user = 'root;

Versions later than version 5.7:

update user set password=password( 'root') where user = 'root;

The above is a small Editor to introduce you to mysql 5.7.14 free installation notes (excellent), I hope to help you, if you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!