Remote mysql docker access

1

How can i access mysql/mariadb in docker installatiom production mode

2 
docker exec -it <mariadb-container-name> bash

Then enter into Mariadb shell using root password

mysql -uroot -p
3

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2 “No such file or directory”)

i got this error

4

Are you inside the container?

5

ok i managed to access the mysql in SSH, but i want to access the tables with mysql workbench, how do i change bind adress to bind_address = 0.0.0.0 so i can access the database public

6

publish port 3306 in the docker-compose.yml file where mariadb service is created.

services:
  ...
  mariadb:
    ...
    ports:
      - 3306:3306

Once that is done, you can access mariadb on docker host on port 3306

1 Like
7

Where can i find the folder for that file thanks

8

I don’t know.

there are multiple places.

If you used the single bench then it’s in the frappe_docker/docker-compose.yml file

If you used multi bench then it’s in frappe_docker/installation/docker-compose-common.yml

9 
>  mariadb:
>     image: mariadb:10.3
>     restart: on-failure
>     environment:
>       - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
>     volumes:
>       - ./installation/frappe-mariadb.cnf:/etc/mysql/conf.d/frappe.cnf
>       - mariadb-vol:/var/lib/mysql

Will i publish it in this area ?

10

Yes.

docker-compose docs Compose file version 3 reference | Docker Documentation

11 
mariadb:
    image: mariadb:10.3
    restart: on-failure
    environment:
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
    volumes:
      - ./installation/frappe-mariadb.cnf:/etc/mysql/conf.d/frappe.cnf
      - mariadb-vol:/var/lib/mysql
 services:
  ...
  mariadb:
    ...
    ports:
      - 3306:3306

Can you check if this right ?

12

I fear I can’t help you.

mariadb:
    image: mariadb:10.3
    restart: on-failure
    environment:
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
    volumes:
      - ./installation/frappe-mariadb.cnf:/etc/mysql/conf.d/frappe.cnf
      - mariadb-vol:/var/lib/mysql
    ports:
      - 3306:3306

You haven’t even mentioned Linux, Windows or Mac,
By looking at your cli I think you must use Windows or Mac. I don’t use windows

13

Ok i think i got right now, will i need to restart the server ? or

14 
docker ps

this should show the running containers and the published ports.

I found this by searching, check if it helps, Connecting MariaDB docker instance from MySQL workbench

15

Thanks it worked :slight_smile: