Connect Alfresco with Mysql

[yogesh123]

Hi,
I have installed Alfresco community on ubuntu, but it comes with postgresql as default database.
How can I configure Alfresco with Mysql? Please let me know the steps, if anybody knows.

Thanks in advance.

[mlagneaux]

Hello,

Database connection is configured in [TOMCAT_HOME]/shared/alfreco-global.properties file. In the comments of this file, you will find an example of MySQL connection. Moreover, you'll have to put the MYSQL JDBC connector in [TOMCAT_HOME]/shared/lib.

Feel free if you need further details.

[yogesh123]

Hi Mlagneaux,
I don't find alfresco-global.properties file in [TOMCAT_HOME]/shared folder.
I found classes and lib folders over there, inside classed there is alfresco-global.properties file.
Even I don't find example which you were talking about.
Thanks for your help.

[mrogers]

This is well documented please read the alfresco documentation but miagamuex has essentially got it right although a slight error with the location of alfresco-global.properties.

But in summary here are the steps.

A install MySQL,
B create an empty schema for alfresco to use and an account to access the schema
C add the MySQL connector to tomcat's shared lib if its not there already
D set the db.url, db.database and db.password properties in alfresco-global.properties.