Connecting to two database servers

[T S]

Hi there,

I have a site where i have few tables.

two different servers - A and B
database are there in two servers databaseA (in server A), databaseB (in server B)
i want to transfer from databaseA to databaseB using the following query:

INSERT INTO `databaseB`.`ArtType`
SELECT *
FROM `databaseA`.`ArtType` ;

When the above is executed, am getting the following errror:

select command denied to user: 'user@localhost' for table 'ArtType'

Please note I have set all necessary wild card connections, etc. I can able to access data from both databaseA and databaseB.

Problem is the above sub query.

Here I reckon, thereis an ambiguity in connection ID.

Is there anyway to make the above work or Is there any other new way to do this?

Thank you