Tutorial on how to modify the root password in MySQL 5.7

Version update, the password field in the original user has been changed to authentication_string

Due to version updates, many online tutorials are no longer applicable, and even the official website's documents cannot be operated smoothly.

If MySQL is running, kill it first:

killall -TERM mysqld.

run

mysqld_safe --skip-grant-tables &

If you do not want to be connected remotely at this time: mysqld_safe –skip-grant-tables –skip-networking &

Use mysql to connect to server

change password:

update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';

*One thing to note is that there is no Password field in the user table under the new version of MySQL database.

Instead, the encrypted user password is stored in the authentication_string field

mysql> flush privileges;
mysql> quit;

The modification is completed. Restart

killall -TERM mysqld.
mysqld_safe &

Then mysql can connect

But the operation seems to be incomplete at this time, and you need to alter user...

alter user 'root'@'localhost' identified by '123';

The online article says that this is also possible:

set password for 'root'@'localhost'=password('123');
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig --add mysql

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links