Popular open-source relational database management system
What is this?
MySQL stores structured data (users, orders, posts) that websites and apps read and write.
Where to create or edit the main configuration — paths below match the setup steps.
/etc/mysql/my.cnfLocation: MySQL server
Server options, bind address, datadir
Step 01
1# Ubuntu / Debian2sudo apt-get update3sudo apt-get install -y mysql-server4sudo systemctl enable mysql5sudo mysql_secure_installation6 7# RHEL / Fedora8sudo dnf install -y mysql-server9sudo systemctl start mysqldStep 02
1mysql -u root -p2SELECT VERSION();Step 03
1sudo systemctl start mysql2sudo systemctl status mysql3mysql -u root -p -e "SHOW DATABASES;"4mysqldump -u root -p mydb > backup.sql5mysql -u root -p mydb < backup.sqlStep 04
1sudo systemctl status mysql2sudo mysql -u root3# Or reset password:4sudo mysql_secure_installation2 YAML templates for MySQL. Copy and deploy after setup.
2 ready-to-copy templates. Expand one, copy the YAML, then run the deploy commands.
docker-compose.yaml
PostgreSQL database + Flask app with env file and volume persistence
1version: "3.9"2 3services:4 db:5 image: postgres:15-alpine6 environment:7 POSTGRES_DB: dukaan_db8 POSTGRES_USER: dukaan9 POSTGRES_PASSWORD: dukaan12310 ports:11 - "5432:5432"12 volumes:13 - pgdata:/var/lib/postgresql/data14 15 app:16 build: .17 ports:18 - "5000:5000"19 env_file:20 - .env21 depends_on:22 - db23 24volumes:25 pgdata:Dockerfile
Flask application container image
1FROM python:3.12-slim2WORKDIR /app3COPY requirements.txt .4RUN pip install --no-cache-dir -r requirements.txt5COPY . .6EXPOSE 50007CMD ["python", "app.py"]Step 01
1cd your-project/2docker compose up -d --build3docker compose ps4docker compose logs -f app1docker compose down2docker compose down -v # remove volumes