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
- Connect to the server via SSH.
- Log into MySQL.
- Grant all missing privileges for the user over database example:
MYSQL_LIN: mysql> GRANT ALL ON `example`.* TO ‘user’@’%’;