How to Upgrade MySQL in GoDaddy

My celebrity fashion blog hosted on GoDaddy was still using WordPress 2.8.3, so I decided to click the handy dandy “Update to 3.0.4” button to upgrade automatically. I was all excited as it was “unpacking the update” until I got a message that the Installation Failed:

The update cannot be installed because WordPress 3.0.4 requires MySQL version 4.1.2 or higher. You are running version 4.0.30.

Great. Not being a highly techie person, I had no idea how to upgrade my MySQL database, but I figured it, and thought I’d share the steps for anyone else caught in the same predicament:

1. Backup Your Current Database

  • Log into
  • Go to My Account > Web Hosting
  • Click on “Launch” Control Center under “My Accounts”
  • In the Hosting Dashboard, Click on Databases > MySQL
  • Find the Database Name you want to back up
  • Click on Pencil Icon under “Action”
  • Click “Backup” – This can take up to 2 hours.

2. Create a New Database

  • You can start this while waiting for backup.
  • Go back to “MySQL” and “Create Database”
  • I recommend naming the description the same with a “2” after it
  • Make sure MySQL Version is clicked to 5.0 (default)
  • This will now be “Pending Setup”
  • You have time to go grab a latte or sometimes two or three.

3. Restore Backed-Up Database to New Database

  • Refresh MySQL Database List
  • If your new database is Setup, click Pencil Icon
  • Click “Restore” Icon
  • Click Old Database File Name
  • Click “Restore”
  • Click “OK” on pop-up confirming Database Restore
  • This will now be “Pending Restore”
  • Grab another latte (or use the restroom after the last ones)

4. Update wp-config.php file

  • Use an FTP software – I use FileZilla (it’s free)
  • Find the wp-config.php (you may want to copy/save just in case)
  • View/Edit (right click in Filezilla)
  • Change properties in file with the new MySQL database name, MySQL user name (usually the same), MySQL password and MySQL host name.
  • Note that GoDaddy’s MySQL host name is never “localhost”, but an actual URL.
  • Save/Upload.

You should now be able to log into your wp-admin panel and successfully upgrade to the latest version of WordPress!

  • 41

Disclosure: In full disclosure, it is safe to assume that the site owner is benefiting financially or otherwise from everything you click on, read, or look at while on my website. This is not to say that is the case with all content, as all publications on the site are original and written to provide value and references to our audience.


  1. dotCOMreport January 6, 2011
  2. dotCOMreport January 6, 2011
  3. dotCOMreport January 6, 2011
  4. dotCOMreport January 6, 2011
  5. dotCOMreport January 6, 2011
  6. dotCOMreport January 6, 2011
  7. Andy January 7, 2011
  8. Zac Johnson January 8, 2011
  9. sparky January 10, 2011
  10. Eng / Mahmoud zezo January 11, 2011
  11. Frank McAllister January 18, 2011
  12. TheChurning March 22, 2011
  13. Eric May 14, 2011