ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down.
Read our Farewell Blog Post for more details.
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.