Ok hopefully I am missing something very simple but I am having trouble copying my WP database from Strato to Godaddy. (i am having speed issues on godaddy so i want to compare the two before i ditch godaddy and upgrade my strato account).
using phpMyAdmin i have made a backup of my strato DB and using the instructions found here i am trying to upload this database to godaddy.
When i click go at point 8 it pauses for a minute or so and then gives me this error message...
#1044 - Access denied for user 'u876876876'@'%' to database 'DB876876876' "
Am i right in thinking that i need to make sure the username and password on the godaddy server match those on the existing strato server? - If so i have the following problem..
Strato forces the UN to be uppercase (U876876876) and Godaddy forces it to be lowercase (u876876876) would this account for the error above and if so is there a way that i can change the UN in either of the databases to fix this?(maybe using phpMyAdmin?)
Sorry if this has been posted elsewhere... I had a look but couldn't find anything. And thanks in advance.