How to change your MySQL User Password

Today I had to admit that I did not remember the password for a MySQL user account. Since it’s saved in encrypted form simply reading it out won’t mean I can recover it. A Google search did eventually bring up the correct way of doing it, however it took me quite some time – so here’s how you can do this:

Read more

How to bring back Post Categories in P2

We’re all excited about the new features in Automattic’s P2 Theme v1.4.0 – however many of us have setup custom tweaks around Post Categories. In the latest version these have been replaced with Post Formats.

Post Formats are great, but they are limited to values defined in the WordPress core. If you wanted to create a new post menu like “critical” or “alarm” this wouldn’t work. We could use Custom Post Types to add to those formats, however it’s way too big an operation for I wanted to achieve: which is bringing back the “posting into categories” feature we’ve come to love from the previous version.

In this article I’ll show you how to back-port categories so posts will appear as they did in P2 v1.3.3 while retaining all functions of the latest update.

Read more

P2 Theme gets an upgrade: say hello to Custom Menus and To-Do List Support

Today P2 Version 1.4.0 has been released – hurra! Thanks for everyone’s hard work on this amazing theme.

P2 now boasts a couple of extra options and plenty of changes under the hood, but like many other great features those are not immediately obvious. Let me show you how the new changes work and how they can make your P2 experience even better.

Read more

How to show your Linux Version

Sometimes you’re working on a system and you’re not entirely sure which Linux distribution it is. There are several ways to find out what you’re working with and I keep forgetting what they commands are to get there – so here’s a quick list for all of us. Release and Distribution Most systems (but not … Read more

How to use vi to edit files in Linux

Here’s a brief reminder on how you can edit files with vi directly from the command line. Text is all you get, no other visual clues or menus are included, and best of all you need to know each keyboard shortcut once you’ve entered it.

vi is an old editor going back all the way to 1976. It’s not the most comfortable one, but the beauty is that it’s available on pretty much every distribution. There are several other common editors out there, but it’s not always an option to install those just for a quick file edit.

In this article I’ll show you the most commonly used commands and shortcuts, help you delete old versions of a file and show you a couple of links to more in-depth sources.

I assume here that you are comfortable using the command line interface (CLI).

Read more

How to use SFTP with Plesk 10.4.4

We had a discussion recently about using SFTP under Plesk 10. It’s possible, however the feature is not called SFTP explicitly so I thought it’s best to describe how it works here.

Note that SFTP is only possible for the main domain owner, not for additional FTP Users that you may create under Web Users… sorry! Here’s the Parallels Knowledgebase article which explains why.

That said, here’s how you activate SFTP for your account:

Read more