mysqlcheck: Character set '' is not a compiled character set

[r-martins]

Bug Report

When running commands related to db at hostinger, I get the following error.

mysqlcheck: Character set '' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
Unsupported character set:

Hostinger support said it's a bug with the wp-cli, and my debug shows the same..
Describe the current, buggy behavior

When running wp db check in any of my wp installs at hostinger, I get the following:

$ wp db check
mysqlcheck: Character set '' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
Unsupported character set:

With debug...

$ wp db check --debug
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\DeclareAbstractBaseCommand (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\IncludeFrameworkAutoloader (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\ConfigureRunner (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\IncludeRequestsAutoloader (0.014s)
Debug (bootstrap): Setting RequestsLibrary::$version to v2 (0.014s)
Debug (bootstrap): Setting RequestsLibrary::$source to wp-core (0.014s)
Debug (bootstrap): Setting RequestsLibrary::$class_name to \WpOrg\Requests\Requests (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\InitializeColorization (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\InitializeLogger (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\DefineProtectedCommands (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\LoadExecCommand (0.014s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\LoadRequiredCommand (0.015s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\IncludePackageAutoloader (0.015s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\IncludeFallbackAutoloader (0.015s)
Debug (bootstrap): Fallback autoloader paths: phar://wp-cli.phar/vendor/autoload.php (0.015s)
Debug (bootstrap): Loading detected autoloader: phar://wp-cli.phar/vendor/autoload.php (0.015s)
Debug (bootstrap): Attaching command 'config edit' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config path' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config list' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config get' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config is-true' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config set' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config delete' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config has' to hook before_wp_load (0.022s)
Debug (bootstrap): Attaching command 'config shuffle-salts' to hook before_wp_load (0.022s)
Debug (commands): Adding command: config (0.022s)
Debug (bootstrap): Attaching command 'core download' to hook before_wp_load (0.024s)
Debug (bootstrap): Attaching command 'core version' to hook before_wp_load (0.024s)
Debug (commands): Adding command: core (0.024s)
Debug (bootstrap): Attaching command 'eval' to hook before_wp_load (0.024s)
Debug (commands): Adding command: eval (0.025s)
Debug (bootstrap): Attaching command 'eval-file' to hook before_wp_load (0.025s)
Debug (commands): Adding command: eval-file (0.025s)
Debug (commands): Adding command: cache (0.025s)
Debug (commands): Adding command: transient (0.026s)
Debug (bootstrap): Attaching command 'core verify-checksums' to hook before_wp_load (0.027s)
Debug (commands): Adding command: verify-checksums in core Namespace (0.027s)
Debug (commands): Adding command: plugin (0.027s)
Debug (commands): Adding command: verify-checksums in plugin Namespace (0.027s)
Debug (commands): Adding command: cron (0.028s)
Debug (commands): Adding command: event in cron Namespace (0.028s)
Debug (commands): Adding command: schedule in cron Namespace (0.028s)
Debug (bootstrap): Attaching command 'db' to hook after_wp_config_load (0.03s)
Debug (bootstrap): Attaching command 'db clean' to hook after_wp_load (0.031s)
Debug (bootstrap): Attaching command 'db tables' to hook after_wp_load (0.031s)
Debug (bootstrap): Attaching command 'db size' to hook after_wp_load (0.031s)
Debug (bootstrap): Attaching command 'db prefix' to hook after_wp_load (0.031s)
Debug (bootstrap): Attaching command 'db search' to hook after_wp_load (0.031s)
Debug (bootstrap): Attaching command 'db columns' to hook after_wp_load (0.031s)
Debug (commands): Adding command: db (0.032s)
Debug (commands): Adding command: embed (0.032s)
Debug (commands): Adding command: fetch in embed Namespace (0.032s)
Debug (commands): Adding command: provider in embed Namespace (0.033s)
Debug (commands): Adding command: handler in embed Namespace (0.033s)
Debug (commands): Adding command: cache in embed Namespace (0.033s)
Debug (commands): Adding command: comment (0.035s)
Debug (commands): Adding command: meta in comment Namespace (0.036s)
Debug (commands): Adding command: menu (0.037s)
Debug (commands): Adding command: item in menu Namespace (0.037s)
Debug (commands): Adding command: location in menu Namespace (0.038s)
Debug (commands): Deferring command: network meta (0.038s)
Debug (commands): Adding command: option (0.039s)
Debug (commands): Adding command: post (0.041s)
Debug (commands): Adding command: meta in post Namespace (0.041s)
Debug (commands): Adding command: term in post Namespace (0.042s)
Debug (commands): Adding command: post-type (0.043s)
Debug (commands): Adding command: site (0.044s)
Debug (commands): Adding command: meta in site Namespace (0.045s)
Debug (commands): Adding command: option in site Namespace (0.046s)
Debug (commands): Adding command: taxonomy (0.046s)
Debug (commands): Adding command: term (0.047s)
Debug (commands): Adding command: meta in term Namespace (0.048s)
Debug (commands): Adding command: user (0.05s)
Debug (commands): Adding command: application-password in user Namespace (0.051s)
Debug (commands): Adding command: meta in user Namespace (0.052s)
Debug (commands): Adding command: session in user Namespace (0.052s)
Debug (commands): Adding command: term in user Namespace (0.053s)
Debug (commands): Adding command: network (0.053s)
Debug (hooks): Processing hook "after_add_command:network" with 1 callbacks (0.053s)
Debug (hooks): On hook "after_add_command:network": Closure in file phar:///home/clairema/_tools/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 695 (0.053s)
Debug (commands): Adding command: meta in network Namespace (0.053s)
Debug (commands): Adding command: signup in user Namespace (0.054s)
Debug (commands): Adding command: export (0.055s)
Debug (commands): Adding command: plugin (0.059s)
Debug (commands): Adding command: auto-updates in plugin Namespace (0.06s)
Debug (commands): Adding command: theme (0.062s)
Debug (commands): Adding command: auto-updates in theme Namespace (0.062s)
Debug (commands): Adding command: mod in theme Namespace (0.063s)
Debug (bootstrap): Attaching command 'i18n' to hook before_wp_load (0.063s)
Debug (commands): Adding command: i18n (0.063s)
Debug (bootstrap): Attaching command 'i18n make-pot' to hook before_wp_load (0.064s)
Debug (commands): Adding command: make-pot in i18n Namespace (0.065s)
Debug (bootstrap): Attaching command 'i18n make-json' to hook before_wp_load (0.065s)
Debug (commands): Adding command: make-json in i18n Namespace (0.065s)
Debug (bootstrap): Attaching command 'i18n make-mo' to hook before_wp_load (0.066s)
Debug (commands): Adding command: make-mo in i18n Namespace (0.066s)
Debug (bootstrap): Attaching command 'i18n make-php' to hook before_wp_load (0.066s)
Debug (commands): Adding command: make-php in i18n Namespace (0.066s)
Debug (bootstrap): Attaching command 'i18n update-po' to hook before_wp_load (0.066s)
Debug (commands): Adding command: update-po in i18n Namespace (0.066s)
Debug (commands): Adding command: import (0.067s)
Debug (commands): Deferring command: language core (0.068s)
Debug (commands): Deferring command: language plugin (0.069s)
Debug (commands): Deferring command: language theme (0.07s)
Debug (hooks): Immediately invoking on passed hook "after_add_command:site": Closure in file phar:///home/clairema/_tools/wp-cli.phar/vendor/wp-cli/language-command/language-command.php at line 39 (0.07s)
Debug (commands): Adding command: switch-language in site Namespace (0.07s)
Debug (commands): Adding command: language (0.07s)
Debug (hooks): Processing hook "after_add_command:language" with 3 callbacks (0.07s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///home/clairema/_tools/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 695 (0.07s)
Debug (commands): Adding command: core in language Namespace (0.07s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///home/clairema/_tools/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 695 (0.07s)
Debug (commands): Adding command: plugin in language Namespace (0.071s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///home/clairema/_tools/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 695 (0.071s)
Debug (commands): Adding command: theme in language Namespace (0.071s)
Debug (bootstrap): Attaching command 'maintenance-mode' to hook after_wp_load (0.071s)
Debug (commands): Adding command: maintenance-mode (0.072s)
Debug (commands): Adding command: media (0.074s)
Debug (bootstrap): Attaching command 'package' to hook before_wp_load (0.076s)
Debug (commands): Adding command: package (0.076s)
Debug (commands): Adding command: rewrite (0.077s)
Debug (commands): Adding command: rewrite (0.077s)
Debug (commands): Adding command: cap (0.078s)
Debug (commands): Adding command: role (0.078s)
Debug (commands): Adding command: scaffold (0.08s)
Debug (commands): Adding command: search-replace (0.082s)
Debug (bootstrap): Attaching command 'server' to hook before_wp_load (0.083s)
Debug (commands): Adding command: server (0.083s)
Debug (commands): Adding command: shell (0.083s)
Debug (commands): Adding command: super-admin (0.084s)
Debug (commands): Adding command: widget (0.085s)
Debug (commands): Adding command: sidebar (0.085s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\RegisterFrameworkCommands (0.085s)
Debug (bootstrap): Adding framework command: phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/commands/cli.php (0.085s)
Debug (bootstrap): Attaching command 'cli' to hook before_wp_load (0.087s)
Debug (bootstrap): Attaching command 'cli has-command' to hook after_wp_load (0.088s)
Debug (commands): Adding command: cli (0.088s)
Debug (bootstrap): Attaching command 'cli cache' to hook before_wp_load (0.088s)
Debug (commands): Adding command: cache in cli Namespace (0.088s)
Debug (bootstrap): Attaching command 'cli alias' to hook before_wp_load (0.088s)
Debug (commands): Adding command: alias in cli Namespace (0.088s)
Debug (bootstrap): Adding framework command: phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/commands/help.php (0.088s)
Debug (commands): Adding command: help (0.089s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\RegisterDeferredCommands (0.089s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\InitializeContexts (0.089s)
Debug (bootstrap): Processing bootstrap step: WP_CLI\Bootstrap\LaunchRunner (0.09s)
Debug (bootstrap): No readable global config found (0.09s)
Debug (bootstrap): No project config found (0.09s)
Debug (bootstrap): argv: /home/clairema/_tools/wp-cli.phar db check --debug (0.09s)
Debug (bootstrap): ABSPATH defined: /home/clairema/wptmp-dev.ricardomartins.net.br/ (0.09s)
Debug (hooks): Executing hook: before_wp_load (0.09s)
Debug (context): Using context 'cli' (0.09s)
Debug (bootstrap): Begin WordPress load (0.091s)
Debug (bootstrap): wp-config.php path: /home/clairema/wptmp-dev.ricardomartins.net.br/wp-config.php (0.091s)
Debug (bootstrap): Looking for UTF-8 BOM (0.091s)
Debug (bootstrap): Looking for UTF-16 (BE) BOM (0.091s)
Debug (bootstrap): Looking for UTF-16 (LE) BOM (0.091s)
Debug (hooks): Executing hook: after_wp_config_load (0.091s)
Debug (hooks): Processing hook "before_run_command" with 1 callbacks (0.091s)
Debug (hooks): On hook "before_run_command": WP_CLI\Bootstrap\RegisterDeferredCommands->add_deferred_commands() (0.091s)
Debug (bootstrap): Running command: db check (0.091s)
Debug (db): Running shell command: /usr/bin/env mysqlcheck --no-defaults %s (0.097s)
Debug (db): Final MySQL command: /usr/bin/env mysqlcheck --no-defaults --host= --user= --default-character-set= --check (0.097s)
mysqlcheck: Character set '' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
Unsupported character set:

It seems the mysqlcheck and other mysql commands do not add the correct parameters from wp-config in it.

In wp-config.php the default-character-set is defined.

/** Database charset to use in creating database tables. */
define( 'DB_CHARSET', 'utf8mb4' );

/** The database collate type. Don't change this if in doubt. */
define( 'DB_COLLATE', 'utf8mb4_unicode_ci' );

(I tried with other charsets and collations)

Running mysqlcheck manually would work.

/usr/bin/env mysqlcheck --host=localhost --user=MYSQLUSER MYSQLDB -p
Enter password: XXX
clairema_alicesenamartins_blog.wp_commentmeta OK
clairema_alicesenamartins_blog.wp_comments OK
clairema_alicesenamartins_blog.wp_cptch_images OK
clairema_alicesenamartins_blog.wp_cptch_packages OK
clairema_alicesenamartins_blog.wp_cptch_whitelist OK
clairema_alicesenamartins_blog.wp_links OK
clairema_alicesenamartins_blog.wp_options OK
clairema_alicesenamartins_blog.wp_postmeta OK
clairema_alicesenamartins_blog.wp_posts OK
clairema_alicesenamartins_blog.wp_term_relationships OK
clairema_alicesenamartins_blog.wp_term_taxonomy OK
clairema_alicesenamartins_blog.wp_termmeta OK
clairema_alicesenamartins_blog.wp_terms OK
clairema_alicesenamartins_blog.wp_usermeta OK
clairema_alicesenamartins_blog.wp_users OK