Comments (11)
运行 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)
- 首先检查一下config.js配置文件里面的本地数据库密码是否正确?
- 然后检测一下是否被占用端口?
from nodejs-koa-blog.
进入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;
from nodejs-koa-blog.
$ 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
大佬会报这个错 , 启动不了应该和数据库没关系 啊
from nodejs-koa-blog.
$ 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日志,看看是什么问题,或许你现在拉取一下最新代码启动一下
from nodejs-koa-blog.
装了,没装Redis
from nodejs-koa-blog.
ok, 谢谢
from nodejs-koa-blog.
个人觉得 design这个做ui框架 form 不太好用,是个坑
from nodejs-koa-blog.
还是不行
from nodejs-koa-blog.
还是不行
是缺少nodemon依赖包,packjson里面没有写这条依赖
npm install nodemon --save-dev
在npm run dev就可以了
from nodejs-koa-blog.
进入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' 密码必须加上单引号么?
from nodejs-koa-blog.
进入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 亲测可用
from nodejs-koa-blog.
Related Issues (20)
- 管理端编辑评论、回复时,显示 404 HOT 1
- 当文章有分类时,直接删除分类后,会导致首页无法打开 HOT 1
- 技术大佬好,我按照你的流程,出现2个问题 HOT 4
- 大佬,全局对象global是怎么引入的?config/config.js文件 HOT 1
- 你好,注册账号成功,登录显示账号不存在! HOT 1
- 无效的token jwt格式错误 HOT 2
- 服务器异常 code 应该是 500 吧? HOT 1
- 伪静态 seo HOT 1
- 能不能注册普通用户? HOT 1
- 注册管理员404 HOT 1
- sequelize.authenticate() 导致app crashed - waiting for file changes before starting...是什么原因呢 HOT 1
- 你好请问我Navicat 都可以连接上数据库,为啥代码里面就显示连接失败呀 HOT 1
- 请问,新建数据库表的话,先在models下新建了文件,重启项目没有生成表 HOT 1
- 好哥哥~ look look me HOT 1
- 【感谢贴】基于 nodejs-koa-blog 二开了一次
- 评论列表只能获取到未更改状态的评论
- Unable to connect to the database: ConnectionError [SequelizeConnectionError]: connect ETIMEDOUT
- nuxt项目跑不起来
- No sql file was found
- 介意我用nest重写一下吗 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from nodejs-koa-blog.