Make sure Barracuda is enabled and the default character set globally is set to your desired character set in my.cnf.
ALTER DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
Of course, feel free to change the collations to what best suits you.
Then, get all of the queries to update the database tables and columns replacing the values that suit your situation: