Mysql 5.7.11 How to change the winx64 initial password-Mysql Tutorial-php.cn

Mysql 5.7.11 How to change the winx64 initial password

零下一度

Release： 2017-05-02 09:37:39

Original

1366 people have browsed it

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&#39;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 
 
 
####################配置文件结束###################

Copy after login

After modifying and saving, in cmd, since we have configured the environment variable in path, we can start mysql directly

net start mysql

Copy after login

After successful startup, log in to mysql

mysql -u root -p

Copy after login

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

Copy after login

update user set authentication_string=password("123456") where user="root";

Copy after login

Note that a semicolon must be added at the end.

Refresh after success

flush privileges;

Copy after login

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!