Revive Adserver Installation Fails: Can Not Execute "SET NAMES" Query.

A troubleshooting guide to help when Revive Adserver won't install with an error about being unable to execute a "SET NAMES" query.

...

The underlying MySQL installation may have become corrupted after an upgrade of MySQL. To confirm, connect to the MySQL server, and run the following command: 

SHOW VARIABLES LIKE 'character_set_database';

If this returns the error Table the MySQL installation is corrupted, the following error will be returned:

Table 'performance_schema.session_variables' doesn't exist

...

To resolve the issue with MySQL, see:

...