QUESTION:

MySQL error during installation: “Specified key was too long. Max key length is 500”



ANSWER:

This error is caused by a bug in MySQL 4.1.1.

MySQL 4.1.1 was an early test release, not a production version of MySQL. The first 4.1.x version deemed suitable for production use is 4.1.7.

Please upgrade your server, or raise a support ticket with your hosting provider and ask them to upgrade MySQL to a release version.