谷歌应用引擎连接外部MySQL Node.js

mkdir my-app
cd my-app
npm init -y

npm install mysql express

// config.js
module.exports = {
  host: 'your-mysql-host',
  user: 'your-mysql-user',
  password: 'your-mysql-password',
  database: 'your-database-name',
};

// db.js
const mysql = require('mysql');
const config = require('./config');

const pool = mysql.createPool({
  connectionLimit: 10,
  host: config.host,
  user: config.user,
  password: config.password,
  database: config.database,
});

module.exports = {
  query: (sql, values) => {
    return new Promise((resolve, reject) => {
      pool.query(sql, values, (error, results) => {
        if (error) return reject(error);
        resolve(results);
      });
    });
  },
};

// app.js
const express = require('express');
const db = require('./db');

const app = express();
const port = process.env.PORT || 8080;

app.get('/', async (req, res) => {
  try {
    const results = await db.query('SELECT * FROM your_table_name');
    res.json(results);
  } catch (error) {
    res.status(500).send('Database error');
  }
});

app.listen(port, () => {
  console.log(`App listening on port ${port}`);
});

runtime: nodejs14

env_variables:
  # 如果需要，可以在这里添加环境变量

gcloud app deploy