The following error appears in an attempt to execute:
via Subscriptions > example.com > Databases > Database_name > phpMyAdmin > SQL:
PLESK_ERROR: MySQL said:
#1227 – Access denied; you need (at least one of) the RELOAD privilege(s) for this operation”
The corresponding database user has no marked RELOAD permission under Tools & Settings > Database Servers > MySQL > User accounts > John Doe > Edit privileges > Administration.
The lack of permissions for the database user.
Go to Tools & Settings > Database Servers and click the icon opposite the MySQL database server:
Navigate to the User accounts page and click the Edit privileges link opposite the required database user:
Mark the RELOAD permission in the Administration list and press the GO button: