MySQL 5.7.14 installation-free version note (fine) _mysql

Related reading:

MYSQL 5.7.14 Installation Tutorial detailed (decompression version)

Mysql 5.7.14 Use FAQ summary (recommended)

1, decompression

2, in the directory D:\Program files\mysql-5.7.14-winx64 copy My-default.ini, placed in its same directory, the name displayed as My.ini;

3. Edit My.ini

# for advice on the "How to" change settings, please the # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults. HTML # * * * does not EDIT this FILE. It's a template which'll be copied to the # * * * * * * * * * * * * * * * * * * location during install, and'll be replaced
De 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% all RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove Leading # to turn on a very important data integrity Option:logging # changes T
o 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-winx64 datadir = D:\Program files\mysql-5.7.14-winx64\data tmpdir = D:\Program Fi Les\mysql-5.7.14-winx64\data socket = D:\Program Files\mysql-5.7.14-winx64\data\mysql.sock port = 3306 # server_id = ....
. Max_connections = tAble_open_cache = 256 Query_cache_size = 1M Tmp_table_size = 32M Thread_cache_size = 8 Innodb_data_home_dir = D:\Program F Iles\mysql-5.7.14-winx64\data Innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 128M Innodb_buffer_pool_ Size = 128M Innodb_log_file_size = 10M innodb_thread_concurrency = innodb-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 = 128M Sort_buffer_size = 32M read_rnd_buffer_size = 32M Max_allowed_packet = 32M Explicit_defaults_for_timestamp = True Sql_mode=no_engine_ Substitution,strict_trans_tables

4, in the Extract directory D:\Program files\mysql-5.7.14-winx64 under the new data file (do not do other operations in the folder)

5, as an administrator into the CMD interface (must be admin)

6, switch to MySQL extract directory \ Bin, initialize the data directory

Input command: Mysqld--initialize-insecure (generate root user without password)

Or: Mysqld--initialize (Generate root with random password)

7. Start MySQL service after initialization is completed

Input command: net start MySQL

8. Start using MySQL

Input command: Mysql-u root-p

9. Stop MySQL Service

Input command: net stop MySQL

10. How to log in after forgetting the root password

101, shut down the running MySQL service.

10.2, open the DOS window, go to the Mysql\bin directory.

10.3, input mysqld--skip-grant-tables carriage return. --skip-grant-tables means to skip permission table authentication when starting the MySQL service.

10.4. Open a DOS window again (because the DOS window is already unable to move), go to the Mysql\bin directory.

10.5, enter the MySQL return, if successful, will appear MySQL prompt >.

10.6, Connection rights database: use MySQL;

10.7, Change Password: Update user set Password=password ("123") where user= "root"; (don't forget the last semicolon).

10.8, refresh the right (must step): Flush privileges;

10.9, exit quit.

10.10, logout system, and then enter, using user name root and just set the new password 123 login.

11, modify the root user password

Before the 5.7 version:

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

5.7 Version after:

Update user set Password=password (' root ') where user = ' root;

The above is a small set to introduce the MySQL 5.7.14 installation version of the notice (fine), I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!