3,704
edits
Changes
From SME Server
Jump to navigationJump to searchSoftware Collections:MySQL (view source)
Revision as of 09:31, 7 January 2015
, 09:31, 7 January 2015→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.}}
{{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 3306
config setprop mysql55-mysqld TCPPort 13306
config setprop mysql55-mysqld UDPPort 3306
config setprop mysql55-mysqld UDPPort 13306
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:
