#5285 MariaDB user password

[hiider]

Webmin version 1.920
Operating system Debian Linux 10
Kernel and CPU Linux 4.19.0-5-amd64 on x86_64
mysql Ver 15.1 Distrib 10.3.15-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Servers -> MySQL Database Server -> User Permissions -> Create new user
Fill username and password, click on Create user
Output:

Failed to save user : SQL set password for 'test1'@'%' = 'g%d*%5jyLu}m' failed : Password hash should be a 41-digit hexadecimal number

[hiider]

Also same when setting user new password:
Failed to save user : SQL set password for 'test1'@'%' = 'test' failed : Password hash should be a 41-digit hexadecimal number

[Jamie Cameron]

This should be fixed once we release Virtualmin 6.07

[Stephane Brault]

Go to Webmin > Servers > MySQL and click the "Settings" button with a gear at the top. Set "Password hashing mode" to "Old".

[Jamie Cameron]

Also, Webmin 1.930 will fix this .

[Torrentu]

Does not work with Go to Webmin > Servers > MySQL Database Server and click the "Module Config" button with a gear at the top. Set "Password hashing mode" to "Old". or with Default
Webmin version 1.930
MySQL version 10.2.27-MariaDB
Operating system CentOS Linux 7.6.1810
Error:
Failed to save user : SQL set password for 'test'@'%' = 'test123' failed : Password hash should be a 41-digit hexadecimal number

[Attila Kovacs]

Can confirm. 1.930, set to Default,
xy has a password in the old format; please change the password to the new format

in save_user.cgi :

            if ($variant eq "mysql" &&
                  &compare_version_numbers($ver, "8") >= 0 ||
                $variant eq "mariadb" &&
                  &compare_version_numbers($ver, "10.2") >= 0) {
                    &execute_sql_logged($master_db,
                            "set password for '".$user."'\@'".$host."' = ".
                            "'$esc'");
                    }

the if evaluates to true and sets the password as plaintext.
(mariadb 10.3.18)

[Robert Foley]

I've got Webmin 1.8.4.1 installed on Ubuntu 19.10 running MariaDB 10.3.2.2-MariaDB-0ubuntu0.12.10.1

I've gone into Webmin > Servers > MySQL -> Settings and set the Password Hashing mode to "Old".

Saved Settings and attempted to create a new user.

Failed to save user : SQL set password for 'test'@'%' = 'test' failed : Password hash should be a 41-digit hexadecimal number.

So, perhaps it didn't save the settings?