I had some trouble with the instructions in the INSTALL file.
There appear to extra quotes around the database name which
causes a syntax error.
Under the section for DATABASE SETUP the instructions describe how to create
a database for MySQL 4.0.x and MySQL 4.1.x/5.x:
* MySQL 4.0.x
-------------
> CREATE DATABASE 'roundcubemail';
* MySQL 4.1.x/5.x
-----------------
> CREATE DATABASE 'roundcubemail' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Both of these give me a syntax error similar to this:
mysql> CREATE DATABASE 'roundcubemail' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''roundcubemail' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
The problem apears to be the single quotes around the database name.
The following syntax works:
CREATE DATABASE roundcubemail DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
This happens to me on MySQL 4.1.20 and MySQL 5.0.24.
I'm not a MySQL expert.
Yours,
Noah