The MySQL error "INDEX command denied to user 'webx'@'localhost'" occurs when a database user attempts to create an index but lacks the necessary permission.
Cause
The database user does not have the INDEX privilege. This commonly occurs with:
- Database migrations
- CMS installations that attempt to create table indexes
- Importing SQL dumps that contain CREATE INDEX statements
Solution
The permission can be granted by a user with appropriate privileges:
GRANT INDEX ON databasename.* TO 'webx'@'localhost'; FLUSH PRIVILEGES;
Note for Managed Server Customers
On managed servers with administration software (Plesk, LiveConfig, Confixx), database permissions are controlled through the administration interface. Do not change permissions manually, as they may be reset during the next synchronization run.
If you have questions about MySQL configuration, contact info@ingate.de.
