无法让passportjs使用express和mysql对本地策略进行身份验证

// 引入所需的模块和库
const express = require('express');
const passport = require('passport');
const LocalStrategy = require('passport-local').Strategy;
const mysql = require('mysql');

// 创建MySQL连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

// 连接到MySQL数据库
connection.connect();

// 配置Passport.js的本地策略
passport.use(new LocalStrategy(
  function(username, password, done) {
    // 查询用户信息
    connection.query('SELECT * FROM users WHERE username = ?', [username], function(err, rows) {
      if (err) { return done(err); }
      if (!rows.length) {
        return done(null, false, { message: 'Incorrect username.' });
      }
      if (rows[0].password !== password) {
        return done(null, false, { message: 'Incorrect password.' });
      }
      return done(null, rows[0]);
    });
  }
));

// 序列化和反序列化用户对象
passport.serializeUser(function(user, done) {
  done(null, user.id);
});

passport.deserializeUser(function(id, done) {
  connection.query('SELECT * FROM users WHERE id = ?', [id], function(err, rows) {
    done(err, rows[0]);
  });
});

// 创建Express应用程序
const app = express();

// 配置Express中间件
app.use(express.urlencoded({ extended: false }));
app.use(express.json());
app.use(require('express-session')({ secret: 'secret_key', resave: false, saveUninitialized: false }));
app.use(passport.initialize());
app.use(passport.session());

// 创建登录路由
app.post('/login', passport.authenticate('local', { successRedirect: '/profile', failureRedirect: '/login' }));

// 创建保护路由
app.get('/profile', isAuthenticated, function(req, res) {
  res.send('You are authenticated!');
});

// 创建身份验证中间件
function isAuthenticated(req, res, next) {
  if (req.isAuthenticated()) {
    return next();
  }
  res.redirect('/login');
}

// 启动服务器
app.listen(3000, function() {
  console.log('Server is running on port 3000');
});