you will have to make a new database on the new site
make a new user
add the user to the database <--- the step everyone forgets
THEN go to the new database and import the sql export from the old one

http://www.spinland.biz/smileys/eusa_doh.gif

hehe - you've done that too spinny? People do that all the time - You'd think i'd be over forgetting that bit by now - and usually i remember - but i did spend 10 min wondering why my new script didnt connect the other day in a fit of forgetfulness

doesn't an import make the database when the sql dump file has this line in it...

CREATE DATABASE `buckeyel_oceanthree` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


I have forgotten to configure users and/or privileges myself,, duuuuu,, why won't this work.
The server geeks made it so easy and yet I can't make it work.

oh - proabably it does dave - i usually go to one database - export the sql - go make a new database and user stuff - then import the sql - thats exactly the way i do a transfer between hosts too...

also the tablename usually has your username in it - the `buckeyel` bit of `buckeyel_oceanthree`
so on a new host that might need to be `newhost_oceanthree` to make the appropriate oceanthree database for your ap to find

ahhh, yes.. It is all coming back to me. It's been a while since I transferred hosts or moved a database. I recall editing those declaration lines and/or removing them to do an import.