Unable to create a running container for mysql:latest image from Docker Hub

Nithiwat Seesillapachai 1 Reputation point
2020-11-07T07:50:30.33+00:00

Hi all, would like to ask for help. I am attempting to run mysql:latest image on Azure Container Instance. I am not modifying anything and simply pulling the image from the public docker registry. However, my container fails to start. I would kindly appreciate any help - I am a beginner here.

This is my log file.

2020-11-07T07:04:33.4337194Z stdout F 2020-11-07 07:04:33+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.
2020-11-07T07:04:34.7798102Z stdout F 2020-11-07 07:04:34+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2020-11-07T07:04:34.8456502Z stdout F 2020-11-07 07:04:34+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.
2020-11-07T07:04:35.0436526Z stdout F 2020-11-07 07:04:35+00:00 [Note] [Entrypoint]: Initializing database files
2020-11-07T07:04:35.0726607Z stderr F 2020-11-07T07:04:35.063272Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.22) initializing of server in progress as process 58
2020-11-07T07:04:35.0786634Z stderr F 2020-11-07T07:04:35.078265Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-11-07T07:04:41.0615116Z stderr F 2020-11-07T07:04:41.060330Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-11-07T07:04:51.4010834Z stderr F 2020-11-07T07:04:51.400467Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-11-07T07:05:05.9620773Z stdout F 2020-11-07 07:05:05+00:00 [Note] [Entrypoint]: Database files initialized
2020-11-07T07:05:05.9680781Z stdout F 2020-11-07 07:05:05+00:00 [Note] [Entrypoint]: Starting temporary server
2020-11-07T07:05:08.0906378Z stderr F 2020-11-07T07:05:07.906911Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 111
2020-11-07T07:05:08.1057849Z stderr F 2020-11-07T07:05:08.104710Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-11-07T07:05:10.6780964Z stderr F 2020-11-07T07:05:10.677224Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-11-07T07:05:11.387311Z stderr F 2020-11-07T07:05:11.383185Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2020-11-07T07:05:11.387311Z stderr F 2020-11-07T07:05:11.383404Z 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-11-07T07:05:12.8113614Z stderr F 2020-11-07T07:05:12.809852Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-11-07T07:05:12.8113614Z stderr F 2020-11-07T07:05:12.810338Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-11-07T07:05:12.8123665Z stderr F 2020-11-07T07:05:12.811672Z 0 [ERROR] [MY-010273] [Server] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2020-11-07T07:05:12.8123665Z stderr F 2020-11-07T07:05:12.811860Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2020-11-07T07:05:12.8133625Z stderr F 2020-11-07T07:05:12.812828Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-11-07T07:05:12.8133625Z stderr F 2020-11-07T07:05:12.813485Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
2020-11-07T07:05:12.8402361Z stderr F 2020-11-07 07:05:12+00:00 [ERROR] [Entrypoint]: Unable to start server.
Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
672 questions
{count} votes

1 answer

Sort by: Most helpful
  1. prmanhas-MSFT 17,901 Reputation points Microsoft Employee
    2020-11-16T08:37:29.52+00:00

    @Nithiwat Seesillapachai Thank you for your patience!!!

    Below is the response I got from our Product Team:

    MySQL needs some basic environment variables too in place of simply pulling the image. You can refer to below article for more information:

    https://hub.docker.com/_/mysql?tab=description

    Also you can check below somehow similar (different DB) topic/example which might be helpful in your use case:

    https://www.mssqltips.com/sqlservertip/6180/create-azure-container-instances-for-sql-server/

    Hope it helps!!!

    Please "Accept as Answer" if it helped so it can help other in community looking for help on similar topics.

    Note : There are few articles in the mentioned answer which are not the official documentation from Microsoft side, so we can't confirm on the working of components as mentioned in the article.We have just tried to provide you the information which can be helpful to you with the current issue you are facing and help you in resolving the same.