SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'localhost' (using password: YES)

I installed V5 on Ubutnu 20.4

Went to set up

Tested PDF - worked fin

MYSQL is the issue

When testing I get this

SQLSTATE[HY000] [1045] Access denied for user ‘ninja’@‘localhost’ (using password: YES)

I set up the Maria db using this code:

$ mysql -u root -p
Enter Password: ******
MariaDB … > create database ninjadb;
MariaDB … > create user ‘ninja’@‘localhost’ identified by ‘ninjapass’;
MariaDB … > grant all privileges on ninjadb.* to ‘ninja’@‘localhost’;
MariaDB … > flush privileges;
MariaDB … > exit

I checked my .env file and this is what it has

DB_HOST1=localhost
DB_DATABASE1=ninja
DB_USERNAME1=ninja
DB_PASSWORD1=ninja
DB_PORT1=3306

DB_HOST2=localhost
DB_DATABASE2=ninja2
DB_USERNAME2=ninja
DB_PASSWORD2=ninja

DB_PORT1=3306

DB_HOST2=localhost
DB_DATABASE2=ninja2
DB_USERNAME2=ninja
DB_PASSWORD2=ninja
DB_PORT2=3306

DEMO_MODE=false

Not sure what to do here

Hi,

It looks like you’re using three different database names: ninjadb, ninja and db-ninja-01