Posts tagged as:

mysql

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 →

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 →

Transferring Databases via SSH Command Line

February 13, 2010
Thumbnail image for Transferring Databases via SSH Command Line

SSH commands for moving a database from one server to another.

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 →