#1273 - Unknown collation: 'utf8mb4_unicode_ci' cPanel

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I try to import the database into the environment, I keep getting this error: #1273 - Unknown collation: 'utf8mb4_unicode_ci' I have tried to Google around and the only solution I can find is this one https://stackoverflow.com/questions/21190523/phpmysql-error-1273-1273-unknown-collation-utf8mb4-general-ci which as by now isn't much help. I have tried clearing the cookies but it still won't work. Please help!