Cannot remove MySQL database: There is no such grant defined for user on host

Symptoms

• The database “example” cannot be removed or it’s not possible to assign an existing database user Domains > example.com > Databases > User Management > dbuser > Database section. Following error appears:

  PLESK_ERROR: There is no such grant defined for user on host

• MySQL query shows the following grants set for ‘user’:

  # plesk db “SHOW GRANTS FOR ‘user’;”
  | Grants for [email protected]%                                              |            
  | GRANT USAGE ON . TO ‘user’@’%’ IDENTIFIED BY PASSWORD ‘*****’  |            
  1 rows in set (0.00 sec)

Cause

Insufficient permissions for the user over database example.

Resolution

1. Connect to the server via SSH.
2. Log into MySQL.
3. Grant all missing privileges for the user over database example:

   MYSQL_LIN: mysql> GRANT ALL ON `example`.* TO ‘user’@’%’;