I have a project that works fine on local machine but when I deploy in live my php application (laravel) refused to connect to the mariadb container complaining → LARAVEL SAYS → SQLSTATE[HY000] [1045] Access denied for user ‘myuser’@‘192.168.278.4’ (using password: YES) (SQL: select * from oauth_clients where id = 11 limit 1)
I have no clue what 192.168.278.4 is but I suppose it is the containers internal ip.
I can connect to the docker-container (maria) and run the command that laravel can not when I use
→ mysql -u myuser -p -h 127.0.0.1 from host machine.
I can also put adminer in laravel’s public folder and access the db with the myuser and run the command just fine from outside using “maria” as hostname but laravel can not.
==== docker-compose file ====
version: “3.9”
networks:
php-net:
driver: bridge
services:
caddy:
container_name: caddy-server-275
image: caddy:2.7.5
restart: unless-stopped
depends_on:
- mariadb
- phpfpm
cap_add:
- NET_ADMIN
ports:
- "80:80"
- "443:443"
- "443:443/udp"
volumes:
- $PWD/Caddyfile:/etc/caddy/Caddyfile
- /var/www/mydomain:/srv
- /var/www/api.mydomain:/api
- caddy_data:/data
- caddy_config:/config
networks:
- php-net
phpfpm:
container_name: php-fpm
image: ‘bitnami/php-fpm:7.4’
depends_on:
- mariadb
networks:
- php-net
volumes:
- /var/www/mydomain:/srv
- /var/www/api.mydomain:/api
- $PWD/www.conf:/opt/bitnami/php/etc/php-fpm.d/www.conf
mariadb:
container_name: maria
image: mariadb:10.1
volumes:
- ./maria-br.cnf:/etc/mysql/conf.d/maria-br.cnf
- ./docker-runtime/mariadb-init:/docker-entrypoint-initdb.d # Place init .sql file(s) here.
- ./docker-runtime/maria-data:/var/lib/mysql
environment:
MYSQL_ROOT_PASSWORD: xxxxxxx
ports:
- "3306:3306"
networks:
- php-net
volumes:
caddy_data:
external: true
caddy_config:
==== LARAVEL .env FILE (I’ve tried localhost, 0.0.0.0, 127.0.0.1, maria, dbmaria nothing works) ===
APP_NAME=Laravel APP_ENV=local APP_KEY=base64:Edfdfgdfgsdfgsdfgsdfgsdfgee/kUg= APP_DEBUG=true APP_LOG_LEVEL=debug APP_URL=https://bla
DB_CONNECTION=mysql
DB_HOST=maria
DB_PORT=3306
DB_DATABASE=MyDb
DB_USERNAME=myuser
DB_PASSWORD=mypassword
BROADCAST_DRIVER=log CACHE_DRIVER=file QUEUE_CONNECTION=sync SESSION_DRIVER=file SESSION_LIFETIME=120