laravel 如何将docker phpmyadmin镜像连接到.env文件凭据?

u3r8eeie  于 2023-11-20  发布在  Docker
关注(0)|答案(1)|浏览(151)

我新克隆的项目无法在我的个人笔记本电脑上登录到PHPMyAdmin,但我的办公电脑工作正常。
这是我的docker-composer.yml
我为phpmyadmin添加了一个图像,但是当你重定向到登录页面并输入数据库凭据时,它不起作用

  1. services:
  2. laravel.test:
  3. build:
  4. context: ./vendor/laravel/sail/runtimes/8.2
  5. dockerfile: Dockerfile
  6. args:
  7. WWWGROUP: '${WWWGROUP}'
  8. image: sail-8.2/app
  9. extra_hosts:
  10. - 'host.docker.internal:host-gateway'
  11. ports:
  12. - '${APP_PORT:-80}:80'
  13. - '${VITE_PORT:-5173}:${VITE_PORT:-5173}'
  14. environment:
  15. WWWUSER: '${WWWUSER}'
  16. LARAVEL_SAIL: 1
  17. XDEBUG_MODE: '${SAIL_XDEBUG_MODE:-off}'
  18. XDEBUG_CONFIG: '${SAIL_XDEBUG_CONFIG:-client_host=host.docker.internal}'
  19. IGNITION_LOCAL_SITES_PATH: '${PWD}'
  20. volumes:
  21. - '.:/var/www/html'
  22. networks:
  23. - sail
  24. depends_on:
  25. - mysql
  26. mysql:
  27. image: 'mysql/mysql-server:8.0'
  28. ports:
  29. - '${FORWARD_DB_PORT:-3306}:3307'
  30. environment:
  31. MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
  32. MYSQL_ROOT_HOST: '%'
  33. MYSQL_DATABASE: '${DB_DATABASE}'
  34. MYSQL_USER: '${DB_USERNAME}'
  35. MYSQL_PASSWORD: '${DB_PASSWORD}'
  36. MYSQL_ALLOW_EMPTY_PASSWORD: 1
  37. volumes:
  38. - 'sail-mysql:/var/lib/mysql'
  39. - './vendor/laravel/sail/database/mysql/create-testing-database.sh:/docker-entrypoint-initdb.d/10-create-testing-database.sh'
  40. networks:
  41. - sail
  42. healthcheck:
  43. test:
  44. - CMD
  45. - mysqladmin
  46. - ping
  47. - '-p${DB_PASSWORD}'
  48. retries: 3
  49. timeout: 5s
  50. phpmyadmin:
  51. depends_on:
  52. - mysql
  53. image: phpmyadmin/phpmyadmin
  54. environment:
  55. - PMA_HOST=mysql
  56. - PMA_PORT=3306
  57. - PMA_PASSWORD='${DB_PASSWORD}'
  58. networks:
  59. - sail
  60. ports:
  61. - 8001:80
  62. networks:
  63. sail:
  64. driver: bridge
  65. volumes:
  66. sail-mysql:
  67. driver: local
  68. sail-mariadb:
  69. driver: local

字符串


的数据
下面是我的.env文件:

  1. APP_NAME=recruitment
  2. APP_ENV=local
  3. APP_KEY=base64:JfiPosjWIXm2TMswb5zRTw6/d9+fwBAByZ5Z8igjik0=
  4. APP_DEBUG=true
  5. APP_URL=http://localhost
  6. LOG_CHANNEL=stack
  7. LOG_DEPRECATIONS_CHANNEL=null
  8. LOG_LEVEL=debug
  9. DB_CONNECTION=mysql
  10. DB_HOST=mysql
  11. DB_PORT=3306
  12. DB_DATABASE=phnavy_recruitment
  13. DB_USERNAME=sail
  14. DB_PASSWORD=password
  15. BROADCAST_DRIVER=log
  16. CACHE_DRIVER=file
  17. FILESYSTEM_DRIVER=local
  18. QUEUE_CONNECTION=sync
  19. SESSION_DRIVER=file
  20. SESSION_LIFETIME=120
  21. MEMCACHED_HOST=127.0.0.1
  22. REDIS_HOST=127.0.0.1
  23. REDIS_PASSWORD=null
  24. REDIS_PORT=6379
  25. MAIL_MAILER=smtp
  26. MAIL_HOST=smtp.gmail.com
  27. MAIL_PORT=587
  28. [email protected]
  29. MAIL_PASSWORD=ihmdshzxgqpzrxdv
  30. MAIL_ENCRYPTION=tls
  31. [email protected]
  32. MAIL_FROM_NAME="${APP_NAME}"
  33. AWS_ACCESS_KEY_ID=
  34. AWS_SECRET_ACCESS_KEY=
  35. AWS_DEFAULT_REGION=us-east-1
  36. AWS_BUCKET=
  37. AWS_USE_PATH_STYLE_ENDPOINT=false
  38. PUSHER_APP_ID=
  39. PUSHER_APP_KEY=
  40. PUSHER_APP_SECRET=
  41. PUSHER_APP_CLUSTER=mt1
  42. MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
  43. MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"
  44. SCOUT_DRIVER=meilisearch
  45. MEILISEARCH_HOST=http://meilisearch:7700


我在这个项目中的Laravel版本是Laravel 8
我希望你能帮我这个忙。先谢谢你。

wr98u20j

wr98u20j1#

工作版本

  1. environment:
  2. - MYSQL_DATABASE=${DB_DATABASE}
  3. - MYSQL_USER=${DB_USERNAME}
  4. - MYSQL_PASSWORD=${DB_PASSWORD}
  5. - MYSQL_ROOT_PASSWORD=${DB_PASSWORD}

个字符

相关问题