Mysql container errors, socket creation erros

Question

I am trying to run a MySQL container using containerd; whenever I try to run it, it throws the following error?

Errors are, socket setup and failure to create a lock file. My host doesn't have a SQL server installed though.

Using the official MySQL latest image from docker hub. Using ctr to manage the containerd. What changes are needed in the configuration to eradicate this error?

ctr run  --mount type=bind,src=$PWD,dst=/context,options=rbind:ro --env MYSQL_ROOT_PASSWORD=test123 docker.io/library/mysql:latest sql1

2020-12-08 15:46:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.
2020-12-08 15:46:14+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2020-12-08 15:46:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.
2020-12-08 15:46:14+00:00 [Note] [Entrypoint]: Initializing database files
2020-12-08T15:46:14.251822Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
2020-12-08T15:46:14.251830Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
2020-12-08T15:46:14.252208Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.22) initializing of server in progress as process 44
2020-12-08T15:46:14.259095Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-12-08T15:46:14.524966Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-12-08T15:46:15.826735Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-12-08 15:46:19+00:00 [Note] [Entrypoint]: Database files initialized
2020-12-08 15:46:19+00:00 [Note] [Entrypoint]: Starting temporary server
2020-12-08T15:46:19.249242Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
2020-12-08T15:46:19.249251Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
2020-12-08T15:46:19.491977Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 89
2020-12-08T15:46:19.508069Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-12-08T15:46:19.674786Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-12-08T15:46:19.795249Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2020-12-08T15:46:19.795450Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2020-12-08T15:46:19.955656Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-12-08T15:46:19.955904Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-12-08T15:46:19.956779Z 0 [ERROR] [MY-010273] [Server] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2020-12-08T15:46:19.957008Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2020-12-08T15:46:19.957498Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-12-08T15:46:19.957730Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
2020-12-08 15:46:19+00:00 [ERROR] [Entrypoint]: Unable to start server.

Answer 1

In /etc/mysql/my.cnf on the line that starts with sql_mode =, try removing NO_AUTO_CREATE_USER, save the file and restart the container.

Answer 2

I had the same errors when I tried to start a mysql container using Containerd. I ended up creating "/var/run/mysqld/" on the host, and mounting it.

mkdir /var/run/mysqld
useradd -m mysql
chown mysql:mysql /var/run/mysqld

Still had the errors until permissions were changed to 777?

chmod 777 /var/run/mysqld


ctr --debug run --mount type=bind,src=/var/run/mysqld,dst=/var/run/mysqld,options=rbind:rw --env MYSQL_DATABASE=testdb --env MYSQL_ROOT_PASSWORD=foo --net-host docker.io/library/mysql:latest mysqldb