Skip to main content

Using phpMyAdmin to Manage Mysql databases

This is one step in helping you delete comments on wordpress. I'll try to make a master guide.


To Manage Your Databases Using phpMyAdmin

  1. Log in to your Account Manager.
  2. Click Web Hosting.
  3. Next to the hosting account you want to use, click Launch.
  4. In the Databases section of the Hosting Control Center, click MySQL.
  5. Click Manage via phpMyAdmin for the database you want to manage with phpMyAdmin.
  6. 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.
  7. Click Go.
When you're inside your MySQL database, delete all comments from wordpress.

Comments

Popular posts from this blog

Life Hacks

DIY Distilling with a Wok Still DIY AC DIY Fleshlight DIY Outdoor Luxe DIY PBR Burner Downloading Free Sunlight Forever Guide to Downloading ebooks on IRC Part 1 Guide to Downloading ebooks on IRC Part 2 Steampunk Goggles Weapons Delayed Fire and Incendiary Bomb DIY Shotgun Pipe Hand Grenade Drugs Drugs Venn Diagram Hallucinogen Awareness Painkillers Periodic Table of Beer Styles The Golden Age of Pills Recipes Creating LSD Extraction of DMT How to Cook Crack Mescaline Capsules Weed Green House Seed Flavour Pie How D'ya Smoke Pot and Stay Out of Jail? Okay You've Been Careful But... Stoner Etiquette Fashion A Very Short Guide to Dressing Well The 20 Laws of Fashion The MANual Food About Bread Foods on the Cheap Drinks Coffee Types Emergency Coffee Hollywood Happy Hour Mind Fuck Coffee Mixing Drinks Recipes 3 Minute Brownies 3-Bean Bu...

Amazon Product Image Shortcut URL from ASIN

I'm trying to find a better way to build my affiliate pages. I've discovered a great way to find images of items that i hadn't known about before. http://images.amazon.com/images/P/B0051VVOB2.01.LZ.jpg http://images.amazon.com/images/P/ <- this is required B0051VVOB2 <- this is the ASIN .01.LZ.jpg <- this is required to follow the asin for large photos If you would like smaller, remove the LZ. http://images.amazon.com/images/P/B0051VVOB2.01.jpg

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 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...