MySQL数据库 （PHP、NodeJS）

PHP

$servername = "localhost";
$username = "登录数据库的名(root)";
$password = "登录密码";
$database = '要连接的数据表的表名';
$port = '3306';
$encoding = 'utf8';

// 创建连接
$conn = new mysqli($servername, $username, $password,$database,$port);

// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
echo "连接成功";

NodeJS

let mysql = require('mysql')
let pool = mysql.createPool({
  host: 'localhost',
  user: '登录数据库的名(root)',
  password: '登录密码',
  database: '要连接的数据表的表名',
  port: 3306,
  encoding: 'utf8'
})
new Promise((resolve, reject) => {
    pool.getConnection(function(err, connection) {
      if (err) {
        reject(err)
      } else {
        connection.query(sql, function(err, data) {
          if (err) {
            reject(err)
          } else {
            resolve(data)
          }
          connection.release()
        })
      }
    })
  })