Fedora 31 Workstation
I am running mysql in a container using podman. After some experimenting I got it running with this command:
podman run --detach --userns=keep-id \ --security-opt label=disable \ --name=mysql \ --env="MYSQL_ROOT_PASSWORD=mysql" --publish 3306:3306 \ --volume=/home/simon/servers/mysql/var/lib/mysql:/var/lib/mysql mysql:8.0 \ --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci \ --lower_case_table_names=1
The bits that took time to research were: --userns=keep-id - which maps my user to the same uid in the container --security-opt label=disable - which disables SELinux in the container (dev machine so OK)
I could then connect to the database using the mysql client:
mysql -u root -p -h 127.0.0.1 -P 3306
Now, after a dnf upgrade this has stopped working and I get an error message:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
The container is running and appears to be healthy. I've tried recreating the container and reinitialising the database (by deleting all the files).
[simon@hedgehog ~]$ podman ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES d7ee24d35a93 docker.io/library/mysql:8.0 --character-s 12 minutes ago Up 12 minutes ago 0.0.0.0:3306->3306/tcp mysql
Podman was updated during the upgrade, as was the kernel and a bunch of other stuff.
simon@hedgehog ~]$ dnf history info 70 | grep podman Upgrade podman-2:1.8.0-2.fc31.x86_64 @updates Upgraded podman-2:1.7.0-2.fc31.x86_64 @@System Upgrade podman-plugins-2:1.8.0-2.fc31.x86_64 @updates Upgraded podman-plugins-2:1.7.0-2.fc31.x86_64 @@System
Does anyone have any idea how I can get this working again? Or any clues as to how I should go about investigating further?
Thanks,
Simon