Mysql Error 1142 Troubleshooting method

Error:alter command denied to the user ' xxxx ' @ ' localhost ' for table ' uc_notelist ' errno:1142sql::alter table uc_notelist ADD CO Lumn App1 tinyint NOT NULL indicates that the XXXX user does not have ALTER permission. To MySQL,mysql> SELECT alter_priv from user WHERE user = ' xxxx '; found Alter_priv = ' N ', and sure enough, no permissions. Modify Permissions:mysql> UPDATE user SET alter_priv= ' Y ' WHERE user = ' xxxx ';mysql> flush privileges;

Mysql Error 1142 Troubleshooting method