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

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:

• http://dba.stackexchangestackoverflow.com/questions/12952531967527/mysqltable-mysqlperformance-upgradeschema-errorsession-occurredvariables-cannot-setup-server-variablesdoesnt-exist