Recently had some issues with a fresh MariaDB install. After installation I was unable to create a new user. After testing a few things I realized I also had issues changing the root password.
I eventually was hit with the error message:
ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
After numerous searches the most common answer lead me to try the following:
SET old_passwords = 0;
After that failed I eventually gave up with MariaDB, uninstalled and tried to install MySQL. That also didn’t go as smoothly as I had hoped. First there were old files left behind. After a few more searches I ended up running a few commands to completely uninstall MariaDB.
Now with the fresh install of MySQL I go ahead and try to create a new user, to then be faced with this new error:
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded.
This was easy enough to fix. After logging into mysql via terminal. I ran the following commands:
use mysql; update user set plugin="mysql_native_password"; flush privileges;
Sadly this ended up taking a couple days to fully resolve. Luckily it was on a development machine, but still work is work.