How to Delete All Comments From Wordpress hosted on Godaddy using myPHPadmin

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

1. If you know your database password, skip to #2. if you don't, continue
1. 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.
2. click the pencil on the far right, next to "Manage via phpMyAdmin"
3. click the password button on top nav
4. put in a new password. you must remember this password and put it into the wp-config.php file.
5. hover over content, right click "FTP file manager" and "open in new window"
6. change the "page size:25" to "page size: 50"
7. scroll down until you see "wp-config.php", click it and select "EDIT" on the top nav bar
8. THIS FILE IS VERY IMPORTANT, DON'T FUCK THIS UP...
9. press ctrl +f to bring up the find function and type the word 'password' without quotes
1. here you will see a line: define('DB_PASSWORD', 'old_password');
2. update 'old_password' with the new password you created. make sure quotes are included on the file. 
3. if you changed anything else, you fucked up. 
4. click the little "save" icon on top left.
2. Select Manage via phpMyAdmin
3. Login with username password
4. click the SQL icon to enter code, it will bring up a new window.

1. Below are 3 different ways to edit your comments. 
2. After each query it will update another window, and it will say "xyz fields updated in abc seconds"
3. You can refresh your website comments section to see if changes are happening.
4. Here are different commands you could enter:

SQL Command to Delete all Pending Comments In Wordpress:
Code: delete from wp_comments WHERE comment_approved ="0";

SQL Command to Delete all Approved Comments in Wordpress:
Code: delete from wp_comments WHERE comment_approved ="1";

SQL Command to Delete ALL Comments In Wordpress:
Code: delete from wp_comments;