Question

I was trying out Docker for the first time. Got a LEMP stack up and running, but I can t connect to the MYSQL Database. Not on my Symfony application, not on PHPMyAdmin. The applications are returning the following error code:

司机有例外:KallSTATE[HY000] [2002] 拒绝联系

这是我的cker。

nginx:
    image: tutum/nginx
    ports:
        - "80:80"
    links:
        - phpfpm
    volumes:
        - ./nginx/default:/etc/nginx/sites-available/default
        - ./nginx/default:/etc/nginx/sites-enabled/default

        - ./logs/nginx-error.log:/var/log/nginx/error.log
        - ./logs/nginx-access.log:/var/log/nginx/access.log
phpfpm:
    build: phpfpm/
    ports:
        - "9000:9000"
    volumes:
        - ./public:/usr/share/nginx/html
mysql:
  image: mariadb
  ports:
    - 3306:3306
  environment:
    MYSQL_ROOT_PASSWORD: admin
phpmyadmin:
  image: phpmyadmin/phpmyadmin
  restart: always
  links:
    - mysql
  ports:
    - 8183:80
  environment:
    MYSQL_USERNAME: admin
    MYSQL_ROOT_PASSWORD: admin
    PMA_ARBITRARY: 1

Dockerfile PHPFPM:

    FROM php:fpm

RUN docker-php-ext-enable opcache
RUN apt-get update 
  && apt-get install -y --no-install-recommends libpq-dev 
  && docker-php-ext-install mysqli pdo_pgsql pdo_mysql

GitHub URL: https://github.com/MolengraafFrank/DockerSymfony

谁能帮助我? 感谢你时间。

Answer 1

[2002年]链接拒绝,意味着你可以进入数据库服务器,但用户(在您的个案中)没有适当的接入。海运局有一个根基用户,其密码由MYSQL_ROOT_PASSWORD提供,该用户可与任何服务器连接(%)。

If you want use an over login to your databases, you have to create it in the databases server with the right granting on databases from chosen locations.

www.un.org/Depts/DGACM/index_spanish.htm 这里的问题是,你把你的数据库服务器命名为我的仪表(在cker-comp中的名称)。但是,由于违约,Sphpmyadmin试图与一个名为db的数据库服务器连接起来。添加<条码>PMA_HOST: mysql,在phpmyadmin服务的环境部分之下,将解决这一问题。

I think that MYSQL_USERNAME and PMA_ARBITRARY are useless if you work with default configuration (connection with root to your databases server)

Answer 2

我面临这一挑战,因为我拥有3个拥有不同IP地址的不同集装箱。

db - 172.18.0.3 - container for MYSQL
app - 172.18.0.2 - container for Laravel app

因此,我通过编辑我的Laravel .env 案卷确定。

DB_CONNECTION=mysql
DB_HOST=172.18.0.3
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=username
...

集装箱 Ip Address. 您的cker客

docker inspect -f  {{.Name}} - {{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}  $(docker ps -aq)

UPDATED: For latest docker versions and based on the services name, "mysql", in your docker-compose.yml

mysql:
  image: mariadb
  ports:
    - 3306:3306

你可以尝试:

DB_CONNECTION=mysql
DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=username

DB_HOST is the name of MySQL service name specified in docker-compose.yml

Answer 3

我曾设法利用我sql的指挥线工具,将我与我的手脚相连接,这是使用的指令I——mysql -u fundamental -p -h 1270.0.1,并进入行政密码。这是否足以解决你的问题?

Answer 4

In my case I was running mysql in a docker container whose port was mapped to the host mac (3306:3306). I tried connecting to this database from a phpmyadmin docker container using 127.0.0.1 . But it won t work because the localhost on the phpmyadmin docker container does not have the required mysql running.

连接cker网的东道方

docker.for.mac.host.internal

Docker Networking Docker Compose Networking

Answer 5

就我而言,问题在于portmap。

在我的案件中,当我将其改为3307:3306时,我也可与非行联系。

Answer 6

If you want to know why your connexion failed, you can use in your terminal php artisan tinker and then like

DB::connection()->getPdo();

Unfortunately this will only give you a part of the error. Quit tinker and then use this command php artisan db will give you more information like database type, host, port, ad user about the issue.

和

ERROR 2003 (HY000): Can t connect to MySQL server on  127.0.0.1:3306  (61)

   SymfonyComponentProcessExceptionProcessFailedException 

  The command " mysql   --host=127.0.0.1   --port=3306   --user=root   --default-character-set=utf8mb4   laravel " failed.

Exit Code: 1(General error)

Working directory: /Users/Dev/Documents/www/laravel_docker/src/addressAPI

Output:
================


Error Output:
================

  at vendor/symfony/process/Process.php:270
    266▕      */
    267▕     public function mustRun(callable $callback = null, array $env = []): self
    268▕     {
    269▕         if (0 !== $this->run($callback, $env)) {
  ➜ 270▕             throw new ProcessFailedException($this);
    271▕         }
    272▕ 
    273▕         return $this;
    274▕     }

      +14 vendor frames 
  15  artisan:37
      IlluminateFoundationConsoleKernel::handle(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))

这不会给你回答什么是错的,但至少你可以理解为什么你们的愤怒是错误的。

Answer 7

⚠ This answer is an additional hint for a special case!

如果出现突然错误,情况就是如此。 i.e.?everything在<>but after <>em> an update of 拦截一些集装箱或类似集装箱,IP >MySQL集装箱可能发生变化,并可能导致这种错误。在我的案件中,Laravel .env

DB_CONNECTION=mysql DB_HOST=172.19.0.3 DB_PORT=3306 DB_DATABASE=db_name DB_USERNAME=db_user DB_PASSWORD=superSecret

and for Yii2 app config/db.php

return [ class => yiidbConnection , dsn => mysql:host=172.19.0.3;dbname=db_name2 , username => db_user , password => superSecret , charset => utf8 , ];

我在两处服完罚款后,都会发现这种错误。但是,运行<代码>docker 检查了我的sql,其中我的sql是网络部分的神秘集装箱的名称:

... "Gateway": "172.19.0.1", "IPAddress": "172.19.0.2", ...

因此,从172.19.0.3改为172.19.0.2。在该案中解决这一问题。

Answer 8

you need to link the phpfpm container to mysql.

Answer 9

添加<条码>DB_READ_HOST=db 解决了这一问题。

⚠ This answer is an additional hint for a special case!

友情链接