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.
Sources:
- https://solidfoundationwebdev.com/blog/posts/how-to-fix-mysql-error-1524-hy000-plugin-auth_socket-is-not-loaded-in-mysql-5-7
- https://linuxize.com/post/how-to-reset-a-mysql-root-password/
- http://www.nazmulhuda.info/error-1372-hy000-password-hash-should-be-a-41-digit-hexadecimal-number
- https://askubuntu.com/questions/640899/how-do-i-uninstall-mysql-completely