2,569
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 1:
Line 1: − ===MySQL Database===+ − ====Useful links==== − ====General====+ Line 17:
Line 16: − ==== MySQL root password ====+ − ===== Login as MySQL root user =====+ − ===== Resetting the MySQL root password =====+ Line 43:
Line 42: − ==== Access MySQL from the local network ====+ Line 54:
Line 53: − ==== Access MySQL from a remote network ====+ Line 65:
Line 64: − ====Administration====+ − ===== Create a new database =====+ Line 79:
Line 78: − ===== Creating MySQL user(s) =====+
→MySQL Database: change indent level
==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.
A lot of applications require a MySQL database, among them is the Horde webmail interface which is supplied by SME Server by default.
* 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/
===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.
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).
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 ===
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.
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.
==== Login as MySQL root user ====
To login as MySQL root user, simply type 'mysql' at the SME Server shell, this will log you in with root privileges.
To login as MySQL root user, simply type 'mysql' at the SME Server shell, this will log you in with root privileges.
==== Resetting the MySQL root password ====
To reset the password for the MySQL root account. The MySQL root user on SME Server has a random generated password which is generated during installation. You do not need to know this password to login to MySQL with root privileges on SME Server. If you might have changed the MySQL root password you can reset it like this after getting command line access as root user:
To reset the password for the MySQL root account. The MySQL root user on SME Server has a random generated password which is generated during installation. You do not need to know this password to login to MySQL with root privileges on SME Server. If you might have changed the MySQL root password you can reset it like this after getting command line access as root user:
sv u .
sv u .
=== Access MySQL from the local network ===
To access MySQL from my local network
To access MySQL from my local network
Because MySQL on SME Server is run on a socket instead of on a port
Because MySQL on SME Server is run on a socket instead of on a port
=== 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:
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.
===Administration===
==== Create a new database ====
* See the developers guide if you wish to automate the creation of a database within an rpm
* See the developers guide if you wish to automate the creation of a database within an rpm
or
or
}}
}}
==== Creating MySQL user(s) ====
Decide which permissions you will have to give to the user on what database. Details about this can be found in the MySQL Manual found at the MySQL site. Get access to the SME Server shell and issue the following commands to login to the MySQL server:
Decide which permissions you will have to give to the user on what database. Details about this can be found in the MySQL Manual found at the MySQL site. Get access to the SME Server shell and issue the following commands to login to the MySQL server:
