Fixes server version parsing in cymysql dialect

Closes #2934

Of note, passes all `dialect/mysql` tests, even though `pymysql` and `mysqlconnector` dialects do not. But, that's beyond the scope of this pullreq.