Can't delete database from Plesk: There is no such grant defined for user

Created:

2016-11-16 13:08:27 UTC

Modified:

2017-08-08 13:26:18 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Can't delete database from Plesk: There is no such grant defined for user

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

  • It is not possible to remove database from Plesk:

    Internal error: There is no such grant defined for user 'b_admin_pMZAvZ' on host 'localhost'

    Message There is no such grant defined for user 'b_admin_pMZAvZ' on host 'localhost'
    File DatabaseManagerMySQL.php
    Line 606
    Type PleskUserDBException
  • Database is physically missing from MySQL server:

    # plesk repair mysql

    Checking MySQL database servers ..................................... [OK]

    Repair databases on available servers

    The database b_db_pMZAvZ_tgildia_ru is absent from the database
    server ............................................................ [ERROR]

Resolution

Start repair to recreate database:

# plesk repair mysql

Now you can remove database from Plesk.

Have more questions? Submit a request
Please sign in to leave a comment.