MyODBC and connection to a remote mysql db - n e T b r a i n - com.mysql.lists.win32

5 messages in com.mysql.lists.win32MyODBC and connection to a remote mys...

From	Sent On	Attachments
n e T b r a i n	02 Jun 2000 02:14
Sinisa Milivojevic	02 Jun 2000 05:31
n e T b r a i n	02 Jun 2000 07:40
Gino, Antonio	02 Jun 2000 10:25
Sinisa Milivojevic	03 Jun 2000 05:25

Subject:	MyODBC and connection to a remote mysql db
From:	n e T b r a i n (net-...@net-brain.net)
Date:	06/02/2000 02:14:55 AM
List:	com.mysql.lists.win32

Hi,

in order to share data between my local Ms Access databases and my remote MySql db, is possible to use MyODBC specifying for the "MySql host (name or ip)", my virtual IP (IP that is in the same computer where is the remote Mysql server) and asking to my ISP to set a new kind of grant for me and my remote database, similar like this:

GRANT ALL ON mydatabase FOR myusername@% IDENTIFIED BY "mypassword"

Many thanks in advance. Max