| | |
|---|
| | | DATABASE SETUP |
|---|
| | | ============== |
|---|
| | | |
|---|
| | | * MySQL |
|---|
| | | ------- |
|---|
| | | * MySQL 4.0.x |
|---|
| | | ------------- |
|---|
| | | Setting up the mysql database can be done by creating an empty database, |
|---|
| | | importing the table layout and granting the proper permissions to the |
|---|
| | | roundcube user. Here is an example of that procedure: |
|---|
| | | |
|---|
| | | # mysql |
|---|
| | | > CREATE DATABASE 'roundcubemail'; |
|---|
| | | > CREATE DATABASE roundcubemail; |
|---|
| | | > GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost |
|---|
| | | IDENTIFIED BY 'password'; |
|---|
| | | > quit |
|---|
| | | # mysql roundcubemail < SQL/mysql.initial.sql |
|---|
| | | |
|---|
| | | |
|---|
| | | * MySQL 4.1.x/5.x |
|---|
| | | ----------------- |
|---|
| | | For MySQL version 4.1 and up, it's recommended to create the database for |
|---|
| | | RoundCube with the following command: |
|---|
| | | > CREATE DATABASE 'roundcubemail' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |
|---|
| | | RoundCube with utf-8 charset. Here's an example of the init procedure: |
|---|
| | | |
|---|
| | | # mysql |
|---|
| | | > CREATE DATABASE roundcubemail DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |
|---|
| | | > GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost |
|---|
| | | IDENTIFIED BY 'password'; |
|---|
| | | > quit |
|---|
| | | |
|---|
| | | # mysql roundcubemail < SQL/mysql5.initial.sql |
|---|
| | | |
|---|
| | | |
|---|
| | | * SQLite |
|---|
