[AdonisJS 5] Error Access denied for user for driver mysq and mysq2

[andre-ab]

I have an error in the two MySQL drivers:
AdonisJs 5
Mysql 8
Debian 11

my settings:
mysql

Error:

mysql2

Error:

Error:

I have access by express using knex in mysql and mysq2 drivers
my senttings express + knexjs

Ok:

Mysq2

Ok

I have access by Squirrel

[tomgobich]

Env.get() takes a lookup key as the first argument that it'll use to grab a value from the .env file. You can use the second argument for fallback values, though I'd recommend the below over that.

What you want to do is add the values you placed inside your MySQL config inside the .env file as the following:

DB_CONNECTION=mysql
MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=aldisseia
MYSQL_PASSWORD=mid800
MYSQL_DB_NAME=mydb

The premise of environment variables is to keep things like this secret and outside of the code. The .env file shouldn't be committed to GitHub or any other repository.

Once you've updated your .env file to the above, reset your MySQL config back to how it initially was:

mysql: {
    client: 'mysql',
    connection: {
      host: Env.get('MYSQL_HOST'),
      port: Env.get('MYSQL_PORT'),
      user: Env.get('MYSQL_USER'),
      password: Env.get('MYSQL_PASSWORD', ''),
      database: Env.get('MYSQL_DB_NAME'),
    },
    migrations: {
      naturalSort: true,
    }, 
    healthCheck: false,
    debug: false,
  },

This will use the MYSQL_HOST, MYSQL_PORT, etc keys to look up the value within your .env and it'll use the matched value.

It's also recommended to add these to your env.ts file. You can think of this as a validation file for your environment variables (.env).

DB_CONNECTION: Env.schema.string(),
MYSQL_HOST: Env.schema.string({ format: 'host' }),
MYSQL_PORT: Env.schema.number(),
MYSQL_USER: Env.schema.string(),
MYSQL_PASSWORD: Env.schema.string.optional(),
MYSQL_DB_NAME: Env.schema.string(),

You can read through the Environment Variables documentation for more information.
https://docs.adonisjs.com/guides/environment-variables

[andre-ab]

thanks for answering

The error persists

my routes.ts

Error for mysql2:

Erro for mysql

[tomgobich]

Please look at how your Env.get is being used compared to what I provided above. Env.get('MYSQL_HOST') maps to the MYSQL_HOST key inside the .env file. The way you have it you're trying to provide the value as the key, which won't work.

mysql: {
    client: 'mysql',
    connection: {
      host: Env.get('MYSQL_HOST'), // <-
      port: Env.get('MYSQL_PORT'), // <- 
      user: Env.get('MYSQL_USER'), // <-
      password: Env.get('MYSQL_PASSWORD', ''), // <-
      database: Env.get('MYSQL_DB_NAME'), // <-
    },
    migrations: {
      naturalSort: true,
    }, 
    healthCheck: false,
    debug: false,
  },

[andre-ab]

Thank you so much.
is working now for mysql2, the error persists in mysql.

[galaczi]

You have to use the defined env variables with Env.get. Like:

host: Env.get('HOST')

[andre-ab]

None of them work

[galaczi]

Check Tom's reply. You have to use only the name of the environment variable.

[andre-ab]

Thanks for answering.
it's working for mysql2.
error for mysq.
Thanks.

[andre-ab]

It's working. You can close as resolved.
"I couldn't find a way to close a thread as resolved."
Thank you all.

[WeyIin]

It's working. You can close as resolved. "I couldn't find a way to close a thread as resolved." Thank you all.

You need to accept an answer which was helpful to be auto-closed.