Loading...

March 15, 2011

Alfresco Installation and Missing db_setup.sql File

If we install Alfresco and want to initialize a MySQL server with the correct database name and user we must execute run a file db_setup.sql. This file should be in the Alfresco installation directory, but in my Linux and Mac OSX installation directories I couldn't find the file. Searching on the internet I found what the contents of the file must be:

create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

We can execute this script with $ mysql -u root -p < db_setup.sql and a database with the name alfresco is created, together with a user alfresco and password alfresco.

The first time we start Alfresco after installation the correct tables and contents is created in this new database.