AnsweredAssumed Answered

Alfresco 3.4.d change to external database

Question asked by itsupport on Jan 3, 2013
Latest reply on Jan 9, 2013 by itsupport
Hi Guys,

we have alfresco 3.4.d with build-in mysql database. currently, we would like to transfer the build-in database to a external database (mysql), and we tried hard, but the result is that after we done the following process, alfresco can not be accessed by using the same username and password.

step1. apt-get install mysql

step2. create database named "alfresco" with user "alfresco"(with full global privilieges) in new mysql server (username and password are the same as previous database).

step3. edited new mysql server's my.cnf file:   port:3305

step4. edited    db.url = jdbc:mysql://localhost:3305/alfresco?useUnicode=yes&characterEncoding=UTF8                                                                      

Many thanks