3,250
edits
Changes
From SME Server
Jump to navigationJump to search→Access MySQL from a remote network
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.
