Alfresco community 4.2.b installation with MySQL database for windows

• First install MYSQL server
• Create a database instance of Alfresco repository. Execute the following script:
  CREATE USER alfresco@localhost IDENTIFIED BY ‘alfresco’;
  create database alfresco DEFAULT CHARACTER SET utf8;
  grant all on alfresco.* to alfresco@localhost identified by ‘alfresco’ with grant option;
  FLUSH PRIVILEGES;
• Now Click here to download the “alfresco-community-4.2.b-installer-win-x64”.
• Double click “alfresco-community-4.2.b-installer-win-x64”

• Select Installation type as Advanced.

• Uncheck PostgreSQL database

• Modify JDBC URL to : jdbc:mysql://localhost/alfresco
  JDBC Driver: org.gjt.mm.mysql.Driver
  Username: alfresco
  Password:

 

• Open <ALFRESCO_INSTALLATION_HOME>/tomcat/conf/catalina.properties 
• Verify shared.loader is set to following value:

     shared.loader=${catalina.home}/shared/classes,${catalina.home}/shared/lib/*.jar or
     shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar

• Next modify global.properties
• Edit <ALFRESCO_INSTALLATION_HOME>/tomcat/shared/classes/alfresco-global.properties

Verify following database connection properties are set properly:
### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco
db.password=admin@cml
db.name=alfresco
db.url=jdbc:mysql://localhost/alfresco
db.host=localhost
db.port=3306
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}

• Make sure that database username and password are specified correctly.
• Copy mysql-connector-java-5.1.20-bin.jar from “<MYSQL_INSTALLATION>\Connector J 5.1.20.0” to <ALFRESCO_INSTALLATION_HOME>/tomcat/lib
• Start Alfresco server:
• Verify that MySQL server is up and running.
• Double click “manager-windows.exe”

• Click on “Start”
• Creation of user with readonly permission for Alfresco database:

•  Click on Manage security

•  Click on Add Account

username: alfdb_user
password:

• Click on Apply.
• Click on schema privileges
• Select alfdb_user then click on Add Entry.

•  Select only alfresco schema and click OK

•  Select only “SELECT” option and click save changes