[gdal-dev] (ogr2ogr) Trying to export data into remote MySQL - anyone know how to set up remote configurations on the host side?

[Travis Kirstine]

Muskie,

I've never had the opportunity to use MySQL with ogr but my guess is that
you need to do some thing like:

GRANT USAGE ON cdfofprd.* TO dbreader@'hostname'
      IDENTIFIED BY 'some_pass';
GRANT Select, Insert, Update, Delete ON
      cdfofprd.* TO dbreader@'hostname';
FLUSH PRIVILEGES;
Where hostname is IP address or machine name that
connecting with Mysql server as a client.

From

http://www-css.fnal.gov/dsg/external/freeware/Repl_mysql_vs_psql.html

Regard






On 12 February 2013 10:17, Muskie <asimmons at pvpc.org> wrote:

> Hi,
>
> I touched on this issue I am having here:
>
> http://osgeo-org.1560.n6.nabble.com/Anyone-tried-using-ogr2ogr-on-a-remote-MySQL-db-td5030802.html
>
> Basically I'm trying to give our host DBA the information necessary to
> configure our remote MySQL database for ogrinfo and ogr2ogr access. I've
> been trolling the internet like crazy with no luck.
>
> Anyone happen to be familiar with this game?
>
> Thanks!
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/ogr2ogr-Trying-to-export-data-into-remote-MySQL-anyone-know-how-to-set-up-remote-configurations-on-t-tp5033748.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20130212/084e71f3/attachment.html>