Cannot create new container mysql 8.0

[suandedev]

docker run --name db-1 --env MYSQL_ROOT_PASSWORD='password' mysql:8.0
2025-03-08 07:00:28+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.41-1.el9 started.
2025-03-08 07:00:28+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-03-08 07:00:28+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.41-1.el9 started.
2025-03-08 07:00:28+00:00 [Note] [Entrypoint]: Initializing database files
2025-03-08T07:00:28.804352Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2025-03-08T07:00:28.804702Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.41) initializing of server in progress as process 80
2025-03-08T07:00:28.818478Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-03-08T07:00:30.162416Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-03-08T07:00:33.175299Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2025-03-08 07:00:39+00:00 [Note] [Entrypoint]: Database files initialized
2025-03-08 07:00:39+00:00 [Note] [Entrypoint]: Starting temporary server
2025-03-08T07:00:40.149728Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2025-03-08T07:00:40.151311Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41) starting as process 124
2025-03-08T07:00:40.166619Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-03-08T07:00:40.575918Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-03-08T07:00:40.894771Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-03-08T07:00:40.894819Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-03-08T07:00:40.901709Z 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.
2025-03-08T07:00:40.923237Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2025-03-08T07:00:40.923721Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2025-03-08 07:00:40+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.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/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' 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.
ERROR 1064 (42000) at line 8: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1

[tianon]

I can't reproduce with your exact provided command: 😬

$ docker run --name db-1 --env MYSQL_ROOT_PASSWORD='password' mysql:8.0
Unable to find image 'mysql:8.0' locally
8.0: Pulling from library/mysql
43759093d4f6: Pull complete 
126d8d3809b3: Pull complete 
157a7408a55d: Pull complete 
c405af89949f: Pull complete 
c92147eb3382: Pull complete 
b3ec9882b976: Pull complete 
ad072341f26b: Pull complete 
bda7c2eca56f: Pull complete 
b6b5c46ac97d: Pull complete 
8cd34fa224e6: Pull complete 
b4144aa75def: Pull complete 
Digest: sha256:50b5ee0656a2caea76506fe702b1baddabe204cf3ab34c03752d2d7cd8ad83fc
Status: Downloaded newer image for mysql:8.0
2025-03-10 17:33:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.41-1.el9 started.
2025-03-10 17:33:12+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-03-10 17:33:12+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.41-1.el9 started.
2025-03-10 17:33:12+00:00 [Note] [Entrypoint]: Initializing database files
2025-03-10T17:33:12.208937Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2025-03-10T17:33:12.209006Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.41) initializing of server in progress as process 80
2025-03-10T17:33:12.218770Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-03-10T17:33:12.879589Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-03-10T17:33:14.091484Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2025-03-10 17:33:17+00:00 [Note] [Entrypoint]: Database files initialized
2025-03-10 17:33:17+00:00 [Note] [Entrypoint]: Starting temporary server
2025-03-10T17:33:17.763657Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2025-03-10T17:33:17.764284Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41) starting as process 124
2025-03-10T17:33:17.781431Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-03-10T17:33:18.013422Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-03-10T17:33:18.253064Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-03-10T17:33:18.253145Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-03-10T17:33:18.259174Z 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.
2025-03-10T17:33:18.298560Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2025-03-10T17:33:18.298645Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2025-03-10 17:33:18+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.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/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' 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.

2025-03-10 17:33:19+00:00 [Note] [Entrypoint]: Stopping temporary server
2025-03-10T17:33:19.602152Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.41).
2025-03-10T17:33:21.008625Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41)  MySQL Community Server - GPL.
2025-03-10 17:33:21+00:00 [Note] [Entrypoint]: Temporary server stopped

2025-03-10 17:33:21+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.

2025-03-10T17:33:21.805047Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2025-03-10T17:33:21.806083Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41) starting as process 1
2025-03-10T17:33:21.813788Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-03-10T17:33:21.999067Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-03-10T17:33:22.199464Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-03-10T17:33:22.199487Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-03-10T17:33:22.202219Z 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.
2025-03-10T17:33:22.218933Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-03-10T17:33:22.218980Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock

[LaurentGoderre]

The issue is with the MYSQL_ROOT_PASSWORD. I can reproduce if I quote around like this:

docker run --name db-1 --env MYSQL_ROOT_PASSWORD="'password'" mysql:8.0

So somehow, the single quotes are being passed to the command instead of delimiting the parameter

[LaurentGoderre]

Or perhaps you password has a quote that needs to be escaped. This also cause the error you get:

docker run --name db-1 --env MYSQL_ROOT_PASSWORD="pass'word" mysql:8.0

But this works:

docker run --name db-1 --env MYSQL_ROOT_PASSWORD="pass\'word" mysql:8.0

[tianon]

That's #776 👀