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 <asimm...@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@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
