Revive Adserver Installation Fails: Can Not Execute "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. To confirm, connect to the MySQL server, and run the following command: SHOW VARIABLES LIKE 'character_set_database';
If this returns the error Table 'performance_schema.session_variables' doesn't exist, this confirms the issue.
To resolve the issue with MySQL, see: