80
edits
Changes
Jump to navigation
Jump to search
Line 153:
Line 153: − + − + Line 167:
Line 167: − + − sv t /service/mysqld + − + + + − + − + − + + +
Wrong path for expand-template (
Considering your table dump is now in a file called /home/e-smith/db/mysql/mysql.user.dump, do
Considering your table dump is now in a file called /home/e-smith/db/mysql/mysql.user.dump, do
mysql mysql < /home/e-smith/db/mysql/mysql.user.dump
mysql mysql < /home/e-smith/db/mysql/mysql.user.dump
expand-template /var/service/mysqld/set.password
expand-template /var/lib/mysql/set.password
mysql mysql < /var/service/mysqld/set.password
mysql mysql < /var/lib/mysql/set.password
mysqladmin shutdown
mysqladmin shutdown
systemctl start mariadb
systemctl start mariadb
{{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==
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 smeserver-mysql-update
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.