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.