MariaDB [(none)]> create database post;
Query OK, 1 row affected (0.008 sec)

MariaDB [(none)]> CREATE USER 'post'@'localhost' IDENTIFIED BY '1234';
Query OK, 0 rows affected (0.024 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON post.*to post@'localhost' with grant option;
Query OK, 0 rows affected (0.005 sec)

MariaDB [(none)]> use post;
Database changed

select * from concept;
select * from quiz;
select * from wrong;

alter table concept default charset = utf8;
ALTER TABLE concept CONVERT TO character SET utf8;

alter table quiz default charset = utf8;
 ALTER TABLE quiz CONVERT TO character SET utf8;

alter table wrong default charset = utf8;
 ALTER TABLE wrong CONVERT TO character SET utf8;