docker-compose mysql immediately stops after running

[GregNing]

2020-04-22 03:34:07+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.19-1debian10 started.
2020-04-22 03:34:07+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2020-04-22 03:34:07+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.19-1debian10 started.
2020-04-22 03:34:07+00:00 [Note] [Entrypoint]: Initializing database files
2020-04-22T03:34:08.009082Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2020-04-22T03:34:08.009208Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.19) initializing of server in progress as process 43
2020-04-22T03:34:14.464010Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-04-22 03:34:22+00:00 [Note] [Entrypoint]: Database files initialized
2020-04-22 03:34:22+00:00 [Note] [Entrypoint]: Starting temporary server
2020-04-22T03:34:22.611082Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2020-04-22T03:34:22.611299Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 93
2020-04-22T03:34:24.138900Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-22T03:34:24.175510Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2020-04-22T03:34:24.241138Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.19'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2020-04-22 03:34:24+00:00 [Note] [Entrypoint]: Temporary server started.
2020-04-22T03:34:24.373771Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2020-04-22 03:34:30+00:00 [Note] [Entrypoint]: Creating database review_development

2020-04-22 03:34:30+00:00 [Note] [Entrypoint]: Stopping temporary server
2020-04-22T03:34:30.362242Z 11 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.19).
2020-04-22T03:34:32.411635Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.
2020-04-22 03:34:33+00:00 [Note] [Entrypoint]: Temporary server stopped

2020-04-22 03:34:33+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.

2020-04-22T03:34:33.693389Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2020-04-22T03:34:33.693589Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 1
2020-04-22T03:34:34.389951Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-22T03:34:34.398477Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2020-04-22T03:34:34.443717Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.19'  socket: '/var/run/mysqld/mysqld.sock'  port

And then the docker run is finished. Any thoughts?

[wglambert]

[Entrypoint]: Temporary server stopped: this is the temporary server the container is initialized with that has stopped

These notices mean the container is fully initialized and ready
[Entrypoint]: MySQL init process done. Ready for start up.
[System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections.

[GregNing]

@wglambert thanks !

[scspijker]

What is the correct health check to prevent your scripts to connect to the temporary server?

[GregNing]

Hi @scspijker,
I reference this

[tianon]

See also https://github.com/docker-library/healthcheck/blob/40afbf64d69cf933af0da4df6383958a29113601/mysql/docker-healthcheck (which explicitly uses TCP either to the external IP address of the container or 127.0.0.1 to avoid the temporary server).

[MobCode100]

(which explicitly uses TCP either to the external IP address of the container or 127.0.0.1 to avoid the temporary server).

Based on this comment and also this answer, my healthcheck is:

    healthcheck:
        test: ["CMD", "mysqladmin", "ping", "-p$$MYSQL_ROOT_PASSWORD","--protocol","tcp"]

because temporary server skips networking so no TCP port is open.