Database problem with server move

[Woody619]

Hi,
I have followed Wiki on moving to another host or a different server.

I cannot called the database the same because of the hosts prefix ie, the old ones web20-woodyzen with no control over web20- and the new host anythin_woodyzen with no control over anythin_.

I follow the guide but when I get to importing into the new database i get..

Error

SQL query:
--
-- Database: `web20-woodyzen`
--
CREATE DATABASE `web20-woodyzen` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


MySQL said:
#1044 - Access denied for user 'anythin_woody'@'localhost' to database 'web20-woodyzen'

I am lost can anyone help? I have searched the forums but can't find anything.

[Woody619]

I tried opening the sql file and changing the database name web20-woodyzen to the new one anythin_woodyzen in 3 places, but just got errors or database already exists.

[kobra]

Try opening the sql and dropping the create database section as I assume that this DB is already created and if this is cPanel or similar you cannot create a DB with phpmyadmin or through sql as Db creation must be in the control panel

[Woody619]

Try opening the sql and dropping the create database section as I assume that this DB is already created and if this is cPanel or similar you cannot create a DB with phpmyadmin or through sql as Db creation must be in the control panel

Excellent kobra that worked a treat.
Thank you for your help and time it is very much appreciated.