In Gentoo, what is the difference between
mysql compiled with
This split just reflects MySQL's confusing naming. Check out their change history for 5.0 to see what happened.
The latest versions are all in "mysql" so unless you need a previous version, you'll just want to emerge mysql with the "community" flag.