node 链接mysql报错

Question

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

Answer 1

木讷25 2019-10-03 21:20:49

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

Answer 2

慕姐9566582 2019-09-08 01:29:01

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

Answer 3

双越 2019-06-25 14:16:22

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

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