Tag Archives: Mysql Error 1142

Solutions to MySQL error 1142: Error:ALTERcommanddeniedtouser’xxxx’@’localhost’fortable’uc_notelist’

 

Error:ALTERcommanddeniedtouser'xxxx'@'localhost'fortable'uc_notelist'
Errno:1142
SQL::ALTERTABLEuc_notelistADDCOLUMNapp1tinyintNOTNULL

Explain that user xxxx does not have ALTER permission.
Go to mysql and
mysql>SELECTalter_privFROMuserWHEREUser='xxxx';
I found that alter_priv='N',sure enough there is no permission.
Modify the privileges.
mysql>UPDATEuserSETalter_priv='Y'WHEREUser='xxxx';
mysql>flushprivileges;