SvelteKit site won't connect to database

[AwesomeKalin]

Anyone know why my SvelteKit website isn't connecting to my MariaDB database. Credentials are correct and the user account is set to allow on all ip addresses.

import { DataTypes, Sequelize } from "sequelize";

export const db = new Sequelize(import.meta.env.VITE_DATABASE_NAME, import.meta.env.VITE_DATABASE_USERNAME, import.meta.env.VITE_DATABASE_PWD, {
    dialect: 'mariadb',
    host: import.meta.env.VITE_DATABASE_HOST,
    port: import.meta.env.VITE_DATABASE_PORT,
});

export const Downloads = db.define('Downloads', {
    name: {
        type: DataTypes.STRING,
    },
    count: {
        type: DataTypes.INTEGER,
    }
})

db.sync();

try {
    await db.authenticate();
    console.log('Database Initialised');
} catch {
    console.log('Database initialisation failed!');
}

Censored .env:

VITE_DATABASE_HOST=donator9.cortexnodes.com
VITE_DATABASE_USERNAME=awesomekalin
VITE_DATABASE_PWD=
VITE_DATABASE_NAME=aksite
VITE_DATABASE_PORT=

[ephys]

What error are you getting?

I see you're not awaiting sync, which should be

[AwesomeKalin]

I did add await to the sync part, which just stopped the dev server from crashing. Anyways, here's my error

11:44:41 [vite] Error when evaluating SSR module /src/db.server.ts:
|- SequelizeAccessDeniedError: (conn:384, no: 1045, SQLState: 28000) Access denied for user 'awesomekalin'@'myip' (using password: YES)
    at ConnectionManager.connect (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\mariadb\connection-manager.js:90:17)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ConnectionManager._connect (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
    at async D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
    at async ConnectionManager.getConnection (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
    at async D:\Code\AK55 Site\node_modules\sequelize\lib\sequelize.js:305:26
    at async MySQLQueryInterface.tableExists (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\query-interface.js:102:17)
    at async Downloads.sync (D:\Code\AK55 Site\node_modules\sequelize\lib\model.js:939:21)
    at async Sequelize.sync (D:\Code\AK55 Site\node_modules\sequelize\lib\sequelize.js:377:9)
    at async eval (eval at instantiateModule (file:///D:/Code/AK55%20Site/node_modules/vite/dist/node/chunks/dep-41cf5ffd.js:56049:28), <anonymous>:20:1)

11:44:41 [vite] Error when evaluating SSR module D:\Code\AK55 Site\src\routes\api\addDl\[slug]\+server.ts: failed to import "/src/db.server.ts"
|- SequelizeAccessDeniedError: (conn:384, no: 1045, SQLState: 28000) Access denied for user 'awesomekalin'@'myip' (using password: YES)
    at ConnectionManager.connect (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\mariadb\connection-manager.js:90:17)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ConnectionManager._connect (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
    at async D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
    at async ConnectionManager.getConnection (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
    at async D:\Code\AK55 Site\node_modules\sequelize\lib\sequelize.js:305:26
    at async MySQLQueryInterface.tableExists (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\query-interface.js:102:17)
    at async Downloads.sync (D:\Code\AK55 Site\node_modules\sequelize\lib\model.js:939:21)
    at async Sequelize.sync (D:\Code\AK55 Site\node_modules\sequelize\lib\sequelize.js:377:9)
    at async eval (eval at instantiateModule (file:///D:/Code/AK55%20Site/node_modules/vite/dist/node/chunks/dep-41cf5ffd.js:56049:28), <anonymous>:20:1)

AccessDeniedError [SequelizeAccessDeniedError]: (conn:384, no: 1045, SQLState: 28000) Access denied for user 'awesomekalin'@'myip' (using password: YES)
    at ConnectionManager.connect (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\mariadb\connection-manager.js:90:17)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ConnectionManager._connect (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
    at async D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
    at async ConnectionManager.getConnection (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
    at async D:\Code\AK55 Site\node_modules\sequelize\lib\sequelize.js:305:26
    at async MySQLQueryInterface.tableExists (D:\Code\AK55 Site\node_modules\sequelize\lib\dialects\abstract\query-interface.js:102:17)
    at async Downloads.sync (D:\Code\AK55 Site\node_modules\sequelize\lib\model.js:939:21)
    at async Sequelize.sync (D:\Code\AK55 Site\node_modules\sequelize\lib\sequelize.js:377:9)
    at async eval (eval at instantiateModule (file:///D:/Code/AK55%20Site/node_modules/vite/dist/node/chunks/dep-41cf5ffd.js:56049:28), <anonymous>:20:1) {
  parent: SqlError: (conn:384, no: 1045, SQLState: 28000) Access denied for user 'awesomekalin'@'myip' (using password: YES)
      at module.exports.createError (D:\Code\AK55 Site\node_modules\mariadb\lib\misc\errors.js:66:10)
      at PacketNodeEncoded.readError (D:\Code\AK55 Site\node_modules\mariadb\lib\io\packet.js:576:19)
      at Authentication.handshakeResult (D:\Code\AK55 Site\node_modules\mariadb\lib\cmd\handshake\authentication.js:162:32)
      at Authentication.onPacketReceive (D:\Code\AK55 Site\node_modules\mariadb\lib\cmd\handshake\authentication.js:40:17)
      at PacketInputStream.receivePacketBasic (D:\Code\AK55 Site\node_modules\mariadb\lib\io\packet-input-stream.js:85:9)
      at PacketInputStream.onData (D:\Code\AK55 Site\node_modules\mariadb\lib\io\packet-input-stream.js:135:20)
      at Socket.emit (node:events:518:28)
      at addChunk (node:internal/streams/readable:559:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
      at Readable.push (node:internal/streams/readable:390:5) {
    sqlMessage: "Access denied for user 'awesomekalin'@'myip' (using password: YES)",
    sql: null,
    fatal: true,
    errno: 1045,
    sqlState: '28000',
    code: 'ER_ACCESS_DENIED_ERROR'
  },
  original: SqlError: (conn:384, no: 1045, SQLState: 28000) Access denied for user 'awesomekalin'@'myip' (using password: YES)
      at module.exports.createError (D:\Code\AK55 Site\node_modules\mariadb\lib\misc\errors.js:66:10)
      at PacketNodeEncoded.readError (D:\Code\AK55 Site\node_modules\mariadb\lib\io\packet.js:576:19)
      at Authentication.handshakeResult (D:\Code\AK55 Site\node_modules\mariadb\lib\cmd\handshake\authentication.js:162:32)
      at Authentication.onPacketReceive (D:\Code\AK55 Site\node_modules\mariadb\lib\cmd\handshake\authentication.js:40:17)
      at PacketInputStream.receivePacketBasic (D:\Code\AK55 Site\node_modules\mariadb\lib\io\packet-input-stream.js:85:9)
      at PacketInputStream.onData (D:\Code\AK55 Site\node_modules\mariadb\lib\io\packet-input-stream.js:135:20)
      at Socket.emit (node:events:518:28)
      at addChunk (node:internal/streams/readable:559:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
      at Readable.push (node:internal/streams/readable:390:5) {
    sqlMessage: "Access denied for user 'awesomekalin'@'myip' (using password: YES)",
    sql: null,
    fatal: true,
    errno: 1045,
    sqlState: '28000',
    code: 'ER_ACCESS_DENIED_ERROR'
  }
}

[ephys]

Access denied means either your username or password is wrong, or your user is missing permissions in the database

[AwesomeKalin]

I have specified % for all ip addresses and I copied and pasted my credentials from .env into phpMyAdmin on 2 different servers and it just worked

[ephys]

Verify that they are what you expect by using console.log before you create the sequelize instance

[AwesomeKalin]

Thanks!