Changes

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==

==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.

You can upgrade MySQL to a higher version but you are advised not to do so, as this might break your SME Server configuration. The Horde webmail interface relies on MySQL. Upgrading to version 5.x is known to break stuff like webmail. If you insist on upgrading MySQL you may be able to find instructions in the forum, but be advised that no support can be expected from the developers and all bugs reported in the

You can upgrade MySQL to a higher version but you are advised not to do so, as this might break your SME Server configuration. The Horde webmail interface relies on MySQL. Upgrading to version 5.x is known to break stuff like webmail. If you insist on upgrading MySQL you may be able to find instructions in the forum, but be advised that no support can be expected from the developers and all bugs reported in the

{{Tip box|The suggestion here is to assign privileges based on IP number (using a wild card if desired), the same can also be done for hostnames. In some cases, like dynamicaly assgned IP addresses, this might be a more suitable and robust solution.}}

{{Tip box|The suggestion here is to assign privileges based on IP number (using a wild card if desired), the same can also be done for hostnames. In some cases, like dynamicaly assgned IP addresses, this might be a more suitable and robust solution.}}

You probably want to change:

You probably want to change:

* the database name ('''MyDB''')

 

* the user name ('''MyUser''')

*the database name ('''MyDB''')

* the password ('''MyPW''') and  

*the user name ('''MyUser''')

* the allowed computers ('''192.168.xx.%''')

*the password ('''MyPW''') and

*the allowed computers ('''192.168.xx.%''')

 

  <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===

===Create a new database===

===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

* Get access to the SME Server shell and issue the following commands:

 

*Get access to the SME Server shell and issue the following commands:

  mysqladmin create 'dbname' --default-character-set=utf8

  mysqladmin create 'dbname' --default-character-set=utf8

----

----

[[Category:Howto]]

[[Category:Howto]]

[[Category:Administration]]</noinclude>

[[Category:Administration]]

</noinclude>