SQL Server Access

[itlogix2012]

Hello, we are using a self-hosted system and need a way to query the database directly. Has anyone managed to install PHPAdmin or expose the Docker container so that we can make this happen?

[lazovic]

Hi itlogix2012,

These articles may be helpful for you:

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-20-04

https://medium.com/@elaurichetoho/setting-up-mysql-and-phpmyadmin-with-docker-compose-e569881d394e

[jamie]

super easy you just have to list the port and/or expose it. Here is my compose file to help you out. only thing that was a little tircky was what host to use though if your connecting externally, just use the ip of the host computer and whatever port you use, in my case 3307.

You probably see the ${MYSQL_ROOT_PASSWORD} and might wonder what it is, that's stuff from the .env file

db:
image: mariadb:latest
container_name: ${CONTAINER_NAME}-db
environment:
TZ: Europe/London
MARIADB_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
MARIADB_USER: ${DB_USER}
MARIADB_PASSWORD: ${DB_PASSWORD}
MARIADB_DATABASE: ${DB_DATABASE}
volumes:
- db-data:/var/lib/mysql
restart: unless-stopped
healthcheck:
test: [ "CMD", "healthcheck.sh", "--connect", "--innodb_initialized" ]
interval: 20s
start_period: 10s
timeout: 10s
retries: 3
ports:
- "${DB_PORT:-3307}:3306"
expose:
- "${DB_PORT:-3307}"
# command:
# --slow-query-log=1
# --long-query-time=0.5
# --log-output=FILE
logging:
driver: json-file
options:
max-size: "10m"
max-file: "3"
networks:
- espocrm-net

volumes:
db-data:

networks:
espocrm-net:
driver: bridge​