本地安装网站无法连接数据库

// 示例：Node.js中的数据库连接配置
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to the database!');
});

# 示例：检查端口是否开放
telnet localhost 3306

-- 示例：MySQL中更新用户权限
GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'localhost';
FLUSH PRIVILEGES;

# 示例：启动MySQL服务
sudo service mysql start

# 示例：更新Node.js的MySQL驱动程序
npm install mysql@latest