小程序node腾讯云MySQL数据库报错：Error: ER_NOT_SUPPORTED_AUTH_MODE

Unhandled rejection Error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at DB.raw.then.err (C:\Users\18310\Desktop\mpvue\my-project\server\tools\initdb.js:41:11)
    at tryCatcher (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\util.js:16:23)
    at Promise._settlePromiseFromHandler (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\promise.js:517:31)
    at Promise._settlePromise (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\promise.js:574:18)
    at Promise._settlePromise0 (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\promise.js:619:10)
    at Promise._settlePromises (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\promise.js:695:18)
    at _drainQueueStep (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\async.js:138:12)
    at _drainQueue (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\async.js:131:9)
    at Async._drainQueues (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\async.js:147:5)
    at Immediate.Async.drainQueues (C:\Users\18310\Desktop\mpvue\my-project\server\node_modules\bluebird\js\release\async.js:17:14)
    at runCallback (timers.js:810:20)
    at tryOnImmediate (timers.js:768:5)
    at processImmediate [as _immediateCallback] (timers.js:745:5)

参考谷歌方案：https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

1. 在cmd连接数据库后执行命令：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'，这里的password代表你的数据库的密码。
2. 关闭数据库重新连接。
3. 然后再执行初始化数据库的命令。