CMS doesn't see MySQL in Docker container?

Question

MySQL

I set out to launch the site when MySQL is in the Docker container.

Available:
Docker container:

CONTAINER ID   IMAGE                    COMMAND                  CREATED        STATUS                  PORTS                                 NAMES
38890df7ee0b   mysql/mysql-server:5.7   "/entrypoint.sh mysq…"   13 hours ago   Up 13 hours (healthy)   33060/tcp, 127.0.0.1:3310->3306/tcp   mysql

The problem is that the CMS does not see it as localhost. (see screenshot)



1635 line:

mysqli_real_connect( $this->dbh, $host, $this->dbuser, $this->dbpassword, null, $port, $socket, $client_flags );

All privileges have been granted.

mysql> show grants for 'mto'@'localhost';
+------------------------------------------------------+
| Grants for [email protected]                             |
+------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mto'@'localhost'              |
| GRANT ALL PRIVILEGES ON `mto`.* TO 'mto'@'localhost' |
+------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show grants for 'mto'@'%';
+----------------------------------------------+
| Grants for mt[email protected]%                             |
+----------------------------------------------+
| GRANT USAGE ON *.* TO 'mto'@'%'              |
| GRANT ALL PRIVILEGES ON `mto`.* TO 'mto'@'%' |
+----------------------------------------------+
2 rows in set (0.00 sec)

In this case, if you connect like this, everything is ok:

mysql -umto -h127.0.0.1 -P3310 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.

And if you do not explicitly specify the port, the connection fails

mysql -umto -h127.0.0.1:3310 -p
Enter password: 
ERROR 2005 (HY000): Unknown MySQL server host '127.0.0.1:3310' (2)

Tell me how to make friends?

I intentionally want only MYSQL in the docker, I don’t offer to throw everything into containers.

Answer 1

It looks like your actual connection is not through localhost, but on the ip of the container.