Hi, am busy installing the site that I've built on local host. I set this up with a database name 'example' only problem is that when I import into sql I get the message
#1044 - Access denied for user 'example'@'localhost' to database 'cdcol'
Normally I have no problem and it all works fine. I wonder if I get this access problem because my new hosts insist the database name is prefixed with the web url as in example_com_example and the database was built with only 'example'
Would this be the case? and If so, what do I need to change in my mysql dump if anything.