985
edits
Changes
From SME Server
Jump to navigationJump to searchInnoDB
===General===
===General===
The SME Server is based on CentOS, the development team will take their stock RPM's from the CentOS releases. The current version of MySQL installed on SME Server is version 4.1.20.
The SME Server is based on CentOS, the development team will take their stock RPM's from the CentOS releases. The current version of MySQL installed on SME Server is version 4.1.20.
=== Access MySQL from the local network ===
=== Access MySQL from the local network ===
MySQL on SME Server is run on a socket instead of on a port.
MySQL on SME Server is run on a socket instead of on a port.
MySQL on SME Server is by default configured to allow only localhost connections to improve security, this means that it is only accessible from the server itself and not from the local network nor from the internet.
MySQL on SME Server is by default configured to allow only localhost connections to improve security, this means that it is only accessible from the server itself and not from the local network nor from the internet.
=== Access MySQL from a remote network ===
=== 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:
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:
Keep in mind this enables access to your MySQL database for ANYONE, so make sure you have strong passwords on ALL your MySQL databases.
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.
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.
=== Enable InnoDB engine ===
For enable InnoDB engine, run the following commands:
db configuration setprop mysqld InnoDB enabled
expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart
===Administration===
===Administration===
