ERROR 1273 (HY000): Unknown collation: 'utf8mb4_unicode_520_ci'

Today, when importing a MySQL database, I encountered an error message: ERROR 1273 (HY000) at line 129: Unknown collation: 'utf8mb4_unicode_520_ci'. I looked and it seemed that other people had encountered the same problem, so I wrote it down for my reference next time I encounter it. If other readers encounter it, they can also refer to it.

The VPS host installed the LNMP1.8 one-click package, and an error occurred when trying to import the database:

 [root@Server ~]# mysql -u -p.net < blog.sql
ERROR 1273 (HY000) at line 129: Unknown collation: 'utf8mb4_unicode_520_ci'

The solution is also very simple. Open the database with an editor and replace all the "utf8mb4_unicode_520_ci" characters in the database with "utf8mb4_unicode_ci", then import it again and there will be no problem.