Changes

{{Languages}}

{{Languages}}

SME Server runs MySQL as a database server.

SME Server up to and including version 9.x runs MySQL as a database server: versions 10 on use MariaDB to provide this function.

A lot of applications require a MySQL database, among them is the Horde webmail interface which is supplied by SME Server by default.  

A lot of applications require a MySQL database, among them is the Horde webmail interface which is supplied by SME Server by default.  

  <nowiki>## In the command below, \ escapes a linebreak.

  <nowiki>## In the command below, \ escapes a linebreak.

  ## Either include them, or place the entire command on one line

  ## Either include them, or place the entire command on one line

  mysql -e "\

  mysql -e "\

  create database MyDB; \

  create database MyDB; \

  GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER \

  GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER \

  ON *.* \

  ON *.* \

  TO 'MyUser'@'192.168.xx.%' \

  TO 'MyUser'@'192.168.xx.%' \

  IDENTIFIED BY 'MyPW'; \

  IDENTIFIED BY 'MyPW'; \

  FLUSH PRIVILEGES;"</nowiki>

  FLUSH PRIVILEGES;"</nowiki>

===Security Implications of allowing remote mysql login===

===Security Implications of allowing remote mysql login===