I am using docker-compose
to create mysql
container.
I get host IP 172.21.0.2
.
But when I connect mysql. I get error:
My
docker-compose.yml
:version: '2' services: ### Mysql container mysql: image: mysql:latest ports: - "3306:3306" volumes: - /var/lib/mysql:/var/lib/mysql environment: MYSQL_ROOT_PASSWORD: root MYSQL_DATABASE: test_db MYSQL_USER: test MYSQL_PASSWORD: test_pass
Get my host IP
docker inspect db_mysql_1 | grep IPAddress
"IPAddress": "172.21.0.2",
Access mysql:
mysql -h 172.21.0.2 -P 3306 -u root -proot
.ERROR 1130 (HY000): Host '172.21.0.1' is not allowed to connect to this MySQL server
How can I connect to mysql container?