在MYSQL Workbench中执行以下查询
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’
当root作为用户 localhost的您的网址,并password为您的密码
然后运行以下查询以刷新特权:
flush privileges;
完成后尝试使用节点连接。
如果那行不通,请尝试一下@‘localhost’
相关文章
- 10-30node.js解决 Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol request
- 10-30Node.js连接mysql报加密方式错误解决方案
- 10-30Mac下mysql连接报错:ERROR 1045解决办法
- 10-30mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- 10-30【linux错误解决】MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- 10-30解决Ubuntu系统下 mysql 远程连接失败的问题 ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xx' (110)
- 10-30连接MySQL出现 2059 - authentication plugin ‘caching_sha2_password’ -navicat 解决方式
- 10-30【已解决】mysql连接出错:ERROR 1040 (HY000): Too many connections
- 10-30关于mysql连接时候出现"error 2003: can't connect to mysql server on 'localhost'(10061)问题的解决
- 10-30MySQL远程连接丢失问题解决方法Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0