MySQL/MariaDB woes

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:

Share


Categories

Leave a Reply

Your email address will not be published. Required fields are marked *