MySQL

MySQL is a fast, reliable, and easy-to-use open-source relational database management system used by high-profile web applications.

Docker Compose Configuration

• Creates docker.compose.yml at project root with MySQL service
• Image: mysql:latest official Docker image
• Container: Named mysql-{projectName} for easy identification
• Environment Variables:
  • MYSQL_ROOT_PASSWORD: password (change in production)
  • MYSQL_DATABASE: mysql-{projectName}
  • MYSQL_USER: mysql
  • MYSQL_PASSWORD: password
• Ports: Exposes port 3306 (MySQL default)
• Volume: Persistent storage at mysql-{projectName}-data:/var/lib/mysql
• Network: Dedicated bridge network mysql-{projectName}-network
• Command: --max-connections=100 --default-authentication-plugin=mysql_native_password
• Healthcheck:
  • Test: mysqladmin ping -h localhost -u root -ppassword
  • Interval: 10s, Timeout: 5s, Retries: 5
  • Start period: 30s for initialization

Connection String Format:

mysql://mysql:password@localhost:3306/mysql-{projectName}