Connecting to alpine-mariadb from another Docker container - arm32v7

[emmaparker96]

I want to access data of an alpine-mariadb from a Python script that is in another Docker container on a Raspberry Pi 2 (armhf/arm32v7).

After executing the command:
docker run -it --name mariadb -p 3306:3306 -v /var/lib/mysql:/var/lib/mysql -e MYSQL_DATABASE=mydb -e MYSQL_USER=root -e MYSQL_PASSWORD=password -e MYSQL_ROOT_PASSWORD=password yobasystems/alpine-mariadb:arm32v7
the following output arises:

[i] mysqld not found, creating....
[i] MySQL data directory not found, creating initial DBs
43516-01-16 16:49:34 0 [ERROR] This MySQL server doesn't support dates later than 2038
[i] Creating database: mydb
[i] with character set: 'utf8' and collation: 'utf8_general_ci'
[i] Creating user: root with password password
323662-03-12  5:39:11 0 [ERROR] This MySQL server doesn't support dates later than 2038
/scripts/run.sh: ignoring or entrypoint initdb empty /docker-entrypoint-initdb.d/*
MySQL init process done. Ready for start up.
exec /usr/bin/mysqld --user=mysql --console --skip-name-resolve --skip-networking=0

Unfortunately, I can't get a connection from Python to the database. Is Docker Compose needed for this?

[dominictayloruk]

See #53 (comment)

You now have yobasystems/alpine-mariadb:arm32v7

when it should be yobasystems/alpine-mariadb:10.5.9 or even yobasystems/alpine-mariadb:10.5.9-armhf

[dominictayloruk]

Also see here around the issue you have in your logs #47

This MySQL server doesn't support dates later than 2038

Thats why when you said you were running pi 2, i suggested the 10.5.9 image.