Create MySQL Database and User – the proper way

I read so much bullshit about how to create a mysql user and database, in most cases it’s not just inefficient but also wrong.

So here is the best and most efficient way to create a MySQL database and user with password:

Done.

No FLUSH PRIVILEGES.
No create user, then database then give user access then update password.
Just those 2 lines. Nothing more.

Youtube is going DOWN

Today I received an email from Youtube

[Channel Name],
Today we are announcing changes to the YouTube Partner Program (YPP). While our goal remains to keep the YPP open to as many channels as possible, we recognize we need more safeguards in place to protect creator revenue across the YouTube ecosystem.

What’s Changing
Under the new eligibility requirements announced today, your YouTube channel, [Channel Name], is no longer eligible for monetization because it doesn’t meet the new threshold of 4,000 hours of watchtime within the past 12 months and 1,000 subscribers. As a result, your channel will lose access to all monetization tools and features associated with the YouTube Partner Program on February 20, 2018 unless you surpass this threshold in the next 30 days. Accordingly, this email serves as 30 days notice that your YouTube Partner Program terms are terminated.
One of YouTube’s core values is to provide anyone the opportunity to earn money from a thriving channel. Creators who haven’t yet reached this new threshold can continue to benefit from our Creator Academy, our Help Center, and all the resources on the Creator Site to grow their channels. Once your channel reaches the new threshold, it will be reviewed to make sure it adheres to our policies and guidelines, and if so, monetization will be re-enabled.

The main reason to upload to Youtube was monetization. Google, or rather Alphabet is turning more evil each day.
So now you need 4000 hours over 12 months watched and 1000 subscribers.
Yeah “down with the little folk” Alphabet is now part of the mob the ruling elite.
They do whatever they want and fuck the little guy who made them what they are.
Disgusting evil bastards.

I vouch for “Don’t support Alphabet, don’t give them your material for free. Delete your videos if they’re not being monetized and show Alphabet/Youtube who’s boss. It’s not them, it’s you”

2 days later Google has removed any news about this incident from their news search. “If people believe that no one knows about it, nothing will happen, right?”

What happend to “being inclusive”? Don’t they have that lawsuit on their hand because some white guy got mobbed because he’s white? And now this?

fail2ban memento on CentOS 7

Quick memento on how to configure fail2ban on CentOS 7

That’s all folks

Golang IDE: Why I moved from Jetbrains to Microsoft

You see I’m pretty pissed about Jetbrains. First they turn the buy to own model into a subscription model,
then they develop a Go IDE. But what that’s good, right?
Yeah in theory that’s awesome, if only it didn’t cost the world.

But let me start from the beginning.
I use Webstorm because I do a lot of HTML/CSS/JS editing (let’s not get nitpicky and add ecmascript typescript etc).
Some guy named dlsniper on Github aka Florin Patan then started writing a Go plugin for the non-commercial Jetbrains IntelliJ.
People thought it was a good idea and opened an issue on Jetbrains’ bugtracker. They wanted a Golang IDE.
I supported this. In fact I also added various suggestions for improvement, which were adopted.
For a while life was good, the plugin took shape. I could use the plugin in Webstorm and soon it become my main IDE.
I could do HTML/CSS/JS and Go. Good stuff. And all in 1 IDE.
Then management (or whoever) decided it was time to release and one Webstorm IDE upgrade to the next the Go plugin stopped working. That was in Webstorm 2017.3 .
But I found a solution which involved changing some values in the Go plugin acquired from Jetbrains. Lo and behold, what previously didn’t work, now worked.
And I posted about it and what do you know Jetbrains releases what is essentially a version bump (which could also be worked around).
So now I’m a paying customer of Webstorm, which btw almost doubled in price since the subscription model was introduced, but I can’t use the latest Webstorm and neither do I have to. Because, you see, there is Microsoft and Visual Studio Code.
Visual Studio Code does EVERYTHING Webstorm with the Go plugin does and more + it doesn’t cost anything.

Add to that, that this dlsniper when called out on his bullshit just happily continued spewing marketing babble and trying to sell a subscription to people. Fuck you dlsniper. You’re an asshole.

TL;DR: Use Visual Studio Code and save some money while having the same features and more than you would have with Webstorm and Goland (that’s Jetbrains’ stupid name for their IDE, which costs 200€ / year).

Can anyone elaborate on why I would pay 289€ each year to have less features than with a free VS Code download and plugins?