MySQL 5.7 root user password modification, MySQL 5.7 under docker

goodlook0123 2022-02-13 08:17:13 阅读数:299

mysql root user password modification

stay MySQL 5.7 password The field is already from mysql.user In the table to delete , The new field name is “authenticalion_string”.

Select database :use mysql;

to update root Password :update user set authentication_string=password(' New password ') where user='root' and Host='localhost';

Refresh the permissions :flush privileges;
Reprinted address :https://blog.csdn.net/qq_39940205/article/details/81167131

copyright:author[goodlook0123],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130817124682.html