COLLATE=utf8mb4_unicode_ci; silip,
CHARSET=utf8mb4;

COLLATE silinip CHARSET=utf8mb4; yapın.

CREATE TABLE `wp_8_yoast_seo_meta` (
  `object_id` bigint(20) UNSIGNED NOT NULL,
  `internal_link_count` int(10) UNSIGNED DEFAULT NULL,
  `incoming_link_count` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;