Koozali.org: home of the SME Server

Connect to Mysql from outside lan with ODBC driver

Offline swissis

  • ***
  • 61
  • +0/-0
Connect to Mysql from outside lan with ODBC driver
« on: August 17, 2006, 04:07:54 PM »
Hi,

I'm able to connect to a database with the ODBC driver on our lan. Now i would like to test to connect from home. The sme server is the first thing behind my modem. But it doesn't work.

Do i have to do something else then
Code: [Select]

## Set configuration for external MySQL access
config setprop mysqld LocalNetworkingOnly no
## Apply configuration changes
signal-event post-upgrade; signal-event reboot
[System reboots]
...

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Connect to Mysql from outside lan with ODBC driver
« Reply #1 on: September 22, 2006, 01:43:25 PM »
Open port 3306 in your firewall ?
Regards,
William

IF I give advise.. It's only if it was me....

Offline mmccarn

  • *
  • 2,656
  • +10/-0
Connect to Mysql from outside lan with ODBC driver
« Reply #2 on: September 22, 2006, 02:53:20 PM »
This thread might be useful: MySQL remote access on SME 7pre3 Question