Use mySQL charset in connection string instead of SET NAMES (#7232)

And switch to utf8mb4 as it is what we're using right now in db schema.