[MDEV-22974] SHOW CREATE USER generates invalid SQL - Jira

XML

Word

Printable

MariaDB [(none)]> show create user;

+---------------------------------------------------------------------------------------------------+

| CREATE USER for dan@localhost                                                                     |

+---------------------------------------------------------------------------------------------------+

| CREATE USER `dan`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket |

+---------------------------------------------------------------------------------------------------+

1 row in set (0.000 sec)

MariaDB [(none)]>  CREATE USER `dan2`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket

    -> ;

ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number

Is "invalid" something that should be literally accepted for compatibility?

To not do so means programs and humans that use SHOW CREATE USER output needs to parse out this text and remove it.

relates to

MDEV-24207 recognise mysql forms of invalid password for mysql_native_password

links to

pr 1628

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.