no charge tables in my mysql

acasado — Fri, 10 Dec 2010 12:39:26 GMT

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"¿?

Re: no charge tables in my mysql

jottley — Fri, 10 Dec 2010 14:51:21 GMT

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';‍‍‍

topic Re: no charge tables in my mysql in Alfresco Archive

no charge tables in my mysql

Re: no charge tables in my mysql