Hey Sonic, I don't think you really want, or even have to, disable the restriction for your MYSQL connection. I haven't had to do it lately, but what I remember doing to connecting to my MySQL database over SSH. So just like how you probably connect to your VPS through SSH you can leave the default settings exactly the same and connect to MySQL via a client over ssh. I use HeidiSQL as my main MySQL client and the feature is called "ssh tunneling". A quick search via Google seems to point out that Workbench does support this feature (though the documentation is hard to find). Protip: You will probably have to use your SSH port (not the default mysql port) when you setup the connect via the client.
Hope that is somewhat helpful. If you get a chance to try this and need more assistance let me know. On Tuesday, July 29, 2014 6:44:09 AM UTC-5, Sonic Sales wrote: > > Hi, > > I have somehow got the OpenBD JAM running on my VPS, and Im a happy man!.. > What im wanting to do now is connect to the mysql via MySQL Workbench. Its > only for my own stuff, so im not requiring very secure setup. I need MySQL > to be allowed to connect from any IP, as my IP locally changes. I only need > the one DSN, so will stick with the openbddatabase that was created on > installation. > > How do i disable the restriction on the MySQL connection? > > Thanks > > Glenn > > -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
