I am trying to move my blog from GoDaddy's free hosting to Webhostingpad. This is easier said than done, as I am finding out right now.
I used online tutorials to get to the point where I have all my old wordpress files uploaded to the new server, along with all the necessary changes to the config.php file. I also downloaded/backed up my old SQL database.
Apparently, now I am supposed to import the old database. I use myphpadmin and go through the necessary steps, but I am left with this message:
journalcomicDEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'anotherj'@'localhost' to database 'journalcomic'
Since my new site is hosted by WebHostingPad, my new database is named "anotherj_JournalComic" and there is no (advisable) way to remove the "anotherj_" from the beginning of the database name.