624
edits
Changes
From SME Server
Jump to navigationJump to searchadded mysql remote access db command
expand-template /etc/my.cnf
expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/mysqld restart
==== Access MySQL from a remote network ====
If you wish to enable access to MySQL databases from remote networks, then in addition to the LocalNetworkingOnly db setting mentioned above, you will need to execute the following commands:
config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot
Keep in mind this enables access to your MySQL database for ANYONE, so make sure you have strong passwords on ALL your MySQL databases.
Alternatively it would be a more secure approach to require external (remote) users to establish a VPN connection and effectively become part of the local network. In that case do not change the mysql access to public status using the above command.
====Administration====
====Administration====
