3,704
edits
Changes
From SME Server
Jump to navigationJump to searchSoftware Collections:MySQL (view source)
Revision as of 10:27, 7 January 2015
, 10:27, 7 January 2015→Configure private/public access
====Configure private/public access====
====Configure private/public access====
{{Note box|This part needs to revised due to port 3306 already in use by the default SME Server MySQL version. Maybe using the ''-p 13306'' option when starting MySQL55.}}
If your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN) the ports and access privileges need to be set. For this issue the following commands (where 5432 is the port that MySQL can be reached on):
If your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN) the ports and access privileges need to be set. For this issue the following commands (where 5432 is the port that MySQL can be reached on):
config setprop mysql55-mysqld TCPPort 5432
config setprop mysql55-mysqld TCPPort 3306
config setprop mysql55-mysqld UDPPort 5432
config setprop mysql55-mysqld UDPPort 3306
config setprop mysql55-mysqld access private
config setprop mysql55-mysqld access private
followed by the event to update the firewall rules:
followed by the event to update the firewall rules:
signal-event remoteaccess-update
signal-event remoteaccess-update
You can toggle between private and public access followed by the remoteaccess-update command.
You can toggle between private and public access followed by the remoteaccess-update command.
==Other articles in this category==
==Other articles in this category==
