✅ Step 1: Allow Remote MySQL Access in cPanel

  1. Login to your cPanel.
  2. Go to Remote MySQL under the Databases section.
  3. Add your local machine’s IP address (you can find it here).
    • Example: 123.45.67.89
    • You can also use % to allow access from all IPs (not secure in production).
  4. Click Add Host.

✅ Step 2: Find Database Connection Info in cPanel

In your cPanel, go to MySQL Databases and note:

  • Database name
  • Database username
  • Password
  • Hostname (might be yourdomain.com, localhost, or a remote IP like 123.45.67.89)

⚠️ Important: localhost won’t work from VS Code, because it points to your local machine. You need to use the public hostname or IP address of your server (e.g., server123.webhost.com or 203.0.113.7).

✅ Step 3: Update Your Code in VS Code 

import mysql from "mysql2/promise";

const db = mysql.createPool({
  host: "your-hostname-or-ip",     // e.g., "203.0.113.7" or "server123.webhost.com"
  user: "your_cpanel_db_user",     // e.g., "yourcpaneluser_dbuser"
  password: "your_db_password",
  database: "yourcpanel_db_name",  // e.g., "yourcpaneluser_dbname"
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0,
});

export default db;

✅ Step 4: Allow Port 3306 (If Needed)

If you’re using a firewall or your host blocks incoming MySQL connections:

  • Make sure port 3306 (MySQL default) is open.
  • Contact your hosting support if unsure.

💡 Extra Tip: Keep Your Credentials Secure

Use a .env file:

DB_HOST=your-hostname
DB_USER=your-db-user
DB_PASS=your-db-password
DB_NAME=your-db-name

Then load it in your code:

import dotenv from "dotenv";
dotenv.config();

const db = mysql.createPool({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASS,
  database: process.env.DB_NAME,
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0,
});