Changes

From SME Server
Jump to navigationJump to search
94 bytes added ,  02:58, 19 August 2022
Line 181: Line 181:  
If you wish to enable access to MariaDB/MySQL databases from remote networks, then in addition to the LocalNetworkingOnly db setting mentioned above, you will need to execute the following commands:
 
If you wish to enable access to MariaDB/MySQL databases from remote networks, then in addition to the LocalNetworkingOnly db setting mentioned above, you will need to execute the following commands:
   −
For SME 10
+
<tabs container style="display: inline-block;"><tab name="For SME 10">
 
  config set mariadb service access public status enabled TCPPort 3306  
 
  config set mariadb service access public status enabled TCPPort 3306  
 
  signal-event remoteaccess-update  
 
  signal-event remoteaccess-update  
 
  signal-event reboot
 
  signal-event reboot
For SME9  and below
+
</tab><tab name="For SME 9 and below">
 
  config set mysqld service access public status enabled TCPPort 3306  
 
  config set mysqld service access public status enabled TCPPort 3306  
 
  signal-event remoteaccess-update  
 
  signal-event remoteaccess-update  
 
  signal-event reboot
 
  signal-event reboot
 +
</tab>
 +
</tabs>
    
Keep in mind this enables access to your MariaDB/MySQL database for ANYONE, so make sure you have strong passwords on ALL your MariaDB/MySQL databases.
 
Keep in mind this enables access to your MariaDB/MySQL database for ANYONE, so make sure you have strong passwords on ALL your MariaDB/MySQL databases.
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,258

edits

Navigation menu