i have server.js
const mysql = require('mysql2')
const connection = mysql.createConnection({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database: process.env.DB_DATABASE,
})
and .env
DB_HOST=127.0.0.1
DB_USER=root
DB_PASSWORD=my password
DB_DATABASE=my db name
i work with Database Client JDBC in vscode
and there is the problem
Error: Access denied for user ”@’localhost’ (using password: YES)
at Packet.asError
code: ‘ER_ACCESS_DENIED_ERROR’,
errno: 1045,
sqlState: ‘28000’,
sqlMessage: “Access denied for user ”@’localhost’ (using password: YES)”,
sql: undefined
hope u will help me with that problem asap
New contributor
Ruslan Karpetskyu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.