Posted on

Howto: Installing MySQL on macOS with root password reset

Following the recent macOS Mojave update I figured I should update MySQL 5.7.16 to 8.0.something, too. This didn’t work out because of the impossible security hash introduced with it. None of my tools are compatible with it apparently.

After some frustrations and loosing all my databases (Migration/Upgrading also didn’t work) I went back to 5.7. The latest version of MySQL 5.7 is 5.7.24. Easy enough, right? Wrong…
It took me a few hours to figure out. But here is my “first launch” setup guide.

After the installation is complete the MySQL manual sort of tells you you’re done and good luck. What it doesn’t mention however is that the temporary password you get is expired before you even use it. You get your password and as far as I can tell their Password Reset instruction is lacking completeness, too.

Read more »

Posted on

6 ways to a faster and safer WordPress

Having a WordPress website is often great, but it also makes you vulnerable for all kinds of attacks and mischief – Or maybe not vulnerable, but it invites many wrong doers to try and attack you. You’re an easy target. Let’s make it a bit less easy for them without using plugins!

Recently I’ve been plagued on another website by slowness, the occasional downtime and other annoying stuff. Paying more attention to usage stats and the error_log it turns out there was a bunch of stuff going on. A few of IP Addresses constantly tried something with wp-login.php and some other pages and files being loaded over and over again for no apparent reason.

Another issue was the RSS feed WordPress generates. Sure, it works fine. But if you get almost 10000+ requests on it per hour, that’ll slow things down, too. Sometimes.

So I did some research and have come up with a few things to try and prevent this kind of behavior. Of-course it’s no use blocking IP addresses but you can prevent access to things or if they access those things lessen the load on your server a great deal.

Read more »

Posted on

The ultimate development environment for Mac OS X

Updated: December 26, 2018

I’ve pieced together what I think is the ultimate development setup. This tutorial is particularly useful if you’re working in different places and have to rely on public wifi or if you don’t have high speed internet available.

As you may have read I’ve moved to the Philippines. This means I no longer have a home address for a while. This also means that high speed internet becomes a luxury. To not being hindered in developing things like AdRotate and other plugins I needed a fast and reliable alternative for my online development server. So that even if internet is wonky, I can still do some work.

Read more »