[bitnami/mysql] 11.1.20 Startup probe failed: mysqladmin: [Warning] Using a password on the command line interface can be insecure. mysqladmin: connect to server at 'localhost' failed

[serhiynovos]

Name and Version

bitnami/mysql 11.1.20

What architecture are you using?

amd64

What steps will reproduce the bug?

1. Install helm chart 10.3.0 version. Then update to 11.1.20

Are you using any custom parameters or values?

  architecture: standalone
  auth:
    database: myuser
    username: myuser
  primary:
    resources:
      requests:
        cpu: 100m
        memory: 512Mi
      limits:
        cpu: 4
        memory: 1024Mi

What is the expected behavior?

App should in ready state

What do you see instead?

I see in logs mysql is ready to accept connection but probe is failed with error

Startup probe failed: mysqladmin: [Warning] Using a password on the command line interface can be insecure. mysqladmin: connect to server at 'localhost' failed

Additional information

Here is logs from 11.1.20

 mysql 21:20:10.65 INFO  ==>                                                                                                                                                                                                                       │
│ mysql 21:20:10.66 INFO  ==> Welcome to the Bitnami mysql container                                                                                                                                                                                │
│ mysql 21:20:10.66 INFO  ==> Subscribe to project updates by watching https://github.com/bitnami/containers                                                                                                                                        │
│ mysql 21:20:10.66 INFO  ==> Submit issues and feature requests at https://github.com/bitnami/containers/issues                                                                                                                                    │
│ mysql 21:20:10.66 INFO  ==> Upgrade to Tanzu Application Catalog for production environments to access custom-configured and pre-packaged software components. Gain enhanced features, including Software Bill of Materials (SBOM), CVE scan resu │
│ mysql 21:20:10.66 INFO  ==>                                                                                                                                                                                                                       │
│ mysql 21:20:10.67 INFO  ==> ** Starting MySQL setup **                                                                                                                                                                                            │
│ mysql 21:20:10.69 INFO  ==> Validating settings in MYSQL_*/MARIADB_* env vars                                                                                                                                                                     │
│ mysql 21:20:10.70 INFO  ==> Initializing mysql database                                                                                                                                                                                           │
│ mysql 21:20:10.71 WARN  ==> The mysql configuration file '/opt/bitnami/mysql/conf/my.cnf' is not writable. Configurations based on environment variables will not be applied for this file.                                                       │
│ mysql 21:20:10.71 INFO  ==> Using persisted data                                                                                                                                                                                                  │
│ mysql 21:20:10.72 INFO  ==> Running mysql_upgrade                                                                                                                                                                                                 │
│ mysql 21:20:10.73 INFO  ==> Starting mysql in background                                                                                                                                                                                          │
│ 2024-11-30T21:20:10.754819Z 0 [System] [MY-015015] [Server] MySQL Server - start.                                                                                                                                                                 │
│ 2024-11-30T21:20:11.055849Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.4.3) starting as process 38                                                                                                                   │
│ 2024-11-30T21:20:11.059093Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to  │
│ 2024-11-30T21:20:11.064169Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.                                                                                                                                                    │
│ 2024-11-30T21:20:11.341202Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.                                                                                                                                                      │
│ 2024-11-30T21:20:11.613188Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.                                                                                                                                                │
│ 2024-11-30T21:20:11.613226Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.                                                                               │
│ 2024-11-30T21:20:11.617903Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/opt/bitnami/mysql/tmp' in the path is accessible to all OS users. Consider choosing a different directory.                         │
│ 2024-11-30T21:20:11.643505Z 0 [System] [MY-010931] [Server] /opt/bitnami/mysql/bin/mysqld: ready for connections. Version: '8.4.3'  socket: '/opt/bitnami/mysql/tmp/mysql.sock'  port: 3306  Source distribution.                                 │
│ find: '/docker-entrypoint-startdb.d/': No such file or directory                                                                                                                                                                                  │
│ mysql 21:20:12.74 INFO  ==> Stopping mysql                                                                                                                                                                                                        │
│ 2024-11-30T21:20:12.748701Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.4.3).                                                                                                 │
│ 2024-11-30T21:20:14.012846Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld: Shutdown complete (mysqld 8.4.3)  Source distribution.                                                                                                 │
│ 2024-11-30T21:20:14.012877Z 0 [System] [MY-015016] [Server] MySQL Server - end.                                                                                                                                                                   │
│ mysql 21:20:14.76 INFO  ==> ** MySQL setup finished! **                                                                                                                                                                                           │
│                                                                                                                                                                                                                                                   │
│ mysql 21:20:14.79 INFO  ==> ** Starting MySQL **                                                                                                                                                                                                  │
│ 2024-11-30T21:20:14.814566Z 0 [System] [MY-015015] [Server] MySQL Server - start.                                                                                                                                                                 │
│ 2024-11-30T21:20:15.098886Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.4.3) starting as process 1                                                                                                                    │
│ 2024-11-30T21:20:15.102217Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to  │
│ 2024-11-30T21:20:15.107734Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.                                                                                                                                                    │
│ 2024-11-30T21:20:15.371545Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.                                                                                                                                                      │
│ 2024-11-30T21:20:15.610602Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.                                                                                                                                                │
│ 2024-11-30T21:20:15.610649Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.                                                                               │
│ 2024-11-30T21:20:15.615134Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/opt/bitnami/mysql/tmp' in the path is accessible to all OS users. Consider choosing a different directory.                         │
│ 2024-11-30T21:20:15.639114Z 0 [System] [MY-010931] [Server] /opt/bitnami/mysql/bin/mysqld: ready for connections. Version: '8.4.3'  socket: '/opt/bitnami/mysql/tmp/mysql.sock'  port: 3306  Source distribution.                                 │
│                                                                                                                                                                                                                              

[serhiynovos]

If I add mysql_native_password=ON config file directly to configmap it starts working fine

[serhiynovos]

As I understand here is the issue that my users still use mysql_native_password and I have to migrate them caching_sha2_password. Right ?