MS Access,MyODBC and MySQL on Linux

[Anon]

I have a big problem. please help me.
My Objective :
I want to export table in MS Access to MySQL Linux box .
My installed software :
1.MyODBC and MS Access in Window 98
2.MySQL on Linux Box.

I do to follow steps in tutorial at www.phphelp.com. And I think I follow right steps.
But after I export table by using MyODBC ,it has error (ODBC-call failed) like :

[TCX][MyODBC]Host " is not allowed to connect to this MySQL server (#1130)

How should I do ?
I must create table in MySQL which is the same fields with exported table in MS Access before ?
Please tell me.
and please explain me about MyODBC's working steps when I export table from MS Access to MySQL on Linux box.(if you can)
Thank you for advance.

[[deleted]]

You should login to the MySQL database server using a name and a password.
Did you use the GRANT statement in MySQL to give your windows machine access to the MySQL server?

[Anon]

I could export my MS Access's table already.
I didn't grant to my host which MS Access is stay before.
Thank you very much.

[Anon]

Problem when trying to export Database

I too face the same problem.While trying to export ACCESS database , i don't even get the option of saving the table to external database/file/current database. Also i get a error message "ODBC - call failed" .Can you please guide me??

I have installed MyODBC & MS ACCESS in win'98 & MySQL on my linux box.

Thanks in advance

[Anon]

Hiya!

I've got the same problem. Any other ideas?

[Anon]

Do something like this

mysql> grant all on yourdbname.* to yourname@yourremotemachine;

You should not use \"all\" but this will open it up for you.........