Category Archives: Technical

How to reset Joomla and WordPress passwords

Joomla

Using any MySQL admin tool, (PHPMyAdmin), run the following query, entering your own choice of password:

UPDATE jos_users SET password = MD5("new-password") WHERE  jos_users.username = "admin"; 

If you’re using a different username to admin, change as appropriate.

If this doesn’t work, try changing jos_users to mos_users.

WordPress

If you know your username and the email account in your profile, you can use the “lost password” function –

If you can’t use this method, here’s how to do it in MySQL.

Using any MySQL admin tool, (PHPMyAdmin), run the following query, entering your own choice of password.

UPDATE wp_users SET user_pass = MD5("new-password") WHERE wp_users.user_login = "admin";

Notes: You must have access to your database. If you don’t, pass these instructions on to someone that does.

Telehouse West Progress

The construction of the newest central london datacentre, Telehouse West, is well underway.

We don’t have to visit  the datacentre very frequently, but when we do we’ve been taking the odd photo of the construction work. As you can see, the progress of the build has been impressively fast.

telehouse-west-progress

Once complete, this datacentre will be one of the Greenest around. Waste heat (and there’s a lot of that in a datacentre)  from the $180 million Telehouse colocation facility will be used in a district heat network for the local Docklands community. It also features solar cells on the roof to help with the massive electricity costs.

They have provided a live feed from two webcams so you can watch diggers and cranes all day if you want.

Installing PHP on IIS

The fastest and easiest way to install PHP on IIS is using Microsoft’s Web Platform installer. It completely automates setting up IIS, FastCGI and the latest version of PHP from the php.net site. To install it, just click this button:

Web Platform Installer
Web Platform Installer

Also included in the installer are ready packaged popular web applications currently including:

Drupal, DotNetNuke, Photo Gallery, Wiki, SilverStripe CMS, Umbraco and WordPress.

Now we just need Microsoft to add MySQL and we’re sorted!