Symfony database password

Question

I got a project to fix somethings and when I cant to connect in my database, i changed the .env file to:

DATABASE_URL="mysql://casino_db:[email protected]:3306/casino_ordering"

but I still have the same problem "An exception occurred in the driver:

 SQLSTATE[28000] [1045] Access denied for user 'casino_db'@'localhost' (using password: NO)"

I thing that i need to change some var in the code, may be the the APP_SECRET too? I cant find where i can change this password

Answer 1

If the password has special characters, you need to url encode it. When url encoding it, you will get a lot of "%" signs that Symfony will try to parse, so you need to escape the "%" with an additional "%".

For example:

• Original password: 1234567890$!*
• URL encoded: 1234567890%24%21%2A
• With % escaped: 1234567890%%24%%21%%2A

So, what goes into your .env file is 1234567890%%24%%21%%2A

Answer 2

There are many things that can go wrong.

I suggest you starting with bin/console debug:dotenv -e <your env> to check whether the env var is set.