I was trying to create a password for a new user on a new install of webmin. I was trying out the latest everything, latest MySQL (MariaDB 10), PHP 7.3, Kernel 5.0.2.12 running on Centos 7. But for some reason, when adding a new SQL user, I kept getting: failed :
Password hash should be a 41-digit hexadecimal number
What I had to do was enter the hash of the password into the new user script. To get the hash, all you have to do it go to command line, enter:
mysql -u root -h localhost -p
Then enter your passwords, and enter your password you want to kick back the hash on:
SELECT PASSWORD(‘mypass’);
Which will kick out:
6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4
Poof, now you can enter that as your password via your gui, or as an SQL command:
If you would like to read more about it, check here:
https://dev.mysql.com/doc/refman/5.6/en/password-hashing.html