Just in case you run into the same problem I did when upgrading Roundcube from version 0.9.5 to 1.0.1, I’m posting the exact steps I took to fix the
Error in DDL upgrade problem.
So, you’ve followed the Roundcube upgrade instructions, either using the
installto.sh or the
update.sh script, and then this happens:
Updating database schema (2013042700)... [OK] Updating database schema (2013052500)... [FAILED] ERROR: Error in DDL upgrade 2013052500:  CREATE command denied to user 'roundcube'@'localhost' for table 'cache_shared'All done.
You search around and find this forum post by the author of iRedMail. However, if you’re like me, you need a little more detail to be able to apply his advice. Here’s how:
First connect to mysql using the root account (the password is in the
iRedMail.tips file that was created when you installed iRedMail):
mysql -u root -p
Grant both the
ALTER privileges to the roundcube database user:
GRANT CREATE,ALTER on roundcubemail.* to roundcube@localhost; FLUSH PRIVILEGES; \q
Then finish the upgrade by starting the update script again. In my case, I started with
installto.sh, then ran into the error, then applied the fix and started the
update.sh script in the rountdcube target directory:
$ roundcube-dest/bin/update.sh What version are you upgrading from? Type '?' if you don't know. 0.9.5 Executing database schema update. Updating database schema (2013061000)... [OK] Updating database schema (2014042900)... [OK] This instance of Roundcube is up-to-date. Have fun!