To disable comments on posts older than date X in WordPress you can use the snippet below. Sample mySQL

To delete all unapproved comments in WordPress you can use the following snippet. Sample mySQL

To remove any post that is older than X days in WordPress you can use the query below. Sample mySQL

To disable or enable Trackbacks and Pingbacks in WordPress you can use the following mysql queries. Sample mySQL enable disable

To identify unused tags in WordPress you can use the following snippet.

To change user password in WordPress using MySql you can use the following query. Sample MySql

To delete all pingbacks in WordPress you can use the mysql query below.