The WP Guru

How to install MySQL on Mac OS X El Capitan

November 11, 2015November 2, 2015 by Jay Versluis

MySQL 2015

There are several ways to install MySQL on your Mac, for example:

compile from source
use the Homebrew package manager (http://brew.sh)
use a nifty script courtesy of Mac Mini Vault (http://git.io/eUx7rg)
or use the dedicated MySQL installer package (recommended)

I recommend the dedicated installer because it’s the only package that will also add a convenient Preference Pane for starting and stopping the service.

In this article I’ll focus on the latter, and I’ll also talk you through how to add MySQL to the PATH variable and how to secure MySQL to keep the evildoers away from your server.

These instructions will work on Yosemite and El Capitan (I’ve tested it on both systems – in fact that’s part of why I’m writing this, so that I can remember for next time).

Screen Shot 2015-11-02 at 10.40.12

How to disable SSH access from everywhere except for certain IPs in CentOS 7

November 3, 2015November 2, 2015 by Jay Versluis

Here’s how to do it: firewall-cmd –zone=internal –add-service=ssh –permanent firewall-cmd –zone=internal –add-source=1.2.3.4/32 –permanent firewall-cmd –zone=internal –add-source=5.6.7.8/32 –permanent firewall-cmd –zone=public –remove-service=ssh –permanent firewall-cmd –reload This declares an internal zone with two IPs (add as many or as few as you like) and subsequently removes the SSH service from the public zone altogether. As a result, any … Read more

Apache: How to block all other IPs except for your own

October 4, 2015 by Jay Versluis

Sometimes I have to work on WordPress sites that are too busy to display the admin interface. This can happen if there’s more traffic than the server can cope with. In such cases, we may need to tell every visitor to come back later while we carry out some maintenance. But how? Thanks to an … Read more

How to move the sidebar to the right in TwentyFifteen

October 4, 2015 by Jay Versluis

I’ve never liked themes with sidebars on the left – probably because we in the western world start reading on the left, and I’d like there to be as little clutter as possible. Or perhaps I’m used to navigation items on the right. I was looking around for solutions to move the sidebar in Automattic’s … Read more

WordPress 111: Users, Roles and Capabilities

September 14, 2018September 28, 2015 by Jay Versluis

In this video I’ll show you the multi-user capabilities of WordPress: how to create new users, and what capabilities the different user roles have over your WordPress site. This feature comes in handy if you collaborate with other users: each user can create posts, but such users can be restricted from deleting other people’s posts, … Read more

WordPress 110: URLs and Permalinks

September 14, 2018September 21, 2015 by Jay Versluis

In this episode I’ll explain how you can change the URLs for your posts and pages, as they appear in your web browser. By default, WordPress uses numeric links (such as domain.com?p=123) but those are not so easy on the eye. We can change this to something like domain.com/awesome-post instead, and I’ll explain how to … Read more

How to prevent instant logout trouble with WP eMember

September 18, 2015 by Jay Versluis

I’ve been having issues with the otherwise excellent WP eMember Plugin by Tips and Tricks HQ: while members are logged in, they are often logged out as soon as they click a link. Thankfully I’m not alone with this problem – and it’s easy to fix: In the admin interface, head over to WP eMember … Read more

WordPress 109: Mysteries of the MORE Tag

September 14, 2018September 14, 2015 by Jay Versluis

In this episode I’ll show you how the MORE tag works. It’s a “break mark” you can use so that longer posts don’t take up too much space on your front page. I’m also explaining a related feature called the NEXTPAGE tag with which you can break even longer posts into individual pages. You can … Read more

Latest Articles