我在Windows 10上通过PHPmyadmin通过Laravel Sail Docker环境连接到MariaDB数据库时遇到问题。这是我的Docker compose文件,我缺少什么:
services:
laravel.test:
build:
context: ./vendor/laravel/sail/runtimes/8.1
dockerfile: Dockerfile
args:
WWWGROUP: '${WWWGROUP}'
image: sail-8.1/app
extra_hosts:
- 'host.docker.internal:host-gateway'
ports:
- '${APP_PORT:-80}:80'
- '${VITE_PORT:-5173}:${VITE_PORT:-5173}'
environment:
WWWUSER: '${WWWUSER}'
LARAVEL_SAIL: 1
XDEBUG_MODE: '${SAIL_XDEBUG_MODE:-off}'
XDEBUG_CONFIG: '${SAIL_XDEBUG_CONFIG:-client_host=host.docker.internal}'
IGNITION_LOCAL_SITES_PATH: '${PWD}'
volumes:
- '.:/var/www/html'
networks:
- sail
depends_on:
- mariadb
# - redis
- mailpit
- phpmyadmin
mariadb:
image: 'mariadb:10'
ports:
- '${FORWARD_DB_PORT:-3306}:3306'
environment:
MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
MYSQL_ROOT_HOST: '%'
MYSQL_DATABASE: '${DB_DATABASE}'
MYSQL_USER: '${DB_USERNAME}'
MYSQL_PASSWORD: '${DB_PASSWORD}'
MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
volumes:
- 'sail-mariadb:/var/lib/mysql'
- './vendor/laravel/sail/database/mysql/create-testing-database.sh:/docker-entrypoint-initdb.d/10-create-testing-database.sh'
networks:
- sail
healthcheck:
test:
- CMD
- mysqladmin
- ping
- '-p${DB_PASSWORD}'
retries: 3
timeout: 5s
# redis:
# image: 'redis:alpine'
# ports:
# - '${FORWARD_REDIS_PORT:-6379}:6379'
# volumes:
# - 'sail-redis:/data'
# networks:
# - sail
# healthcheck:
# test:
# - CMD
# - redis-cli
# - ping
# retries: 3
# timeout: 5s
mailpit:
image: 'axllent/mailpit:latest'
ports:
- '${FORWARD_MAILPIT_PORT:-1025}:1025'
- '${FORWARD_MAILPIT_DASHBOARD_PORT:-8025}:8025'
networks:
- sail
phpmyadmin:
image: 'phpmyadmin:latest'
ports:
- 8080:80
networks:
- sail
environment:
- PMA_ARBITRARY=1
networks:
sail:
driver: bridge
volumes:
sail-mariadb:
driver: local
# sail-redis:
# driver: local
字符串
的数据
2条答案
按热度按时间llmtgqce1#
屏幕截图中文本字段下方的2条错误消息告诉您无法解析服务器名称
mysql
。在phpadmin中,您需要使用数据库的服务名作为服务器名。
因此,您需要使用
mariadb
,而不是您在屏幕截图中使用的mysql
。还要注意的是,如果一个数据库已经存在于你Map到
/var/lib/mysql
的目录中,那么你为用户名、密码等设置的变量就 * 不会 * 被使用。只有当容器启动时没有数据库存在时,才使用这些变量。nhaq1z212#
添加到容器的链接。phpmyadmin需要链接到运行的数据库容器:
字符串