For table, we could use

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

For database, we could use

ALTER DATABASE database_name charset=utf8;