Windows noinstall mode installation mysql-5.7.5-m15-winx64

Download Unzip don't say

I unzipped 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 ZIP package already does not contain the data directory and needs to be initialized: Mysqld--initialize

Then register for service: 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 installation success

After the service is successfully registered, start the MySQL service, the MySQL service can start successfully, you can log in with the root user prompted to enter a password, the root password is not set at this time

Stop the service, add a Skip-grant-tables=1 configuration in My.ini, allow the password to be skipped, restart the MySQL service after the change, root user can log in normally

Change Password after login and modify it by 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 ';

Change password by update user set Authentication_string=password (' root ') where user = ' root ', Prompt for success

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

But when I use MySQL to switch data, I also prompt me to change the password?

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

This is finally good.

Then use the Heidisql management tool to connect normally:

When changing the password in the middle, use: 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 ';

However, the reboot also allows the password to be changed, using: Alter user ' root ' @ ' localhost ' identified by ' root ', which completes the root password modification.

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

Reference:

Http://www.cnblogs.com/Alex-Zeng/p/5508766.html

Http://www.cnblogs.com/wenthink/p/MySQLInstall.html

http://blog.csdn.net/a379039233/article/details/46819877

Windows noinstall mode installation mysql-5.7.5-m15-winx64