#1 2024-08-02 07:57:57

stefanoneri
Member
2024-08-02
1

Array ( [0] => Access denied for user 'MYSQL_USER'@'192.168.0.5'

Hi,

I am currently struggling hard with getting piwigo to work - making a fresh install via the official docker on Unraid.

I am hosting the current setup locally:
- piwigo (piwigo.fritz.box & 192.168.0.5)
- MySQL (mysql.fritz.box & 192.168.0.4)
(both running and each individual setup seems to be OK)

I have set up a MYSQL_USER and a MYSQL_DATABASE (yes with those respective names) and now try to fill out the setup page at piwigo. However, when I enter the database host as either 192.168.0.4 or mysql.fritz.box with the respective ports, piwigo always shows the following error:
Array ( [0] => Access denied for user 'MYSQL_USER'@'192.168.0.5' (using password: YES) )

So it seems to be trying to log in with the mySQL credentials on the piwigo host, which of course will not work.

What I did:
- changed the password for the SQL-User to not contain any non alphanumeric characters (such as !*") - without success
- tried setting up with either hostname or IP, both resulting in the same error as stated above
- if i try to use "localhost" as database host (which should not work anyways in my setup), this error is shown: Array ( [0] => No such file or directory )

Additional Information:
PING piwigo.fritz.box (192.168.0.5): 56 data bytes
64 bytes from 192.168.0.5: icmp_seq=0 ttl=64 time=17.348 ms
64 bytes from 192.168.0.5: icmp_seq=1 ttl=64 time=39.500 ms

PING mysql.fritz.box (192.168.0.4): 56 data bytes
64 bytes from 192.168.0.4: icmp_seq=0 ttl=64 time=16.216 ms
64 bytes from 192.168.0.4: icmp_seq=1 ttl=64 time=13.099 ms


Would appreciate your support :)

Thank You!

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact