Setup wizard fails when installing to MySQL 5 InnoDB

This is mostly a known issue; however, it is not documented and it shouldn't even need manual intervention to fix. The problem is the length of UTF8 keys due to three-byte characters in the database. The workaround:

1. Create the databases as latin1:

mysql> create database crowdiddb character set latin1;
mysql> create database crowd character set latin1;

2. Change the connection character set in the MySQL connection URL from utf8 to latin1.