cancel
Showing results for 
Search instead for 
Did you mean: 

no charge tables in my mysql

acasado
Champ in-the-making
Champ in-the-making
I have mysqld with Redhat enterprise and i want use it.

When i install  alfresco-community-linux-3.4.b.bin and i select "Use an existing MySQL database instance", it doesn't charge tables in it.

And i don't have the file "<alfresco install dir>/alfresco/extras/databases/mysql/db_setup.sql"

¿?
1 REPLY 1

jottley
Confirmed Champ
Confirmed Champ
Can you open a JIRA report for this http://issues.alfresco.com?  Thanks!

In the mean time:

db_setup.sql

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;

db_remove.sql

drop database alfresco;
revoke all privileges, grant option from 'alfresco'@'localhost';
drop user 'alfresco'@'localhost';