不允许连接到此Mariadb Server Docker组成
我想在我的nodejs中与Mariadb建立连接。我的nodejs和mariadb在docker组成中构建,因为nodejs可以使用DNS访问公共,但对于Mariadb不能,它可以通过IP通过服务器访问。我总是会出现错误主机'172.19.0.2'不允许连接到此Mariadb Server Docker
任何人都可以帮助我如何连接到Mariadb。还是什么可能的Docker容器连接到服务器中的Localhost MariadB?
注意:编辑
这是我的docker-compose.yml
version: '3'
volumes:
mariadb:
driver: local
networks:
db:
driver: bridge
services:
mariadb:
image: mariadb:10.6
restart: always
environment:
MYSQL_ROOT_HOST: '%'
MYSQL_ROOT_PASSWORD: password
MYSQL_USER: admin1
MYSQL_PASSWORD: admin1
expose:
- "40000"
ports:
- "40000:3306"
volumes:
- mariadb:/var/lib/mysql
networks:
db:
phpmyadmin:
image: phpmyadmin
restart: always
expose:
- "40001"
ports:
- "40001:80"
environment:
- PMA_HOST=mariadb
- PMA_PORT=3306
networks:
db:
I want to create connection in my nodejs to mariadb. my nodejs and mariadb build in docker compose, for nodejs can access public with dns but for mariadb can not, it is can access via server with ip. I always get error Host '172.19.0.2' is not allowed to connect to this MariaDB server docker
can anyone help me how to connect to mariadb. Or what is possible docker container connect to localhost mariadb in server?
Note: edited
this is my docker-compose.yml
version: '3'
volumes:
mariadb:
driver: local
networks:
db:
driver: bridge
services:
mariadb:
image: mariadb:10.6
restart: always
environment:
MYSQL_ROOT_HOST: '%'
MYSQL_ROOT_PASSWORD: password
MYSQL_USER: admin1
MYSQL_PASSWORD: admin1
expose:
- "40000"
ports:
- "40000:3306"
volumes:
- mariadb:/var/lib/mysql
networks:
db:
phpmyadmin:
image: phpmyadmin
restart: always
expose:
- "40001"
ports:
- "40001:80"
environment:
- PMA_HOST=mariadb
- PMA_PORT=3306
networks:
db:
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论