Configure alfresco with mysql database

Configure alfresco with MySQL

In previous versions we have zip bundle for alfresco , now we have executable file, which is like wizard base and asking for database URL.

We can simplify the database configuration by giving following :

1. Database Driver
   db.driver=org.gjt.mm.mysql.Driver
2. Database URL
   db.url=jdbc:mysql://localhost/<your_db_name>\
3. Your Database username
   db.username=<your_db_username>
4. Your Database password
   db.password=<your_db_password>
5. Place jar file of mysql to tomcat/lib folder of alfresco.
6. Start Alfresco

So finally it looks like below

### database connection properties ###

db.driver=org.gjt.mm.mysql.Driver

db.username=xyz

db.password=xyz

db.name=mydb

db.url=jdbc:mysql://localhost/mydb

Please make sure, you have configured database setting properly in order to work successfully.

Also need to tweak catalina.bat little bit, which I have shown in another blog.