utf8mb4 Encoding error with phpMyAdmin and remote MySQL database

Question

I am trying to use phpMyAdmin to access a remote MySQL database so I created a config.inc.php file (copying config.sample.inc.php) and added a server. Now this other server appear as an option in the login page but when connecting I receive this error: MySQL said #1115 - Unknown character set: 'utf8mb4'. Is there a workaround? Is there a configuration I can set? Any help highly appreciated.

Answer 1

OPEN

C:\wamp\apps\phpmyadmin4.1.14\libraries\DatabaseInterface.class.php

search for 'utf8mb4' and replace it with 'utf8' in two consecutive lines like below

 $default_charset = 'utf8';
 $default_collation = 'utf8_general_ci';

Answer 2

Edit the following files:

<install path>/libraries/DatabaseInterface.class.php
<install path>/libraries/mysql_charsets.lib.php

And change all instances of 'utf8mb4' to 'utf8'.

It seems to have worked for me.