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
PreviousError 1141: There is no such grant defined for user on hostNextError 1143: command denied to user for column in table
Last updated
Was this helpful?