node 链接mysql报错

来源:6-4 nodejs操作 mysql

JT_Jeffrey

2019-06-25

http://img.mukewang.com/szimg/5d11a50e0001e6da18460872.jpg

在这之前也遇到了 https://blog.csdn.net/airdark_long/article/details/82588064 这个错误,解决之后就又遇到这个问题了

写回答

3回答

木讷25

2019-10-03

Execute the following query in MYSQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Where root as your userlocalhost as your URL and password as your password

Try connecting using node after you do so

This is because caching_sha2_password is introduced in MySQL 8.0, but the Node.js version is not implemented yet.

Copy from Stack Overflow

0
0

慕姐9566582

2019-09-08

解决了吗,我跟你的问题一样

0
0

双越

2019-06-25

先自己百度一下“mysql access denied for user 'root'@'localhost'”,有很多结果,试着自己调一下。

毕竟你那边的情况我也不知道,没法给出具体的建议。你先自己尝试搞一下,再遇到问题再来回复。

0
0

Node.js+Express+Koa2+Nest.js 开发服务端

从入门到实战,一站式掌握 Node.js+Express+Koa2

4051 学习 · 2006 问题

查看课程