Symptoms
-
The following error appears in an attempt to execute:
FLUSH PRIVILEGES
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.
Cause
The lack of permissions for the database user.
Resolution
-
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: