Carmelo Santana

Independent Consultant

  • Male
  • 35 years old
  • Hudson Valley, New York

Mood: Mindful 🌠

View my:

Interests
General
On a path of spiritual healing 🌒 and deep learning 🤖
GamesPath of Exile, Rise of Kingdoms 🌽, Satisfactory, Nu****, Elder Scrolls Online = 💩
Music
  • Work: Brain.fm
  • Easy Listening: Wang Xu-Dong, o k h o, Saito, Canti, Feign, Brothel, Trashlord, foxwedding, Harukasuka, SLIGHT, Kamandi, Baths, Bonobo, Bloc Party, Coconut Records, Yeah Yeah Yeahs, Phoenix, M83, The Drums, Deerhunter, Toro Y Moi, Passion Pit, Bombay Bicycle Club, Neon Indian
  • Weekends: Drake, Cardi B, Doja Cat, Childish Gambino, Danny Brown, Earl Sweatshirt, A$AP Rocky, B.I.G, D.I.T.C, Wu-Tang, Fugees, Necro, Ariana Grande, Megan Thee Stallion
  • Metal of sorts: Berried Alive, Angel Vivaldi, Deftones, The Tony Danza Tapdance Extravaganza, Liferuiner, Emmure, Misery Signals, Chelsea Grin, For The Fallen Dreams, Erra, Northlane, Dream On Dreamer, Molotov Solution, Vanna, Rings of Saturn
MoviesDie Hard 3, The Birdcage, Birdman, The Godfather, Goodfellas, A Bronx Tale, Scarface, Working Girl, Burn After Reading, Dope, Arrival, Outbreak, Get Out, Pretty Woman
Streaming
  • Stranger Things, Glow, The End of The F**cking World, Narcos, Orange Is the New Black, Ozark, Unbreakable Kimmy Schmidt, High Maintenance, Insecure, Veep, Vice, Westworld
  • Oldies: Boardwalk Empire, Rome, Silicone Valley (first few seasons), The Sopranos, House of Cards (rip)
BooksAngels & Demons, Hua Hu Ching: The Unknown Teachings of Lao Tzu, When Will Jesus Bring The Pork Chops?, Yak Butter Blues, ACT on Life not on Anger
HeroesMy mother and Edward Snowden
Details
Status
Here forSharing code and experiences
HometownNewburgh, NY
EthnicityPuerto Rican
Zodiac♒ Aquarius
EducationMostly self taught, always experimenting and learning.
OccupationSelf employed

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:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.