Error is returned when executing FLUSH PRIVILEGES in Plesk via phpMyAdmin: “Access denied; you need (at least one of) the RELOAD privilege(s) for this operation”

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

1. Log in to Plesk.

2. Go to Tools & Settings > Database Servers and click the  icon opposite the MySQL database server:

   

3. Navigate to the User accounts page and click the Edit privileges link opposite the required database user:

   

4. Mark the RELOAD permission in the Administration list and press the GO button: