It would be nice to know how you solved that problem as I have the same one here.
First I created a new database in the MySQL menu of my webhoster, imported the mysql.initial.sql to create the tables and ran the installer. Both config files created properly with correct access details to the database (username, DB, password,...). But initializing the database causes this error:
DB Schema: NOT OK(Error creating database schema: MDB2 Error: syntax error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: /*!40014 SET FOREIGN_KEY_CHECKS=0 */; ] [Native code: 1064] [Native message: 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 '; ' at line 5] )
Even if I drop all tables in the DB and run the installer (to maybe create the tables bit itself) does not work.
http://img280.imagevenue.com/img.php?image=70343_Unbenannt_122_207lo.JPG The DB is a MySQL 5 one.
The advice in the install-file also does not work:
# mysql
CREATE DATABASE roundcubemail /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost
IDENTIFIED BY 'password';
quit
>> "#1044 - Access denied for user 'db305468_1'@'127.0.0.3' to database 'roundcubemail' "
Can anybody help me? I am getting really frustrated and it will take not long and I will delete Roundcube.