This article mainly introduces the method of changing the initial password of mysql 5.7.11 winx64 in detail. It has certain reference value. Interested friends can refer to it
Download MySQL-5.7 from the official website .11-winx64 compressed version. After installation, I found that there is a password. I tried to no avail. I fixed it by changing the password.
After successful installation:
Close the mysql service and follow the directory. Modify the file my.ini below, the content is as follows: Pay attention to two points: 1: Change the installation directory of myql in the content to the reader's installation directory; 2 The last line represents whether a password is required for login. Here we bypass the password login and enter mysql to change the password, so no Comment skip-grant-tables
####################配置文件开始################### # 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] port=3306 # D:\Program Files\mysql-5.7.11-winx64\mysql-5.7.11-winx64 basedir ="D:\Program Files\mysql-5.7.11-winx64\mysql-5.7.11-winx64/" datadir ="D:\Program Files\mysql-5.7.11-winx64\mysql-5.7.11-winx64/data/" tmpdir ="D:\Program Files\mysql-5.7.11-winx64\mysql-5.7.11-winx64/data/" socket ="D:\Program Files\mysql-5.7.11-winx64\mysql-5.7.11-winx64/data/mysql.sock" log-error="D:\Program Files\mysql-5.7.11-winx64\mysql-5.7.11-winx64/data/mysql_error.log" #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="D:\Program Files\mysql-5.7.11-winx64\mysql-5.7.11-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" skip-grant-tables ####################配置文件结束###################
After modifying and saving, in cmd, since we have configured the environment variable in path, we can start mysql directly
net start mysql
After successful startup, log in to mysql
mysql -u root -p
The password is empty. Here we press enter to log in successfully.
After the login is successful, we modify the database and execute as follows
use mysql
update user set authentication_string=password("123456") where user="root";
Note that a semicolon must be added at the end.
Refresh after success
flush privileges;
So our password has been changed successfully. Exit and close the mysql service, then comment out the last line in my.ini, restart the mysql service, and find that the new password takes effect.
The above is the detailed content of Mysql 5.7.11 How to change the winx64 initial password. For more information, please follow other related articles on the PHP Chinese website!