Error 1142: command denied to user for table

Error Code
SQLSTATE
Error
Description

1142

42000

ER_TABLEACCESS_DENIED_ERROR

%s command denied to user '%s'@'%s' for table '%s'

Possible Causes and Solutions

The user is trying to access a table or a column from a table they do not have access to. See GRANT for details on setting permissions.

See Also

This page is licensed: CC BY-SA / Gnu FDL

Last updated

Was this helpful?