Newburgh Brewing

Carmelo Santana

Independent Consultant

Carmelo Santana

Male
35 years old
Hudson Valley, New York
United States

Mood: Missing 🌮
View My: Pics | Videos


MySQL/MariaDB woes
February 14, 2020

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;

… but that didn’t work ether.

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. Hope this helps someone.Sources:

Sources:

©2020 Carmelo Santana. All Rights Reserved.