[BUG] Special characters in MYSQL_PASSWORD result in a not working database access

[SteveTh3Piirate]

I've previously had a version of PF running on my Unraid Server, I've got this one sort of running but for some reason the database is denying access. Below is the quote I'm getting from withing the Setup Page.

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

I'm not sure what the problem is, i cannot even log in through terminal, gives me the same errors.

[fleischsalatinspace]

From slack:

there is or used to be a bug/strange behavior in the one of the entryscripts in the image. If you use any special characters in your MYSQL_PASSWORD, the sql connection fails

Can you provide technical details on:

i cannot even log in through terminal, gives me the same errors.

[SteveTh3Piirate]

I edited the docker-compose.yml

Instead of using image: bianjp/mariadb-alpine:latest

I used image: linuxserver/mariadb:latest

Instantly let me in and set up tables. Very Strange.

[fleischsalatinspace]

Can you please rename the issue to
[BUG] Special characters in MYSQL_PASSWORD result in a not working database access. This will be worked on in combination with possible changes to the base images. thank you

[samoneilll]

I've tried to recreate this issue by slowly adding more special characters to the password till I ended up with MYSQL_PASSWORD="P4#@%^&*$-></?=_~", and it's still working using the brianjp/mariadb-alpine image, on macOS as the host.

I have a suspicion that it's not about the password of the image itself, but rather about the host machine and how the values are read from .env. If anybody has a combination of host OS and password that I could try to test with I'd appreciate it.

[barndawgie]

I encountered this problem on an AWS EC2 instance running their stock Ubuntu 20.04 image, so should be relatively easy to replicate.

[rwc]

@samoneilll I was able to reproduce with Debian 10 & Debian 11.

1. The quotes are being interpreted as part of the password itself
2. When connecting to the database locally, said password is refused. After adding command: --skip-grant-tables I was able to auth as root and grant privileges to 'root'@'localhost' & 'root'@'%' then afterwards successfully connect the app to the db.