Hunter Douglas Blinds Vs.bally Blinds

Create the MySQL database for Alfresco Alfresco

E 'can proceed to create the MySQL database for Alfresco as follows:

1) Set MySQL to UTF-8

Edit / etc / mysql / my.cnf adding default -character-set = utf8 in the [mysqld] section:

[mysqld]

# # ...

# default-character-set = utf8


2) Restart mysql, usually via / etc / init.d / mysql restart

  3) Login as root: mysql-u root-p 
 
 4) perform following commands (assuming it has been previously created a database 'alfresco' with user 'alfresco'): 
 
 
 CREATE DATABASE alfresco CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;  GRANT ALL PRIVILEGES ON .* TO alfresco alfresco @ localhost IDENTIFIED BY ' alfresco '; 

GRANT SELECT, LOCK TABLES ON .* TO alfresco alfresco @ localhost IDENTIFIED BY' alfresco ';
FLUSH PRIVILEGES;
quit;