egg 使用本地mysql 报错

2022-05-20 09:53:10,500 ERROR 4520 nodejs.AppWorkerDiedError: [master] app_worker#7:7424 died (code: 1, signal: null, suicide: false, state: dead), current workers: []
    at Master.onAppExit (E:\egg\node_modules\_egg-cluster@1.27.1@egg-cluster\lib\master.js:511:21)
    at Master.emit (node:events:394:28)
    at Messenger.sendToMaster (E:\egg\node_modules\_egg-cluster@1.27.1@egg-cluster\lib\utils\messenger.js:137:17)
    at Messenger.send (E:\egg\node_modules\_egg-cluster@1.27.1@egg-cluster\lib\utils\messenger.js:102:12)
    at EventEmitter.<anonymous> (E:\egg\node_modules\_egg-cluster@1.27.1@egg-cluster\lib\master.js:354:22)
    at EventEmitter.emit (node:events:406:35)
    at ChildProcess.<anonymous> (node:internal/cluster/primary:203:13)
    at Object.onceWrapper (node:events:514:26)
    at ChildProcess.emit (node:events:394:28)
    at Process.ChildProcess._handle.onexit (node:internal/child_process:290:12)
name: "AppWorkerDiedError"
pid: 4520
hostname: WIN-76M5HR3IRRL

报错可能：1、密码错误  2、mysql 下载时配置错误 （可重新下载更改模式）

原因2时，可执行以下代码更改

1、进入mysql的bin文件夹

C:\Users\Administrator>cd C:\Program Files\MySQL\MySQL Server 8.0\bin （路径改为自己的）

2、打开mysql

mysql -u root -p  回车输入密码

进入成功时出现 mysql> 

3、更改进入模式和密码

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root123456';

BY后面引号区域区域内的为自定义的新密码

执行成功时出现 Query OK, 0 rows affected (0.00 sec)

执行不成功时先执行

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123456' PASSWORD EXPIRE NEVER;

BY后面引号区域区域内的为自定义的新密码

执行成功时出现 Query OK, 0 rows affected (0.01 sec)

然后再次执行

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root123456';

执行成功时出现 Query OK, 0 rows affected (0.00 sec)

4、刷新配置

FLUSH PRIVILEGES;

执行成功时出现 Query OK, 0 rows affected (0.01 sec)

5、离开mysql

exit

执行成功时出现 Bye

6、在程序中更改为新密码再次登录即可