Archived Notes

source The only reason you should edit your wp-config.php is if you have recently updated your database password. If you're using using godaddy, click "My Account" then "launch" your web host. click the large button that says "FTP* File Manager" edit "Page Size: 25" to "Page size: 50" and find wp-config.php, make sure you don't select wp-config-sample.php click the edit button.  Set Database Password Replace yourpasswordhere , with the your password, e.g. MyPassWord . define('DB_PASSWORD', ' MyPassWord' ); // Example MySQL password Now you can go back and use phpMyAdmin to edit your wordpress database the complete guide is Delete all Comments from wordpress hosted on godaddy

You probably got here from To Reset Your MySQL Database Password Log in to your Account Manager. Click Web Hosting . Next to the hosting account you want to use, click Launch . In the Databases section of the Hosting Control Center, click the MySQL icon. Click the pencil icon next to the database you would like to change the password for to open its edit features. Click the Password icon in the menu bar. In the Update Password window, enter the new password you would like to use in the Enter New Password and Confirm New Password fields. Click OK The password for the selected database will take up to one hour to change. Use this new password to log into the Database Manager of this database. NOTE: If you use a MySQL-based application, such as WordPress, you must update your connection strings to use the new password. how to delete all comments from wordpress on godaddy

This is one step in helping you delete comments on wordpress. I'll try to make a master guide. source To Manage Your Databases Using phpMyAdmin Log in to your Account Manager. Click Web Hosting . Next to the hosting account you want to use, click Launch . In the Databases section of the Hosting Control Center, click MySQL . Click Manage via phpMyAdmin for the database you want to manage with phpMyAdmin. Enter your user name and password. The user name is the same as the database name. TIP: If you don't know your password, see Resetting Your MySQL Database Password for information about changing it. Click Go . When you're inside your MySQL database,  delete all comments from wordpress .

So far i have not seen any good plugins to delete old comments.  My website thatmusicblog.com was on autopilot for a year without akismet and racked up literally 484,000 comments. I was not going to go through deleting them 20 at a time, and all the plugins i tried just didn't work. After reading about myPHPadmin, i was slightly scared to log into the backend and send a script to the mySQL database.  Its easier than it sounds. log into godaddy launch hosting control center and select databases > mySQL If you know your database password, skip to #2. if you don't, continue if you don't know your username and password, you'll have to change it. IF YOU CHANGE IT, you must also go into the FTP file manager and tell wordpress you've changed your password, i'll explain how below. click the pencil on the far right, next to "Manage via phpMyAdmin" click the password button on top nav put in a new password. you must remember...