DDL sql execution error

DDL sql execution error

by Irith Herman -
Number of replies: 1

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: -
In reply to Irith Herman

Re: DDL sql execution error

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin 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.