<div dir="ltr"><div><div>Muskie,<br><br></div>I've never had the opportunity to use MySQL with ogr but my guess is that you need to do some thing like:<br><br><pre>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.<br><br>From <br><br><a href="http://www-css.fnal.gov/dsg/external/freeware/Repl_mysql_vs_psql.html">http://www-css.fnal.gov/dsg/external/freeware/Repl_mysql_vs_psql.html</a><br></pre>
Regard<br></div><br><div><div><div><br><div><div><div><br><br></div></div></div></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 12 February 2013 10:17, Muskie <span dir="ltr"><<a href="mailto:asimmons@pvpc.org" target="_blank">asimmons@pvpc.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
I touched on this issue I am having here:<br>
<a href="http://osgeo-org.1560.n6.nabble.com/Anyone-tried-using-ogr2ogr-on-a-remote-MySQL-db-td5030802.html" target="_blank">http://osgeo-org.1560.n6.nabble.com/Anyone-tried-using-ogr2ogr-on-a-remote-MySQL-db-td5030802.html</a><br>

<br>
Basically I'm trying to give our host DBA the information necessary to<br>
configure our remote MySQL database for ogrinfo and ogr2ogr access. I've<br>
been trolling the internet like crazy with no luck.<br>
<br>
Anyone happen to be familiar with this game?<br>
<br>
Thanks!<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="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" target="_blank">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</a><br>

Sent from the GDAL - Dev mailing list archive at Nabble.com.<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div><br></div>