Access denied for user 'XXXXXXX'@'localhost' (using password: YES)

[ps97-ketangohil]

A message "Access denied for user 'XXXXXXX'@'localhost' (using password: YES)" message comes when I am executing ./bin/console doctrine:migrations:migrate -n

Please advise a fix.

Error snapshot is attached.

[Nikeev]

Hello! It seems that you provided incorrect MySQL credentials in .env.local
Please check that MYSQL_ variables are configured correctly and you db user has access to db.
Do you run SesDashboard in Docker or without?

[ps97-ketangohil]

Hi Nikeev,

Thank you for your response.

The credentials are correct in the .env.local file. The credentials are tested multiple times.

It is not a docker. It is a linux VM (Ubuntu 22.04 LTS) created on Azure.

It has something to do with the type of password I think.

One more strange thing noticed. As per document we should copy .env to .env.local which I did but actually it picks the connection from the .env file only.

Regards,
Ketan