Error: uninitialized constant MysqlCompat::MysqlRes

After upgrade to Ubuntu 12.04, my rails application show this error. It turn out the upgrade did upgrade mysql to version 5.5 , then we need rebuild the mysql gem. Just uninstall the mysql gem then install it again.