bryandunn.com Excelling in excellence since 2001

If you are one of the few people who subscribes to this blog you may have noticed all the duplicate posts today. This is due to my own idiocy. I screwed something up and had to restore from a backup (lost one week, but only a couple actual posts).

Also after upgrading to wordpress 2.5, I thought I’d convert all my categories to tags so I could have one of those bad-ass tag clouds. This was easy (from the wordpress admin menu):

Settings->Import->Convert Categories to Tags

This of course screwed up the Advanced Category Excluder as I now have no categories. Luckily, I found another plugin that does both categories and tags:

http://www.codehooligans.com/2008/04/27/simply-exclude-plugin/

This also affected my syndication, so I had to make edits to feedwordpress settings and change tags to categories.

Still to come - even though feedwordpress says it will create permalinks to the original article, they still point to this site. Thinking about disabling it, removing it from wp-content/plugins and removing all the rows associated with it in the wp_options table….

1. Get an MD5 hash of your password.
   • Visit MD5 Hasher (http://epleweb.com/md5/), or…
   • Create a key with Python. or…
   • On Unix: echo -n <password> | md5sum
2. “mysql -u root -p” (log in to MySQL)
3. enter your mysql password
4. “use (name-of-database)” (select WordPress database)
5. “show tables;” (you’re looking for a table name with “users” at the end)
6. “SELECT ID, user_login, user_pass FROM (name-of-table-you-found)” (this gives you an idea of what’s going on inside)
7. “UPDATE (name-of-table-you-found) SET user_pass=”(MD5-string-you-made)” WHERE ID = (id#-of-account-you-are-reseting-password-for)” (actually changes the password)
8. “SELECT ID, user_login, user_pass FROM (name-of-table-you-found)” (confirm that it was changed)
9. (type Control-D, to exit mysql client)

Note if you have a recent version of MySQL (version 5.x?) you can have MySQL compute the MD5 hash for you.

1. Skip step 1. above.
2. Do the following for step 7. instead.
   • “UPDATE (name-of-table-you-found) SET user_pass = MD5(’”(new-password)”‘) WHERE ID = (id#-of-account-you-are-reseting-password-for)” (actually changes the password)