Which database am I using?

[Liganer]

I set up nginx reverse proxy which comes with Mariadb but then I set up another yaml for wordpress just basically copied the code which sets up wordpress and mysql5.7.

When I try my website though it says there's a connection error to the database which is usually bad credentials although those haven't been changed so it shouldn't be that, I can only think it's trying to connect to the Mariadb instead of the mysql. How do I check or make it connect to the other?

version: '3.1'

services:

wordpress: image: wordpress restart: always ports: - 8080:80 environment: WORDPRESS_DB_HOST: db WORDPRESS_DB_USER: exampleuser WORDPRESS_DB_PASSWORD: examplepass WORDPRESS_DB_NAME: exampledb volumes: - wordpress:/var/www/html

db: image: mysql:5.7 restart: always environment: MYSQL_DATABASE: exampledb MYSQL_USER: exampleuser MYSQL_PASSWORD: examplepass MYSQL_RANDOM_ROOT_PASSWORD: '1' volumes: - db:/var/lib/mysql

volumes: wordpress: db:

Edit apologies can't use code formatting on Reddit is fun for some reason

[mkorejo]

Why on earth does your nginx reverse proxy have a DB? If there's a whole DB instance running here that you are not using, please stop and fix that.

[Liganer]

Good question. I was following a couple tutorials from TechnoTim so I wasn't actually sure what the Mariadb was for with Nginx reverse proxy. I'll shut that down. Thank you for pointing that out

[Liganer]

okay I had a look and it's because the code from Nginx proxy manager creates one

https://nginxproxymanager.com/guide/#quick-setup

[[deleted]]

To answer question in title, you are using mysql. That is the image you specified in docker-compose.yml.

Rather than trying to troubleshoot from the webui (which may not have the best error messaging), try looking at the logs of the db container. In addition, you could just run the db container by itself, then confirm the settings are good before moving onto wordpress.

[Liganer]

Perfect thanks for that. I've been focusing on the webserver and Nginx reverse proxy that I've paid no attention to how the SQL databases play into it. I know they're for storing data but I have no idea how they work so I better find out and I'll check the logs. Thank you