I have signed up with Host Gator and am in the process of moving one of my wordpress sites over from 1and1.
When I try to import the old database into the newly created database on Host Gator via phpmyadmin import function, I get the following error:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- Host: HOSTNAME
-- Generation Time: Jan 14, 2012 at 10:03 PM
-- Server version: 5.0.91
-- PHP Version: 5.3.3-7+squeeze3
-- Database: `DBNAME`
#1044 - Access denied for user 'NEWUSER'@'localhost' to database 'DBNAME'
I've read that I should just go and add the new user/pass to the old databse before exporting. I would, however 1and1 doesn't allow more than one user/pass. Then I thought I could create a user with the same credentials on the new host - but any new usernames use a different prefix, so that's not possible.
Is there any way around this?