Mysql5.7 forget the root password and mysql5.7 modify the root password, mysql5.7root
Disable running MySQL:
[root@www.woai.it ~]# service mysql stop
Run
[root@www.woai.it ~]# mysqld_safe --skip-grant-tables &
To ensure security, you can disable remote connection as follows:
[root@www.woai.it ~]# mysqld_safe --skip-grant-tables --skip-networking &
Connect to the server using mysql:
[root@www.woai.it ~]# mysql -p
Change Password:
mysql> update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
* Note that the Password field is no longer in the user table of the new mysql database.
Instead, the encrypted user password is stored in the authentication_string field.
mysql> flush privileges;mysql> quit;
Modification completed. Restart
[root@localhost ~]# service mysql restart
Then mysql can be connected.
However, at this time, the operation seems to be not fully functional, but also alter user...
mysql> alter user 'root'@'localhost' identified by '123';
You can also:
mysql> set password for 'root'@'localhost'=password('123');
I would like to introduce how to change the mysql 5.7 root password.
MySQL administrator password setting or modification:
According to official instructions for Versions later than 5.6, a random password will be generated under the root directory at the first startup, with the file name. mysql_secret.
[root@bright ~]# cat /root/.mysql_secret# Password set for user 'root@localhost' at 2015-03-27 23:12:10:Jj+FTiqvyrF[root@bright ~]# cd /usr/local/mysql/bin/[root@bright bin]# ./mysqladmin -u root -h localhost password '123456' -p
Enter password: # Enter the second line in mysql_secret.
mysqladmin: [Warning] Using a password on the command line interface can be insecure.Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
In the official way, no matter whether or not I use -- skip-grant-tables to start mysql, the test fails. You can test it as follows:
Shell> mysql-uroot-p 'Password' # password is the password in. mysql_secret mysql> set password = PASSWORD ('newpasswd ');
If the old version does not have a password after installation, perform the following operations:
Method 1:
Shell> service mysqld stop # stop mysql service shell> mysqld_safe -- skip-grant-tables & # Start mysqlshell> mysql-uroot-p in the grant-tables mode not enabled # enter the command and press ENTER, enter the password and press Enter. Mysql> use mysql; mysql> update user set password = PASSWORD ("123456") where user = "root"; # Change password to newpassordmysql> flush privileges; # update permission mysql> quit # exit
Method 2:
Shell> service mysqld stop # stop mysql service shell> mysqld_safe -- skip-grant-tables & # Start mysqlshell> mysql-uroot-p in the grant-tables mode not enabled # enter the command and press ENTER, enter the password and press Enter. Mysql> set password for root @ localhost = password ('mysqlroot ');
Method 3:
shell>/path/mysqladmin -u UserName -h Host password 'new_password' -p
Articles you may be interested in:
- MySQL-four methods for modifying the root password (take windows as an example)
- Resetting mysql root Password (available for test)
- How to change the root password without restarting Mysql
- How to change the default mysql null password (root password) in xampp
- MySQL 5.7 enhanced version Semisync Replication Performance Optimization
- How to install the latest MySQL version 5.7.9in mac OS X10.10