nodejs-koa-blog icon indicating copy to clipboard operation
nodejs-koa-blog copied to clipboard

Published 20 hours ago • verified publisher icon lfb

运行 npm run dev 报错，本地建立的有boblog数据库

Open niunaruto opened this issue 5 years ago • 11 comments

运行 npm run dev 报错，本地建立的有boblog数据库

SEQUELIZE0002] DeprecationWarning: The logging-option should be either a function or false. Default: console.log Unhandled rejection SequelizeConnectionError: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /Users/edz/nodejs-koa-blog/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:133:19 at tryCatcher (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:439:21)

niunaruto avatar Dec 05 '19 06:12 niunaruto

运行 npm run dev 报错，本地建立的有boblog数据库

SEQUELIZE0002] DeprecationWarning: The logging-option should be either a function or false. Default: console.log Unhandled rejection SequelizeConnectionError: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /Users/edz/nodejs-koa-blog/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:133:19 at tryCatcher (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/Users/edz/nodejs-koa-blog/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:439:21)

  1. 首先检查一下config.js配置文件里面的本地数据库密码是否正确？
  2. 然后检测一下是否被占用端口？

lfb avatar Dec 05 '19 06:12 lfb

进入mysql，跑一下语句，我的mysql8.0亲测成功： mysql> use mysql; mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; 其中，YourRootPassword是你的mysql密码。

旧版本mysql 是跑 ： ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; FLUSH PRIVILEGES;

liuyong avatar Dec 08 '19 07:12 liuyong

$ cnpm run dev

[email protected] dev E:\nodejs-koa-blog-master nodemon app.js

'nodemon' ▒▒▒▒▒ڲ▒▒▒▒ⲿ▒▒▒Ҳ▒▒▒ǿ▒▒▒▒еij▒▒▒ ▒▒▒▒▒▒▒▒▒ļ▒▒▒ npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] dev: nodemon app.js npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] dev script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in: npm ERR! C:\Users\jion\AppData\Roaming\npm-cache_logs\2019-12-13T09_52_25_989Z-debug.log

大佬会报这个错 ， 启动不了应该和数据库没关系 啊

lixiaofa avatar Dec 13 '19 09:12 lixiaofa

$ cnpm run dev

[email protected] dev E:\nodejs-koa-blog-master nodemon app.js

'nodemon' ▒▒▒▒▒ڲ▒▒▒▒ⲿ▒▒▒Ҳ▒▒▒ǿ▒▒▒▒еij▒▒▒ ▒▒▒▒▒▒▒▒▒ļ▒▒▒ npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] dev: nodemon app.js npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] dev script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in: npm ERR! C:\Users\jion\AppData\Roaming\npm-cache_logs\2019-12-13T09_52_25_989Z-debug.log

大佬会报这个错 ， 启动不了应该和数据库没关系 啊

貌似不是，你 npm install 安装依赖包了么？然后看下debug log日志，看看是什么问题，或许你现在拉取一下最新代码启动一下

lfb avatar Dec 16 '19 03:12 lfb

装了，没装Redis

lixiaofa avatar Dec 18 '19 02:12 lixiaofa

ok， 谢谢

lixiaofa avatar Dec 18 '19 02:12 lixiaofa

个人觉得 design这个做ui框架 form 不太好用，是个坑

lixiaofa avatar Dec 18 '19 02:12 lixiaofa

还是不行

lixiaofa avatar Dec 18 '19 03:12 lixiaofa

还是不行

是缺少nodemon依赖包，packjson里面没有写这条依赖 npm install nodemon --save-dev 在npm run dev就可以了

yhzddy avatar Jan 09 '20 04:01 yhzddy

进入mysql，跑一下语句，我的mysql8.0亲测成功： mysql> use mysql; mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; 其中，YourRootPassword是你的mysql密码。

旧版本mysql 是跑 ： ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; FLUSH PRIVILEGES;

我的还是不行，同样的报错，这里是 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '11111' 密码必须加上单引号么？

Richardsh avatar Mar 10 '21 07:03 Richardsh

进入mysql，跑一下语句，我的mysql8.0亲测成功： mysql> use mysql; mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; 其中，YourRootPassword是你的mysql密码。

旧版本mysql 是跑 ： ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; FLUSH PRIVILEGES;

mysql8 亲测可用

vologo avatar Oct 25 '21 06:10 vologo