Unable to integrate 360 Monitoring from Plesk Monitoring extension: 1146 Table 'mysql.global_priv' doesn't exist

Symptoms

• An attempt to integrate 360 Monitoring from Plesk Monitoring extension fails with the error:

  DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mysql.global_priv' doesn't exist, query was: SELECT * FROM mysql.global_priv WHERE User = ? AND Host = '127.0.0.1'

Cause

MySQL upgrade process has not been applied after a dist-upgrade or similar.

Resolution

1. Connect to the server via SSH

2. Run the pending MySQL upgrade command:

   # MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql_upgrade -uadmin mysql