# Issue with connecting a MySql Docker DB to a local running Dremio docker instance

**URL:** <https://community.dremio.com/t/issue-with-connecting-a-mysql-docker-db-to-a-local-running-dremio-docker-instance/7407>\
**Category:** Uncategorized\
**Created:** [May 5, 2021, 8:20pm UTC](https://community.dremio.com/t/issue-with-connecting-a-mysql-docker-db-to-a-local-running-dremio-docker-instance/7407 "2021-05-05T20:20:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sam\_Sick](https://avatars.discourse-cdn.com/v4/letter/s/9d8465/32.png) [@Sam\_Sick](https://community.dremio.com/u/Sam_Sick)\
**Post date:** [May 5, 2021, 8:20pm UTC](https://community.dremio.com/t/issue-with-connecting-a-mysql-docker-db-to-a-local-running-dremio-docker-instance/7407/1 "2021-05-05T20:20:47Z")

</div>

Hi, I have a problem connecting my MySql database with Dremio. Both programs are running as Docker containers and are on the same network. For this I used the following YAML file:

\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<  
#test\docker-compose.yml

version: ‘3’

services:

mysql:

```
image: mysql

ports: 

  - "3306:3306"

  - "33060:33060"

environment: 

  MYSQL_ROOT_PASSWORD: admin

restart: always

```

dremio\_:

```
image: dremio/dremio-oss

ports:

  - "9047:9047"

  - "31010:31010"

  - "45678:45678"

links:

  - mysql:mysql

restart: always

```

\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<

Inside the Dremio container the ping command works on mysql. But I can’t connect to the database on the web interface. It always shows the following error:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/6/649a1c67c6d768115be5b77d71aeb8cb7459dbb3.png)

I am glad about any help!

Best regards

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [May 6, 2021, 6:59am UTC](https://community.dremio.com/t/issue-with-connecting-a-mysql-docker-db-to-a-local-running-dremio-docker-instance/7407/2 "2021-05-06T06:59:38Z")

</div>

@Sam_Sick There should be a detailed error message with a stack on the coordinator server.log, are you able to see what it says? or share the log with us?

---

<div class="post-metadata">

**Author:** ![Sam\_Sick](https://avatars.discourse-cdn.com/v4/letter/s/9d8465/32.png) [@Sam\_Sick](https://community.dremio.com/u/Sam_Sick)\
**Post date:** [May 7, 2021, 7:05am UTC](https://community.dremio.com/t/issue-with-connecting-a-mysql-docker-db-to-a-local-running-dremio-docker-instance/7407/4 "2021-05-07T07:05:58Z")

</div>

@balaji.ramaswamy Since my original reply was unfortunately rejected by the spam filter, I am posting the log again here:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/1/13d780b385f3bf31e24eecaa913418277093e7de.png)

---

<div class="post-metadata">

**Author:** ![Sam\_Sick](https://avatars.discourse-cdn.com/v4/letter/s/9d8465/32.png) [@Sam\_Sick](https://community.dremio.com/u/Sam_Sick)\
**Post date:** [May 7, 2021, 10:53am UTC](https://community.dremio.com/t/issue-with-connecting-a-mysql-docker-db-to-a-local-running-dremio-docker-instance/7407/5 "2021-05-07T10:53:53Z")

</div>

Alright I got a working connection to my MySQL Database with using following SQL-Command: ALTER USER ‘your\_dremio\_user’@‘ip\_address’ IDENTIFIED WITH mysql\_native\_password BY ‘new\_password’;