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

  • Applies to:
  • Plesk Automation 11.5

Symptoms

  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):

    screenshot

  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.

Cause

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:

https://kb.odin.com/rss/index.html

Resolution

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
    1496,1497c1496,1497
    <                 $default_charset = 'utf8';
    <                 $default_collation = 'utf8_general_ci';
    ---
    >                 $default_charset = 'utf8mb4';
    >                 $default_collation = 'utf8mb4_general_ci';
    1509c1509
    <                 if ($default_charset == 'utf8'
    
    ---
    
    >                 if ($default_charset == 'utf8mb4'
    1512c1512
    <                     $GLOBALS['collation_connection'] = 'utf8_' . substr(
    ---
    >                     $GLOBALS['collation_connection'] = 'utf8mb4_' . substr(
    

Search Words

#1115 - Unknown character set: 'utf8mb4'

mysql charsets comparison

phpMyAdmin error

MySQL 5.1 charset

default database connection charset

unknown character set utf8mb4

Upgrading MySQL

default MySQL charset

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF