I never run MySQL on Windows so I can't say specifically. Bottom line is the way MySQL works users have to be explicitly given permissions to hit MySQL from remote servers, and you can use either host name or IP. That's why you see a "host" column in the user table in the mysql database. If you didn't use a wildcard for that and it's set to only allow access from localhost, that's the problem.
On Tue, May 15, 2012 at 1:01 PM, Jason King <[email protected]> wrote: > Ok, Well I'm trying to figure out how to give the user remote permissions. > Do I need to explicitly define the IP of the OpenBD server? Where would I > do that? > > I'm using mySQL on Windows 2008, and using mySQL Workbench to admin it. > > -- > online documentation: http://openbd.org/manual/ > google+ hints/tips: https://plus.google.com/115990347459711259462 > http://groups.google.com/group/openbd?hl=en > -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
