Mysql 5.7.11 How to change the winx64 initial password

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!