Search Engine: Elastic

Article ID: 128636, created on Apr 10, 2016, last review on Jul 14, 2018

  • Applies to:
  • Plesk Automation 11.5


  1. There are two types of MySQL Database hosting nodes(5.1 and 5.5) deployed in Plesk Automation 11.5.

  2. On attempt to connect to database instance using phpMyAdmin following error appears (click on the image below to get an example):


  3. Issue appears when a user opens phpMyAdmin. The last phpMyAdmin session is stored on PA. If database connection initially is established for MySQL 5.5 service node then all future servers will be considered as 5.5 even if they are 5.1.


The behavior was considered as internal software issue #PPA-3069.

The fix is considered to be included in one of the next PA updates.

Please use provided ID to track maintenance in Plesk Automation release notes.

Subscribe to our knowledge base - each product update comes with corresponding KB article:


As a workaround you change default charset for connections to MySQL instances as follows:

  1. Login to PA Management node via SSH as root.
  2. Create backup of original file:

    [root@pa115mn ~]# cp -rp /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/DatabaseInterface.class.php{,.orig}
  3. Modify /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/DatabaseInterface.class.php file as follows:

    [root@pa115mn ~]# diff /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/DatabaseInterface.class.php /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/DatabaseInterface.class.php.orig
    <                 $default_charset = 'utf8';
    <                 $default_collation = 'utf8_general_ci';
    >                 $default_charset = 'utf8mb4';
    >                 $default_collation = 'utf8mb4_general_ci';
    <                 if ($default_charset == 'utf8'
    >                 if ($default_charset == 'utf8mb4'
    <                     $GLOBALS['collation_connection'] = 'utf8_' . substr(
    >                     $GLOBALS['collation_connection'] = 'utf8mb4_' . substr(

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF