系統(tǒng)版本：
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.28-log

創(chuàng)新互聯(lián)建站主營(yíng)冷水江網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,成都APP應(yīng)用開(kāi)發(fā),冷水江h(huán)5重慶小程序開(kāi)發(fā)搭建,冷水江網(wǎng)站營(yíng)銷(xiāo)推廣歡迎冷水江等地區(qū)企業(yè)咨詢(xún)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

忘記密碼，編輯my.cnf服務(wù)配置文件
 [mysqld]段段中加入 skip-grant-tables語(yǔ)句，去掉認(rèn)證
update user set password=password("root")where user='root';
修改密碼之后，無(wú)法立刻操作mysql，退出之后，重新連接mysql
執(zhí)行語(yǔ)句報(bào)錯(cuò)：
You must reset your password using ALTER USER statement before executing this statement
解決方案
set password = password("root");
該問(wèn)題是由于密碼授權(quán)過(guò)期導(dǎo)致