Author Topic: RoundCube database error  (Read 5342 times)

Offline HaroldQ

  • Newbie
  • *
  • Posts: 1
RoundCube database error
« on: August 17, 2015, 07:00:22 PM »
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

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: RoundCube database error
« Reply #1 on: August 18, 2015, 03:12:10 AM »
Your problem seem to be with MySQL, why don't you check out the documentation: https://dev.mysql.com/doc/refman/5.1/en/grant.html