How can I change the collations in my MySQL 5.6 DB to utf8mb4_unicode_ci?

Ram Freedman

Member
Jul 18, 2017
7
0
1
Israel
cPanel Access Level
Website Owner
Hi,

I have in my DB (MySQL 5.6 in a shared hosting server) several collations and I want to set all of them to utf8mb4_unicode_ci collation and also change the connection charset to utf8mb4

How can I do it using phpMyAdmin for my DB without going table by table?

Thanks!
Ram