Fix specs for mysql_database/mysql_user and fix providers.

Further changes to fix various errors uncovered by testing and ensure
all tests pass and test real things.