Windows to MYSQL under Linux/UNIX, can not connect

[cubano]

Hi there:

I need URGENT help about this ..

I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under linux, and create the same database, same
user and password. But when I connect the error message said:
[MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to
connect to this MYSQL Server.

But form the database, I added the host "%", means hsould be allow any
host... anyone can help me on this? the application I wrote will be
using with dynamic IP everytime user dial-up to the internet connect..

wish to hear some help soon..

[Atli]

Hi, and welcome to TSDN.

I'm moving this thread to the MySQL Forums.
Please refrain from posting questions in the Acticle section!

Moderator

[Atli]

You should be able to connect to a remote MySQL server, regardless of what type of OS it is running on, if the user has propper privileges.

You can create a user with that kind of privileges like this:

CREATE USER joe@'%';
 

Or:

GRANT ALL
ON myDb.*
TO joe;
IDENTIFIED BY 'myPassword';
 

Users created without a specific host name are automaticly created with remote access.

[pbmods]

Try loading up your MySQL client on the Linux box and run the following query:

SELECT `user`, `host` FROM `mysql`.`user`