3,250
edits
Changes
From SME Server
Jump to navigationJump to search→Access MariaDB/MySQL using port from the localhost and local network
{{Warning box|Keep in mind that by default MariaDB/MySQL is not using any kind of encryption unless you did work on that yourself, so any access to the port from the LAN will be as clear text and anyone on the LAN will be able to access to the password and all the data transferred between your server and the client. Refers to the manual of your database version.}}
{{Warning box|Keep in mind that by default MariaDB/MySQL is not using any kind of encryption unless you did work on that yourself, so any access to the port from the LAN will be as clear text and anyone on the LAN will be able to access to the password and all the data transferred between your server and the client. Refers to the manual of your database version.}}
For SME 10:
<tabs container style="display: inline-block;"><tab name="For SME 10">
config setprop mariadb LocalNetworkingOnly no
config setprop mariadb LocalNetworkingOnly no
expand-template /etc/my.cnf
expand-template /etc/my.cnf
systemctl restart /service/mysqld
For SME 9 and below:
</tab><tab name="For SME 9.2 and before">
config setprop mysqld LocalNetworkingOnly no
config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
expand-template /etc/my.cnf
sv t /service/mysqld
sv t /service/mysqld
</tab>
</tabs>
==Access MySQL from a remote network==
==Access MySQL from a remote network==
