Revisiting old tutorials, updates, keep your eyes peeled

Revisiting old tutorials, updates, keep your eyes peeled

Hi all! It’s been a while, way over a year since my last post. I’ve certainly been busy, but new plugins are on the horizon. I’m moving the site to a new Raspberry Pi 2, and will be writing new LAMP tutorials as part of this. Sorry it’s been so long!

I run another site with a good friend, Sam Evans (hook up with him on Twitter) called LiveReview. I’m looking into the feasibility of moving Raspbian into the tech section of our rebuilt site that’s coming soon. This part of the site will be of course, hosted from a Raspberry Pi. It will be the ultimate test for the trusty Raspberry Pi because the traffic will be huge!

More to come soon!
Ste

Reset WordPress password from the database

It’s easily done, we forget the password for a WordPress account, or get asked by a client to reset it. What happens if you don’t have access to the email account for that user?

You may just want to reset it without having to use the ‘forgotten password’ link where you then have to log into email accounts and then change it from a randomly generated one. If you have access to the database, there’s a simple way to do this. Read on to learn how to reset WordPress password from the database.

Reset WordPress password using a MySQL command

In this example, I am going to assume that you are resetting the main Admin password (usually ID 1). Double check this first, and always use a secure password. Assuming the user ID is 1 and the new password is ‘nUp@ssw0rd’, run:

UPDATE wp_users u SET u.`user_pass` = md5('nUp@ssw0rd') WHERE u.`ID` = 1

WordPress uses a function called md5 which creates the hash for a given input so passwords aren’t stored in plaintext. Any comments or questions, sound them below.

Further reading

And the new name for DingleBerry Pi is…

And the new name for DingleBerry Pi is…

Not too long ago, I decided to change the name of the site as the name ‘Dingleberry Pi’ was a little tongue in cheek, and I never anticipated the growth of users following my tutorial. I asked you, the community to come up with some names, and I’ve been really pleased and extremely grateful for the response.

(more…)

ISP Woes

ISP Woes

Due to ongoing issues with my ISP, the site has been moved to a conventional Ubuntu web server. I’ll be running the site from my Raspberry Pi as soon as possible.

Help me choose a name, win a Raspberry Pi bundle

Help me choose a name, win a Raspberry Pi bundle

So, in the UK, a Dingleberry is a stupid or inept person. In America, it’s something a bit more horrific. When I started this blog, I never imagined it would have gained the reach and audience it has, so the time has come to change the name. In order to grow the site further and to be taken a bit more seriously, the name ‘Dingleberry Pi’ has to go!

(more…)

Nginx on Raspberry Pi

Dingleberry Pi now powered by Nginx

To coincide with my three part tutorial, the site is now powered by Nginx instead of Apache2 on a Raspberry Pi web server – and the results speak for themselves. I’ve observed a 10% increase in speed for queries, and a 42% increase in homepage load. Pingdom tools has also marked an improvement, with the site being quicker than 88% of sites tested, up from the previous 72%.

(more…)