Question 104026 in Azure Question posted in
The official documentation to get you started can be found here.

Problem connecting express and MySQL azure

I’m new using Azure, I’ve created my database server and I’m trying to connect using environment variables.
When doing a simple SQL query to check that I’m connected I get the following error:

Error: Access denied for user ''@'localhost' (using password: NO)
  code: 'ER_ACCESS_DENIED_ERROR',
  error: 1045,
  sql:undefined,
  sqlState: '28000',
  sqlMessage: "Access denied for user ''@'localhost' (using password: NO)"

index.js

import express from "express";
import {PORT} from "./config.js";
import indexRoutes from './routes/index.routes.js'

const app = express();

app.use(indexRoutes);
app.listen(PORT);

console.log(`Server listening on port ${PORT}`);

config.js

import dotenv from 'dotenv'

dotenv.config()

export const config = {
    db: {
        host: process.env.HOSTNAME,
        user: process.env.USER,
        password: process.env.PASSWORD,
        database: process.env.DATABASE,
        port: process.env.PORT
    }
};


export const PORT = 4000;

index.routes.js

import { Router } from "express";
import { pool } from "../db.js";

const router = Router();

router.get("/ping", async (req, res) => {
  const result = await pool.query("SELECT 1 + 1 as result");
  console.log(result);
  res.json("ping");
});

export default router;

db.js

import {createPool} from 'mysql2/promise';


export const pool = createPool({

});
Tags:

2

Answers


  1. 0

    you should use ORMs like sequelize or typeorm to perform database interaction using express they make your life very easy

    Login or Signup to reply.
  2. 0
    • Here I was able to run query using mysql2 where I first read the variables separately and then added them to createpool function.
    require('dotenv').config();

var  data_base = process.env.d; ;
var  host = process.env.h; ;
var  port = process.env.p;
var  user = process.env.u;
var  pass_word = process.env.pass;

const  mysql = require('mysql2');
const  pool = mysql.createPool({
    host : host,
    database : data_base,
    user : user, 
    password : pass_word,
    port : port
});
const  pro = pool.promise();
const [rows,fields] = await  pro.query("CREATE TABLE testtt (P int)");

    output:

    enter image description here

    • Also, I think this can be a credential issue check the password and user.
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search