Changes

From SME Server
Jump to navigationJump to search

Software Collections:MySQL (view source)

Revision as of 10:41, 7 January 2015

174 bytes removed ,  10:41, 7 January 2015
→‎Configure private/public access
Line 76: Line 76:     
====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 13306
+
  config setprop mysql55-mysqld TCPPort 3307
−
  config setprop mysql55-mysqld UDPPort 13306
+
  config setprop mysql55-mysqld UDPPort 3307
 
  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:
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/27010"

Navigation menu