search

lfb / nodejs-koa-blog

基于 Node.js Koa2 实战开发的一套完整的博客项目网站
https://www.boblog.com
MIT License
1.78k stars 461 forks source link

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

Open niunaruto opened 4 years ago

niunaruto commented 4 years ago

运行 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)

lfb commented 4 years ago

运行 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. 然后检测一下是否被占用端口？
liuyong commented 4 years ago

进入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;

lixiaofa commented 4 years ago

$ cnpm run dev

nodejs-koa2-blog@1.0.0 dev E:\nodejs-koa-blog-master nodemon app.js

'nodemon' ▒▒▒▒▒ڲ▒▒▒▒ⲿ▒▒▒Ҳ▒▒▒ǿ▒▒▒▒еij▒▒▒ ▒▒▒▒▒▒▒▒▒ļ▒▒▒ npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! nodejs-koa2-blog@1.0.0 dev: nodemon app.js npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the nodejs-koa2-blog@1.0.0 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

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

lfb commented 4 years ago

$ cnpm run dev

nodejs-koa2-blog@1.0.0 dev E:\nodejs-koa-blog-master nodemon app.js

'nodemon' ▒▒▒▒▒ڲ▒▒▒▒ⲿ▒▒▒Ҳ▒▒▒ǿ▒▒▒▒еij▒▒▒ ▒▒▒▒▒▒▒▒▒ļ▒▒▒ npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! nodejs-koa2-blog@1.0.0 dev: nodemon app.js npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the nodejs-koa2-blog@1.0.0 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日志，看看是什么问题，或许你现在拉取一下最新代码启动一下

lixiaofa commented 4 years ago

装了，没装Redis

lixiaofa commented 4 years ago

ok， 谢谢

lixiaofa commented 4 years ago

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

lixiaofa commented 4 years ago

还是不行

yhzddy commented 4 years ago

还是不行

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

Richardsh commented 3 years ago

进入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' 密码必须加上单引号么？

vologo commented 2 years ago

进入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 亲测可用