使用sequelize连接mysql数据库出错

最新推荐文章于 2023-10-07 15:01:52 发布

weixin_33859844

最新推荐文章于 2023-10-07 15:01:52 发布

阅读量3k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python

原文链接：https://my.oschina.net/quattro/blog/1862783

本文介绍了一种常见的Sequelize连接MySQL时遇到的认证错误及其解决方案，包括更改root用户的认证方式并重新配置Sequelize连接设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

bug背景：使用sequelize连接mysql数据库

错误信息如下：大概意思是数据库验证未通过

Unhandled rejection SequelizeConnectionError: Client does not support authentication protocol requested by server; consider upgrading MySQL client

C:\Users\Administrator>mysql -u root -p

Enter password: ******

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 18

Server version: 8.0.11 MySQL Community Server - GPL

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db

Database changed

mysql> alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1

23456' ;

Query OK, 0 rows affected (0.06 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.03 sec)

done!

贴js

const Sequelize = require('sequelize');
const sequelize = new Sequelize('db', 'root', '123456', {
  host: 'localhost',
  dialect: 'mysql',

  pool: {
    max: 5,
    min: 0,
    acquire: 30000,
    idle: 10000
  },

  // SQLite only
  //storage: 'path/to/database.sqlite',

  // http://docs.sequelizejs.com/manual/tutorial/querying.html#operators
  operatorsAliases: false
});

const User = sequelize.define('user', {
  username: Sequelize.STRING,
  birthday: Sequelize.DATE
});

sequelize.sync()
  .then(() => User.create({
    username: 'janedoe',
    birthday: new Date(1980, 6, 20)
  }))
  .then(jane => {
    console.log(jane.toJSON());
  });

F:\node_wp\express_wp\myapp\db>node test.js
Executing (default): CREATE TABLE IF NOT EXISTS `users` (`id` INTEGER NOT NULL auto_increment , `username` VARCHAR(255), `birthday` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;
Executing (default): SHOW INDEX FROM `users`
Executing (default): INSERT INTO `users` (`id`,`username`,`birthday`,`createdAt`,`updatedAt`) VALUES
(DEFAULT,'janedoe','1980-07-19 16:00:00','2018-07-25 05:31:33','2018-07-25 05:31:33');
{ id: 1,
  username: 'janedoe',
  birthday: 1980-07-19T16:00:00.000Z,
  updatedAt: 2018-07-25T05:31:33.750Z,
  createdAt: 2018-07-25T05:31:33.750Z }

转载于:https://my.oschina.net/quattro/blog/1862783