From the category archives:

WordPress

Manually Adding an Admin User to a WP Database

April 13, 2010
Thumbnail image for Manually Adding an Admin User to a WP Database

Lost your admin password? Need in to the WP admin but client hasn’t given you access? If you can access the database directly–easiest using a tool like PHPmyAdmin, you can give yourself whatever access you need.

Read the full article →

WP Auto Updates for Servers Requiring 777 Permissions

April 2, 2010
Thumbnail image for WP Auto Updates for Servers Requiring 777 Permissions

How to avoid WP and plugin update errors like “cannot copy file” or “cannot move file” or “cannot remove old plugin” and eliminate need to provide FTP info on each update for server configuraitons requiring 0777 writable permissions.

Read the full article →

Disabling WordPress Plugins When You Cannot Access Admin Area

March 10, 2010
Thumbnail image for Disabling WordPress Plugins When You Cannot Access Admin Area

How to disable all WP plugins when you can’t access the site’s admin area.

Read the full article →

SQL: Closing Comments on WordPress Installation

February 22, 2010
Thumbnail image for SQL: Closing Comments on WordPress Installation

mySQL command for closing all comments and pingbacks in WordPress installation; handy for closing comments on old server during hosting move. This also allows clients to easily check domain resolution.

Read the full article →

Mass Delete Pending Spam Comments from WordPress Database

January 26, 2010
Thumbnail image for Mass Delete Pending Spam Comments from WordPress Database

Quick how-to on mass deletion of Spam in WordPress database via SQL statement. Take back your blog!

Read the full article →

Moving WordPress Installation to New Domain – SQL

December 31, 2009
Thumbnail image for Moving WordPress Installation to New Domain – SQL

Moving WP to a new domain? Beyond just moving the files, you’ll need to make a couple key database changes to make your new installation work properly.

Read the full article →