access/migration problem

[theS70RM]

Hi,

Im having some issues migrating a database using mysql tools.

I have a windows 2000 server running an older version of mysql hosting several databases. If I connect locally on that server using a standard user account I set up (not root) I can see all the schemata.

When I connect from another machine (winxp) I can only see (and therefore migrate) only one database. All I need to be able to do is connect using mysql tools on another machine and be able to see *all* the databases/schemata. I added the new host to the user and I cant see any difference between the "localhost" settings for that user and the ones for the new host.

I tried adding privileges to certain schema for the user on the other host, but now when i connect from it I cant see any schemata!!

Any idea's anyone please?


Thanks

Andy

[theS70RM]

if i dont enter a default schema locally it list all the databases, if i do it from the remote machine it doesnt list any, or it lists 1. It's the same user and I cant see any difference between the host settings for the user. =(

additionally, if I enter a schema that doesnt exist it creates it, if i chose one that does exist, it says it doesnt exist then gives me a "Could not connect to the specified instance" error number 1044. which i access denied.