MySQL Database
Popular relational database server
Relational database server for local development. Latest MySQL version with sensible defaults.
One-Click Install
Pre-configured with a development database and user account ready to use!
Default Configuration
Image: mysql:latest
Container: damp-mysql
Port: 3306:3306
Network: devnet
Volume: damp_mysql_data:/var/lib/mysqlEnvironment Variables
| Variable | Value | Description |
|---|---|---|
MYSQL_ROOT_PASSWORD | rootpassword | Root account password |
MYSQL_DATABASE | development | Default database |
MYSQL_USER | developer | Non-root user |
MYSQL_PASSWORD | devpassword | User password |
Connection Information
From Docker Containers (DevContainers)
# Using container name
mysql -h damp-mysql -u developer -pdevpassword developmentLaravel .env Configuration:
DB_CONNECTION=mysql
DB_HOST=damp-mysql
DB_PORT=3306
DB_DATABASE=development
DB_USERNAME=developer
DB_PASSWORD=devpasswordFrom Host Machine
# Using localhost
mysql -h localhost -P 3306 -u developer -pdevpassword developmentConnection String:
mysql://developer:devpassword@localhost:3306/developmentQuick Start
Install MySQL
Click "Install" on the MySQL service card in DAMP.
Connect from DevContainer
Open your project's .env file and use the connection details above.
Start Building
Run migrations and start developing!
Common Operations
Create New Database
-- As root user
mysql -h damp-mysql -u root -prootpassword
CREATE DATABASE my_new_db;
GRANT ALL ON my_new_db.* TO 'developer'@'%';
FLUSH PRIVILEGES;Import SQL File
# From host
mysql -h localhost -u developer -pdevpassword development < backup.sql
# From devcontainer
mysql -h damp-mysql -u developer -pdevpassword development < backup.sqlBackup Database
mysqldump -h localhost -u developer -pdevpassword development > backup.sqlData Persistence
Safe Storage
All data is stored in the damp_mysql_data Docker volume. Removing the service preserves your databases!
Performance Tip
MySQL in Docker performs best on Windows with WSL 2 backend enabled in Docker Desktop.