rework mysql connection logic: fixes create_schema flag and properly reconnects to database.  closes #548