Retired Documentation

You are using the documentation for version 2.11.9. Go here for the latest version or check here for your available upgrades to the latest version.

Unable to perform the SQL queries needed to install this program.¶

MySQL returns the error message “Unable to perform the SQL queries needed to install this program.”

Troubleshooting¶

This error most frequently occurs with some versions of MySQL 5. ExpressionEngine requires the following database privileges:

ALTER
CREATE
DELETE
DROP
INSERT
SELECT
UPDATE

Depending on the configuration of the MySQL server, these permissions may have to be granted explicitly. Also, ExpressionEngine does not work in STRICT_TRANS_TABLES mode. The MySQL manual will have more information on the subject.