AnsweredAssumed Answered

Alfresco and Mysql

Question asked by nezha on Mar 11, 2014
Latest reply on Mar 11, 2014 by nezha
i followed this procedure
1/ Install MySSQL using mysql-installer-community-
>   Full install

2/ Add environment Variables
> Path (C:\Program files\mySQL\MySqlServer 5.6\Bin)

3/ Open Cmd.exe and log into MySQL
> Mysql –u root –p

4/ Create Alfresco database
>   Create database alfresco;

5/ Create user
>Create user ‘alfresco’@’localhost’ identified by ‘alfresco’

6/ Grant permissions
> Grant all privileges on *.* to ‘alfresco’@’localhost’
> With grant option;

7/ Install Alfresco community 4.2.c (install Settings below)
> Install all components except the Postgresql
> Folder – C:\alfresco

Database Config
> URL    - jdbc:mysql://localhost:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8
> JDBC Driver   -
> DB name - alfresco
> DB user   - alfresco
> Password   - *******

8/ Updating properties
> open C:\Alfresco40a\tomcat\shared\classes\
> check Dir.root=c:\alfresco\alf_data
> uncomment url and Driver sections (updating to suit)
> uncomment db username and password (updating to suit)
> Insert index type (if using lucene indexs)

9/ Rename to
> to

10/ Apply MySQL Connector
> Copy Connector J 5.1.23.Jar to [Dir.root]\tomcat\lib

11/ restore mysql database in CMD
> mysql –u alfresco –p PASSWORD alfresco

but when i tried to log in my Alfresco i got this error:
Le serveur distant est indisponible ou vos informations d'identification n'ont pas été reconnues.
i think the problme is how to migrate database from alfresco to mysql please someone can helpe???