How to connect to mysql database in docker?

Question

MySQL

Created a container with a mysql database and decided to use the heidisql GUI for convenience.
Step by step:
1. I create a user with all rights.

CREATE USER 'lost'@'%' IDENTIFIED BY '123';
GRANT ALL PRIVILEGES ON *.* TO 'lost'@'%';
FLUSH PRIVILEGES;

2. I make sure that the user with the specified name has been created.

+------------------+-----------+
| user             | host      |
+------------------+-----------+
| lost             | %         |
| root             | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
6 rows in set (0.00 sec)

3. Next, I go to the container and in order to identify its ip address and port.

4. I open heidisql and enter the specified data.

5. But it gives an error that it cannot connect.

I've tried everything, but haven't been able to find a solution yet.

Answer 1

Port 3306 opened outside?