Being Locked Out From My Own Blog

I was trying to log into my blog control panel and all of sudden this screen showed up:

Ashrufzz 403 Page

At first I thought my office IP address was being blocked. So I thought, maybe I’ll try and access it from home and see if my home IP address can get through. Then I said to myself, “How come I am using my new found proxy server technique but still I can’t access my own blog?”, “There must be something wrong here!”. So, using my new HTTP-Tunnelling proxy technique accessing through another web-based proxy called Guardster, I still cannot get into my blog control panel. Now this is ridiculous!

I suspect that there might be something wrong with my plugin, so I immediately went to Bad Behavior plugin blog. There it is, a download solution to my login problem. Now comes the most challenging part, replacing the plugin with the new updated one. My FTP was not working because there is a connection problem where the directory can’t be retrieved. I had to do it using my web hosting control panel file manager and replace the files manually one by one. It took me longer than I thought because the download files were not being in the order as the previous plugin.

Luckily, I still managed to log into my blog eventually. Frustrated, I decided to disable the Bad Behavior plugin once and for all. It’s a shame though because this plugin is good to prevent blogging spam. Without this plugin, I predict my Akismet spam plugin could easily reach thousands with the amount of traffic I received nowadays. I should have hacked into my WordPress database and disable this plugin but I don’t want to mess around with it since I haven’t done my back up yet.

I can’t imagine someone who doesn’t have the necessary skill of repairing a WordPress blog enduring this problem. Being blocked out from your own blog can drive you NUTS! I hope that this incident won’t happen again in the future.

How To Recover Your WordPress Login

Over the past few weeks, I’ve been fiddling with a lot of stuff on WordPress. It seems like the mechanical stuff I’ve learned really helped me a lot in determining how to fix something. Recently I’ve stumbled upon a lot of problem regarding the access to the WordPress login. One of them is the lost and forgotten username and password. If you handle or own a lot of your self hosted WordPress blogs, you might come across this accessing difficulties once in a while and I have a solution for that.

To be able to recover your WordPress login, here is two things you need to know before you even attempt to perform this recovering task:

  • You must have the master login to your webhosting or at least must be able to access phpMyAdmin.
  • You must know how to backup your WordPress MySQL blog database.

If you don’t know how to deal with the above list, try Google them or download WAMP, XAMPP or WOS and fiddle around with them on your Localhost before you proceed on your live blog. Okay, let’s move on. Download your WordPress MySQL database in .sql format (you can download it on whatever format you want but I like to stick with .sql). Use your favourite text editor. I use my Dreamweaver to do the job.

After you open the sql file, don’t bother about reading all the mumbo jumbo codes unless you like to. Use your Search and Replace function and search for ‘user_login’. This is very useful if your WP SQL file is big. I’ll give you a peek of how the codes look like:

Peek inside your SQL raw data

As you can see, I’ve colour coded the values that is involved and how it is related. The code above is an example of a multi-user wordpress blog. If you only have one user, there will be only one user information. Once you know what to edit, get rid of those old password circled in red. WordPress login uses MD5 to jumble the password so that it is not easily hacked. We now use md5 Hash Generator to get a new code for our new password.

Once we have replaced the new password generated by the md5 Hash Generator, it’s now time to upload the database back to it’s place. Make sure you have make a back up before you do this or else don’t blame me if something goes wrong. Test your WordPress blog and see if it runs okay or not. After you done that, try and access your WordPress Admin area and if that doesn’t work, maybe you’ve changed the wrong user login or keep on trying. There are a lot of other stuff you can do if you know how to edit your WordPress MySQL database. I’ll write about it when I’m in the mood. If you need help, place your questions on my comment box below and I’ll see what I can help.

Further reading: WordPress FAQ