Applicable to:
- Plesk for Linux
Symptoms
- The database database_name cannot be removed. Following error appears:
PLESK_ERROR: There is no such grant defined for user on host
- MySQL query shows the following grants set for 'user':
MYSQL_LIN: mysql> 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'@'%';
Comments
0 comments
Please sign in to leave a comment.