Cannot connect with MySQL Workbench but can connect from shell with mysql command line client
Taken from https://askubuntu.com/questions/773446/unable-to-connect-via-mysql-workbench-to-localhost-in-ubuntu-16-04-passwordless/781136#781136 for my own reference:
The issue is likely due to socket authentication being enabled for the root user by default when no password is set, during the upgrade to 16.04. This important caveat is documented in the 16.04 release notes:Password behaviour when the MySQL root password is empty has changed. Packaging now enables socket authentication when the MySQL root password is empty. This means that a non-root user can’t log in as the MySQL root user with an empty password.
For whatever reason, the MySQL Workbench that came with 16.04 doesn’t work out of the box with MySQL server, at least for me. I tried using “Local Socket/Pipe” to connect in a number of different ways but to no avail.
The solution is to revert back to native password authentication. You can do this by logging in to MySQL using socket authentication by doing:
sudo mysql -u rootOnce logged in:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';which will revert back to the native (old default) password authentication. If you’ve attempted some other method to fix the issue, you’ll want to make sure the “plugin” field in mysql.user is set to “auth_token”, which may require using mysqld_safe to log in to MySQL in the event you’ve been tinketing with things, like I did.
Credit to Miguel Nieto’s blog post for this solution.
Review of Kindle Unlimited Sci-Fi and Fantasy Books with Audible Narration
This is an ongoing review of books available with Audible Narration in the Kindle Unlimited subscription program. I’ve been an Audible customer for several years and greatly enjoy the selection but it’s too easy to burn through a credit each month when a good book is located. With Kindle Unlimited there is no monthly credit limit but the selection is more refined and I find it hard to locate desirable books. Below is a review of my favorite (and not so favorite) Sci-Fi and Fantasy books.
My Favorite Books
Frontlines by Marko Kloos – 6 Book Series
The books kept coming up as a recommendation but I kept putting them off thinking them to be a starship troopers genre space warfare series but I was pleasantly surprised to be disappointed. There were several good twists along the 6 book series and the level of detail was enough to be satisfying but not so much as to be boring. The story kept moving forward for a very satisfying listen.
The Origin Mystery by A. G. Riddle – 3 Book Series
If you like Clive Cussler style stories with adventure, mystery, and pseudo-history you’ll enjoy this. It’s a little slow to start with some seemingly unrelated events but as the story progresses it weaves into an epic science fiction adventure. It’s an easy listen with plenty of interesting plot points without going overboard on inane detail.
Fight and Flight (Magic 2.0 Book 4) by Scott Meyer
I had listened to the other books in this series and was pleased to continue listening to the series without wasting an audible credit. I started to get a little tired of the series since it didn’t seem that the universe established by the book was fully realized. The characters enter into interesting and funny situations and there were more than a few laughs but I always thought the premise of the book could lead to even more interesting adventures. Regardless of my opinion, it’s an interesting and fun listen.
The Elven (The Saga of the Elven Book Series) by Bernhard Hennen
This book is epic. If you like the Lord of the Rings books you’ll like this fantasy universe of elves, trolls, magic, and adventures that stretch time. While the universe reminds me a lot of Lord of the Rings the writing style is contemporary and easy to follow providing enough details to build a rich multi-layer story without going through superfluous narratives. The audio narration is very well done and the story will leave you satisfied in unexpected ways.
Childhood’s End (Arthur C. Clarke Collection)
Wow, just, wow. I’ve seen a lot of sci-fi and while the first part of this book reminded me of a Twilight Zone episode the unique ideas are captivating. While the content may seem dated by today’s standards the story stands the test of time. I had previously listened to The Collected Stories of Arthur C. Clarke and absolutely loved all of the original and unique sci-fi ideas. This book didn’t disappoint and it was exciting to see a story so completely thought out and finished.
Books I Enjoyed
The Hobbit (Lord of the Rings by J.R.R Tolkien
Finding the audible version of this was a pleasant surprise. It’s an entertaining listen and interesting story but a little slow at times.
A Fire Beneath the Skin by Victor Gischler
This series doesn’t waste any time getting into the main story without wasting time while adding details about the world in just the right amounts. I found the fantasy concepts to be interesting and the story moved forward at a decent pace keeping my attention. Some of the plot points and themes are more mature and might come across as stereotypical (secret romances, brothels, wizard battles, pirates) but the universe tries to be unique yet relatable as to not lose the reader in details
Books that I’m Undecided On
The Kingfountain Series Book by Jeff Wheeler
I didn’t really give this a fair chance but the plot and beginning just didn’t grip me and came across as stereotypical. I might give this another try since I didn’t make it more than an hour or so into the book.
The Hundreth Queen Series by Emily R. King
Similar to the Kingsfountain book I had trouble getting interesting in the plot and it seemed a bit stereotypical. I don’t think I gave the book a fair chance before getting bored and moving on.
Atopia Series by Matthew Mather
I really wanted to like this and made it more than halfway through the first book but between jumping around the different and seemingly disparate characters I got lost and confused. This is hard science fiction that explores some interesting ideas about the future and was very interesting but I just couldn’t get into it.
Books I Didn’t Like
The Evermen Saga by James Maxwell – 4 Book Series
After about 2 hours of listening, I decided to move on. The book was well written but slow moving with too much detail to take in. There are some interesting points that I liked but in the end, it didn’t hold my interest to finish.
The Endarian Prophecy by Richard Phillips
The book started out interesting and kept my attention for about 4 hours but seemed to get bogged down in pointless details that didn’t keep the plot moving forward so I gave up and moved along.
The Fracture Worlds Book by Adam Burch
I wanted to like this book but it was hard science fiction and while the environments tried to be unique and the characters interesting I found everything somehow ordinary and didn’t get hooked on the plot line. I only listened to 5 hours of the first book before giving up.
