Just tried a fresh install of Moodle 2.2 on Apache 2.2.17 on Ubuntu 11.04, using LAMP stack - PHP 5.3.5 and MYSQL 5.1.54. My server is at home, so I'm only constrained by lack of knowledge, not server administrators.
At the installation section of the install, it halts, with the error:
DDL sql execution error
Debug info: INDEX command denied to user 'xxxxxx'@'localhost' for table 'mdl_config'
CREATE UNIQUE INDEX mdl_conf_nam_uix ON mdl_config (name)
I believe I set the permissions for the MYSQL user account.
I'd appreciate any advice as I'm at a standstill till I resolve the issue.