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

1

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
image841×857 29.4 KB

I am glad about any help!

Best regards

2

@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?

4

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

image
image1917×1090 366 KB

5

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’;