Hi,
I installed Roundcube under Ubuntu 14.04 but when the installer tests the config I got this error message:
"Check DB config
DSN (write): NOT OK(SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO))
Make sure that the configured database exists and that the user has write privileges
DSN: mysql://roundcube:@localhost/roundcubemail"
I have a user roundcube and he is member of www-data. When I put in mysql > "GRANT ALL PRIVILEGES ON roundcube.* TO roundcube:@localhost/roundcubemail IDENTIFIED BY 'myPassword';"
I get the error:
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 'quit GRANT ALL PRIVILEGES ON roundcube.* TO roundcube:@localhost/roundcubemail I' at line 1"
Of course I tried a few variations of the syntax but that doesn't help. Where can I find the right syntax?
Thanx
Harold