安装
npm i sequelize
npm i mysql
npm i mysql2
这个不管你有没有npm i mysql ,这个也需要在装一次。但引入的时候还是mysql
引入
const { Sequelize, DataTypes } = require('sequelize')
// DataTypes是属性类型,后面文章会用到
const mysql = require('mysql')
连接
const conf = {
host: '192.168.0.105',
port: '3306',
dialect:'mysql' // 要连接什么类型的数据库
}
const seq = new Sequelize("xrs",'wyy','123',conf)
第一个参数是表名,第二个参数是用户名,第三个参数是密码,第四个参数是配置
测试是否连接成功
用authenticate函数测试
try {
seq.authenticate();
console.log(' successfully.');
} catch (error) {
console.error( error);
}
完整代码:
const { Sequelize, DataTypes } = require('sequelize')
const mysql = require('mysql')
const conf = {
host: '192.168.0.105',
port: '3306',
dialect:'mysql'
}
const seq = new Sequelize("xrs",'wyy','123',conf)
try {
seq.authenticate();
console.log(' successfully.');
} catch (error) {
console.error( error);
}