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.

Symptoms

During a new installation of Revive Adserver on MySQL, after asking for the details of the database to install into, Revive Adserver gives an error that it can not execute a "SET NAMES" query, and notes that there is an "Unknown character set".

Troubleshooting Process

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 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://stackoverflow.com/questions/31967527/table-performance-schema-session-variables-doesnt-exist