Installing and upgrading help

DDL sql execution error

Picture of Irith Herman
DDL sql execution error

on installing new MOODLE 2.3

I get this error:

DDL sql execution error

More information about this error

It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation.


Debug info: ALTER command denied to user 'xxxx'@'localhost' for table 'mdl_config'
ALTER TABLE mdl_config COMMENT='Moodle configuration variables'
Error code: ddlexecuteerror

Average of ratings: -
Tim at Lone Pine Koala Sanctuary
Re: DDL sql execution error
Core developersDocumentation writersParticularly helpful MoodlersPlugin developers

I think that the error message tells you exactly what the problem is. To fix it, you need to do 

GRANT ALL ON moodle TO 'xxxx'@'localhost'

or somethign like that.

Average of ratings: -