Mango and MySQL

mlohbihler

Users have asked for details on how to have their Mango instances use MySQL instead of Derby. Note first that there is currently no conversion mechanism between the two. When you switch to MySQL, you are creating an entirely new instance of Mango. (The import/export utility will be of use getting some configuration over.) Note secondly that this only applies to the commercial version.

Edit the <tomcat-webapps>/<mango-dir>/WEB-INF/classes/env.properties file. By default the settings of concern will be:


db.type=derby
db.url=~/../../mangoDB
db.username=
db.password=

You will need to change this to:


db.type=mysql
db.url=&lt;url to mysql&gt;
db.username=&lt;mysql username&gt;
db.password=&lt;mysql password&gt;

The url to mysql will look something like this: "jdbc:mysql://localhost/mango". You should not need to install the mysql connector classes into Mango since the jar file ships with Mango anyway.

mlohbihler

An extra note: your MySQL user and the schema (or catalog) must already exist, and the user must have permission to the schema in all the usual ways. (When in doubt, grant the user all permissions to the schema). But, do not create the Mango tables yourself. Mango likes to do that itself.

mlohbihler

This post has been superseded by this one: http://mango.serotoninsoftware.com/forum/posts/list/185.page.