My problem is occuring when I try to login to SQL using user:'root', host: 'localhost', database: 'db' and password: '' ,the console gives error like I didn't define user
[!] SQL Error: Error: ER_ACCESS_DENIED_ERROR: Access denied for user ''@'localhost' (using password: NO)
My server.js:
import SQL from 'mysql';
SQL: {
host: 'localhost'
user: 'root'
password: ''
database: 'root'
};
function load() {
var MySQL = SQL.createConnection(SQL)
MySQL.connect((err) => {
if(err) {
console.log(err);
process.exit(0);
}
for(var i = 0; i < 250; i++) console.log("\n");
console.log('Successfuly logged in!');
});
}
load();
What can be done to prevent this error?
I am new to SQL and JS so please, don't be harsh on me if it's a stupid question :)
EDIT: I want to mention that I tried changing values of host, user, password and database and whatever I put, it says the same error.
I tried setting some random word for pass, example: password: 'pass123'
but the console gives me the same error inluding using password: NO part.
What could cause that problem?
Your SQL field isn't a valid object.
Change
SQL: {
host: 'localhost'
user: 'root'
password: ''
database: 'root'
};
to
credentials = {
host: 'localhost'
user: 'root'
password: ''
database: 'root'
};