mysql change all tables to utf8mb4 code example

Example 1: Converting mysql tables to charset utf8mb4

ALTER TABLE
    table_name
    CONVERT TO CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

Example 2: Converting mysql tables to charset utf8mb4

ALTER DATABASE
    database_name
    CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_unicode_ci;