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;

Similar Posts:

• error: permission denied to create database [How to Solve]
• ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
• MySQL Lock Error: Lock wait timeout exceeded [How to Solve]
• The unknown host problem of FTP IPv6 in zZW Linux
• [github] Push remote: Invalid username or password
• Didn’t find class “xxxxx” on Path: dexpathlist caused by code obfuscation
• [Solved] Vue3 vite Error: Uncaught ReferenceError: require is not defined
• Error in connecting to MySQL via Navicat on MAC
• mysql 1449 The user specified as a definer does not exist
• MySQL Connect Error: Authentication plugin ‘caching_sha2_password’ cannot be loaded