35
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 1:
Line 1: − There are a lot of applications require a MySQL database, among them is the Horde webmail interface which is supplied by SME Server by default. + − Usefull links+ Line 15:
Line 15: − + − + Line 36:
Line 36: − + − +
typos
===MySQL Database===
===MySQL Database===
SME Server runs MySQL as a database server.
SME Server runs MySQL as a database server.
A lot of applications require a MySQL database, among them is the Horde webmail interface which is supplied by SME Server by default.
Useful links
* MySQL website: http://www.mysql.com <br />
* MySQL website: http://www.mysql.com <br />
* MySQL 4.1 manual: http://dev.mysql.com/doc/refman/4.1/en/
* MySQL 4.1 manual: http://dev.mysql.com/doc/refman/4.1/en/
MySQL on SME Server runs on a socket instead of on a port which you might be accustomed to.
MySQL on SME Server runs on a socket instead of on a port which you might be accustomed to.
This is done to improve security as in the view of the development team only the server self needs to have access to the MySQL server. However you can configure MySQL to be accessible from the local network
This is done to improve security as in the view of the development team only the server itself (localhost) needs to have access to the MySQL server. However you can configure MySQL to be accessible from the local network (see below).
==== MySQL root password ====
==== MySQL root password ====
There seems to be no password set for the MySQL root password, but this is not true. If you are logged in to the SME Server shell a special mechanism is in place to log you in with MySQL root privileges without prompting you for the password.
There appears to be no password set for the MySQL root password, but this is not true. If you are logged in to the SME Server shell a special mechanism is in place to log you in with MySQL root privileges without prompting you for the password.
The MySQL root password for SME Server is a 72 character random string generated during installation of SME Server. You should never change the MySQL root password as this will break your SME Server configuration. How to login as MySQL root user? describes how to access MySQL with root privileges on SME Server.
The MySQL root password for SME Server is a 72 character random string generated during installation of SME Server. You should never change the MySQL root password as this will break your SME Server configuration. How to login as MySQL root user? describes how to access MySQL with root privileges on SME Server.
==== Access MySQL from the local network ====
==== Access MySQL from the local network ====
To access MySQL from my local network
To access MySQL from my local network
Because MySQL on SME Sverer is ran on a socket instead of a on a port
Because 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 local connections to improve security, this means that it is only accessible from the server it self 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.
If you wish to enable local network access, execute the following commands on a SME Server shell as root:
If you wish to enable local network access, execute the following commands on a SME Server shell as root:
