CREATE USER 'user'@'localhost' IDENTIFIED BY '12345678';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION

const mariadb = require('mariadb');

module.exports.Pool = mariadb.createPool({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  pass: process.env.DB_PASS,
  database: process.env.DB_NAME,
  connectionLimit: 5,
  dateStrings: 'date',
});

DB_HOST='localhost'
DB_USER='user'
DB_PASS='12345678'
DB_NAME='RGB_Project'

sudo mysql -u user -p

SQLError: (conn=37, no: 1045, SQLState: 28000) Access denied for user 'user'@'localhost' (using password: NO)
    at Object.module.exports.createError (/home/pi/node/node_modules/mariadb/lib/misc/errors.js:56:10)
    at Handshake.throwError (/home/pi/node/node_modules/mariadb/lib/cmd/command.js:37:20)
    at Handshake.handshakeResult (/home/pi/node/node_modules/mariadb/lib/cmd/handshake/handshake.js:110:21)
    at PacketInputStream.receivePacket (/home/pi/node/node_modules/mariadb/lib/io/packet-input-stream.js:79:9)
    at PacketInputStream.onData (/home/pi/node/node_modules/mariadb/lib/io/packet-input-stream.js:136:20)
    at Socket.emit (events.js:196:13)
    at addChunk (_stream_readable.js:290:12)
    at readableAddChunk (_stream_readable.js:271:11)
    at Socket.Readable.push (_stream_readable.js:226:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:166:17)
 From event:
    at _registerHandshakeCmd (/home/pi/node/node_modules/mariadb/lib/connection.js:652:11)
    at /home/pi/node/node_modules/mariadb/lib/connection.js:57:11
    at new Promise (<anonymous>)
    at Connection.connect (/home/pi/node/node_modules/mariadb/lib/connection.js:56:16)
    at createConnectionPoolPromise (/home/pi/node/node_modules/mariadb/lib/pool-promise.js:30:8)
    at creationTryout (/home/pi/node/node_modules/mariadb/lib/pool-base.js:322:9)
    at /home/pi/node/node_modules/mariadb/lib/pool-base.js:344:7
    at new Promise (<anonymous>)
    at connectionCreationLoop (/home/pi/node/node_modules/mariadb/lib/pool-base.js:306:12)
    at PoolPromise.PoolBase.initialize (/home/pi/node/node_modules/mariadb/lib/pool-base.js:139:5) {
  fatal: true,
  errno: 1045,
  sqlState: '28000',
  code: 'ER_ACCESS_DENIED_ERROR'
}

{
  "presets": [
    "@babel/preset-env"
  ],
  "plugins": [
    "@babel/plugin-proposal-class-properties",
    "transform-async-to-generator"
  ]
}