Connection refused when connecting with Metabase to a MySQL database

Get Help
1

I try to connect to a local MySQL database called time_series with metabase but when I connect I get the following error.

Database name: Could not connect to address=(host=127.0.0.1)(port=3306)(type=master) : Socket fail to connect to host:127.0.0.1, port:3306. Connection refused (Connection refused)

The user doesn't have password

However that is a known problem until it appears that the MariaDB connector, used by Metabase, is currently not compatible with MySQL 8.

So I tried the command they propose:

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '';

But it sends back:

Error Code: 1396. Operation ALTER USER failed for 'root'@'%'
2

How are you connecting Metabase to MySQL? can you provide more info about that? Metabase is perfectly compatible with MySQL 8. E.g. try this docker-compose

version: '3.9'
services:
  metabase-mysql:
    image: metabase/metabase-enterprise:v1.43.4
    container_name: metabase-mysql
    hostname: metabase-mysql
    volumes: 
    - /dev/urandom:/dev/random:ro
    ports:
      - 3000:3000
    environment: 
      MB_DB_DBNAME: "metabase"
      MB_DB_PORT: "3306"
      MB_DB_USER: "metabase"
      MB_DB_PASS: "mysecretpassword"
      MB_DB_HOST: "mysql"
      MB_DB_TYPE: "mysql"
    networks: 
      - metanet1-mysql
  mysql-app-db:
    image: mysql:8.0.29
    container_name: mysql
    hostname: mysql
    ports: 
      - 3306:3306
    environment:
      - "MYSQL_ROOT_PASSWORD=mysecretpassword"
      - "MYSQL_USER=metabase"
      - "MYSQL_PASSWORD=mysecretpassword"
      - "MYSQL_DATABASE=metabase"
    volumes:
      - $PWD/mysql-data:/var/lib/mysql
    command: ['--default-authentication-plugin=mysql_native_password', '--mysqlx=0']
    networks: 
      - metanet1-mysql
networks: 
  metanet1-mysql:
    driver: bridge
3

Sure @Luiggi Here is my very simple configuration to connect Metabase to MySQL:

image
image819×818 27 KB

I just tried with your docker-compose.yml file (which I had to change the port from 3306:3306 to 3366:3306) but I still have the same error: Connection refused.

4

127.0.0.1 is the localhost. If the Metabase App and the database are not running in the same host that won't work. Also, MySQL needs to listen to connections if that hasn't already been configured.

The docker-compose I sent is to connect Metabase with MySQL as the application database, not as a normal data warehouse connection. Also, consider than in my docker-compose file the containers create their own network, so you'll need to make the connections on their own network, so if you need to add the app db as a new data connection in Docker then the host is "mysql" (this is the hostname inside the docker network), the port is "3306" and the user is "metabase" and password "mysecretpassword".

Running Metabase as a JAR file and running in Docker has different considerations, you need to know how the networking works on each

5

Okay, I figured it out and managed to connect to the default metabase by putting "metabase" in the database to reach. Thank you @Luiggi !

I am now looking to upload my csv data that I already had in my MySQL database accessible by MySQL WorkBench outside of the network data created by docker-compose.yml. I guess I need to connect to the MySQL database created by docker compose and upload my csv file to it. Do you know how I can do this?

6

Why can't you connect from Metabase to the server you have the data on? you don't need to move the data

7

I tried, but I still have the same error:

image
image801×835 31.1 KB

8

when you type 127.0.0.1 inside a docker container, you're referring to the docker container itself, you don't have a database running inside that docker container, you have Metabase.

If the database is running on the HOST which is hosting the docker container, then you need to change the networking mode from bridge to host https://docs.docker.com/network/host/.

It would be easier if instead of running a container, you run the JAR