Express mysql连接错误:在Mac操作系统上连接ETIMEDOUT

Question

我正在express上进行mysql连接。我在macos上使用xampp。创建连接时，返回(错误：connect ETIMEDOUT(错误。我该如何解决这个问题？

连接代码

const mysql = require('mysql2/promise');
const connection = await mysql.createPool({
host: "localhost",
user: "root",
password: "",
database: "xyz",
port:8080
});
const [rows, fields] = await connection.execute('SELECT * FROM users', []);

Answer 1

尝试将默认端口更改为3306。

const connection = await mysql.createPool({
host: "localhost",
user: "root",
password: "",
database: "xyz",
port:3306
});