PHPMyAdmin docker-compose setup to access MySQL database running on docker host
Version for use with nginx, Apache etc
This version has a port mapped out to the more or less random port 28
version: '3.8'
services:
phpmyadmin:
image: phpmyadmin/phpmyadmin:latest
container_name: phpmyadmin
environment:
PMA_SOCKET: /run/mysqld/mysqld.sock
volumes:
- /run/mysqld/mysqld.sock:/run/mysqld/mysqld.sock
ports:
- 17035:80
extra_hosts:
- "host.docker.internal:host-gateway"
nginx
config
server {
server_name phpmyadmin.my-domain.com;
access_log /var/log/nginx/phpmyadmin.access_log;
error_log /var/log/nginx/phpmyadmin.error_log info;
root /var/sites/phpmyadmin.my-domain.com;
location / {
proxy_pass http://127.0.0.1:17035;
proxy_http_version 1.1;
proxy_read_timeout 3600s;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "Upgrade";
proxy_set_header Host $host;
proxy_set_header X-Forwarded-For $remote_addr;
proxy_set_header X-Forwarded-Proto $scheme;
add_header X-Frontend-Host $host;
}
listen 443 ssl;
ssl_certificate /etc/letsencrypt/live/my-domain.com/fullchain.pem;
ssl_certificate_key /etc/letsencrypt/live/my-domain.com/privkey.pem;
include /etc/letsencrypt/options-ssl-nginx.conf;
}
server {
if ($host = phpmyadmin.my-domain.com) {
return 301 https://$host$request_uri;
}
server_name phpmyadmin.my-domain.com;
listen 80;
return 404;
}