|  | 60 | == Opal Post Installation | 
          
            |  | 61 |  | 
          
            |  | 62 | See: | 
          
            |  | 63 | - [[http://wiki.obiba.org/display/OPALDOC/Post+Installation+Set-up]] | 
          
            |  | 64 |  | 
          
            |  | 65 | == Opal Database Setup | 
          
            |  | 66 |  | 
          
            |  | 67 | See: | 
          
            |  | 68 | - [[http://wiki.obiba.org/display/OPALDOC/Databases+Administration]] | 
          
            |  | 69 |  | 
          
            |  | 70 | === 1. Update MySql Config | 
          
            |  | 71 |  | 
          
            |  | 72 | 1. The config file for MySQL files on a LAMP server is stored at `/db/mysql/etc/my.cnf` | 
          
            |  | 73 | 2. Change the default character set in the `[mysqld]` section: | 
          
            |  | 74 |  | 
          
            |  | 75 | {{{ | 
          
            |  | 76 | default-character-set=utf8 | 
          
            |  | 77 | default-collation=utf8_bin | 
          
            |  | 78 | }}} | 
          
            |  | 79 |  | 
          
            |  | 80 | 3. Change the storage engine in the `[mysqld]` section: | 
          
            |  | 81 |  | 
          
            |  | 82 | {{{ | 
          
            |  | 83 | default-storage-engine=INNODB | 
          
            |  | 84 | }}} | 
          
            |  | 85 |  |