Windows noinstall install MySQL 5.7.5 m15 winx64 (recommended) _mysql

Download decompression does not say

I unpacked in: E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64

Add configuration file E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64\my.ini

################### #配置文件开始 ################### [client] Default-character-set=utf8 [mysqld] port=3306 basedir = "E:\ dbfiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64 "DataDir =" e:\dbfiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/ data/"Tmpdir =" e:\dbfiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/data/"socket =" E:\DBFiles\mysql-5.7.15-winx64\ Mysql-5.7.15-winx64/data/mysql.sock "Log-error=" E:\dbfiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/data/mysql_ Error.log "#skip-grant-tables=1 #server_id = 2 #skip-locking max_connections=100 table_open_cache=256 query_cache_size =1m tmp_table_size=32m thread_cache_size=8 innodb_data_home_dir= "E:\DBFiles\mysql-5.7.15-winx64\ mysql-5.7.15-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=16 innodb-autoextend-increment=1000 join_buffer_size = 128M Sort_buffer_size = 32M Read_rnd_buffer_size = 32M Max_allowed_packet = 32M explicit_defaults_for_timestamp=tRue sql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution" #sql_mode =no_engine_substitution, Strict_trans_tables ################### #配置文件结束 ###################

The data directory is already not included in the ZIP package and needs to be initialized: Mysqld--initialize

Then perform the service registration: e:\dbfiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin>mysqld install mysql--defaults-file= "E:\ Dbfiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64\my.ini "

Prompt for successful installation

After the service successfully registered, start the MySQL service, MySQL service can be successfully started, you can log in with the root user prompts to request a password, at this time has not set the root password

Stop service, add a Skip-grant-tables=1 configuration in My.ini, allow skip password, reboot MySQL service after modification, root user can log in normally

Modify the password after login, using ALTER user root identitied by ' root '

Tip: The MySQL server is running with the--skip-grant-tables option so it cannot execute this statement

Then refer to the Web, using: Update user set Authentication_string=password (' root ') where user= ' root '; can be modified successfully

Modify the password by update user set Authentication_string=password (' root ') where user = ' root ' to prompt for success

After modifying the password, remove the configured Skip-grant-tables=1, and log in with root and the password you just set up, no problem,

But when I use MySQL to switch data, and then prompted me to change the password?

Then I have execution: Alter user ' root ' @ ' localhost ' identified by ' root ';

It's finally done.

Then use the Heidisql management tool to connect properly:

In the middle of the password change, the use is: Alter user ' root ' @ ' localhost ' identified by ' root ';

Tip: The MySQL server is running with the--skip-grant-tables option so it cannot execute this statement

Then refer to the Web, using: Update user set Authentication_string=password (' root ') where user= ' root '; can be modified successfully

But in the reboot, the password is changed, using the ALTER user ' root ' @ ' localhost ' identified by ' root ', and this completes the change of the root password.

Before the next step is the next way to install, this time by uninstall the way to install MySQL, from the repeated test, the middle encountered a lot of problems, toss can be three times before success.

The above is a small series to introduce the Windows Noinstall way to install MySQL 5.7.5 M15 winx64 All the narration, I hope to help you, if you have any questions welcome to my message, small series will promptly reply to everyone, Here also thank you very much for the cloud Habitat Community website support!