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:

Open source journalism

We recently started a discussion on stream on what open source journalism might look like for as us developers. We also discussed some implications and use cases for both readers and journalists. Here’s a quick breakdown of our initial chat on 2/6/2020.

I plan on editing this post as we continue to grow this idea as a community. If you have any feedback or would like to follow along join the stream Tuesdays and Thursdays 10am-4pm.

Initial punch list (Last edited 2/6/2020)

☐ Source an origin
    Content from same location or time stamps
☐ Allowing people to submit sources, articles already posted online
    ☐ Archiving original posts + revisions
☐ Determine mood and sentiment from comments
☐ Source similar or related information  
☐ Read more on what problems journalist currently face
☐ Tech stack
    ☐  admin.site.com for data submission and processing
    ☐  website itself will be pre-generated and stored on:
        ☐ distributed servers
            ☐ block chain
        ☐ object store like s3 or Linode
        ☐ tor
☐ Goals/Priorities 
    ☐ 1. Develop trust
    ☐ Verification
        ☐ Make sure a human is actually posting the external content
        Keybase
        Location
        Source
    ☐ Distinction between verified and unverified authors
        ☐ Look for patterns
            Comments
            Photos/video posted
            Other content posted by this author on other platforms, if any

Sorry for the poor formatting. This theme needs some serious attention, just hasn’t been a priority. Will begin fixing in the coming weeks.

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