Shulou(Shulou.com)05/31 Report--

How to change the root password in Mysql5.7? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

If MySQL is running, first:

Killall-TERM mysqld.

Running

Mysqld_safe-- skip-grant-tables &

If you don't want to be connected remotely at this time: mysqld_safe-skip-grant-tables-skip-networking &

Connect to server using mysql

Change the password:

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

* A special reminder 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 complete. Restart

Killall-TERM mysqld. Mysqld_safe &

Then mysql can connect.

But at this time the operation seems to be not fully functional, but also alter user …

Alter user 'root'@'localhost' identified by' 123'

The online article says that purple is also fine:

Set password for 'root'@'localhost'=password (' 123'); cp mysql.server / etc/init.d/mysqlchmod + x / etc/init.d/mysqlchkconfig-- this is the answer to add mysql's question about how to change the root password in Mysql5.7. I hope the above content can be of some help to everyone. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.