When attempting to use the "copy database" function in phpMyAdmin, I receive a 500 error. This occurs regardless of whether I am logged into phpMyAdmin as root or under a particular user account. The exact error that is logged appears in the cPanel error log, not in PHP, MySQL, Apache, or phpMyAdmin logs:
From a look at the cPanel update logs and various threads, it appears that cPanel has been trying to work with MySQL 5 and 5.5 and probably a recent cPanel update to 11.46.0 (build 17) (the recommended version on the RELEASE track) resulted in a downgrade to phpMyAdmin 4.0.10.5. But cPanel folks still need to tweak the cpanel.interface.lib.php file to work with both MySQL 5 and 5.5.
I am running MySQL 5.5.40 with cPanel 11.46 and phpMyAdmin 4.0.10.5. Can I force upgrade phpMyAdmin to 4.2.x and will that fix the problem?
Or is there some kind of tweak to my MySQL installation that I can use to fix this?
See also these other, possibly related threads:
[Case 132253] phpMyAdmin 4.2.9 requires MySQL 5.5 but cPanel can update to 11.46 with MySQL 5.1
Cannot copy a Database or rename it under myphpadmin using WHM as root
The problem did not occur last week when I was running MySQL 5 and a different version of phpMyAdmin.PHP Fatal error: Call to a member function query() on a non-object in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/cpanel_interface.lib.php on line 255
From a look at the cPanel update logs and various threads, it appears that cPanel has been trying to work with MySQL 5 and 5.5 and probably a recent cPanel update to 11.46.0 (build 17) (the recommended version on the RELEASE track) resulted in a downgrade to phpMyAdmin 4.0.10.5. But cPanel folks still need to tweak the cpanel.interface.lib.php file to work with both MySQL 5 and 5.5.
I am running MySQL 5.5.40 with cPanel 11.46 and phpMyAdmin 4.0.10.5. Can I force upgrade phpMyAdmin to 4.2.x and will that fix the problem?
Or is there some kind of tweak to my MySQL installation that I can use to fix this?
See also these other, possibly related threads:
[Case 132253] phpMyAdmin 4.2.9 requires MySQL 5.5 but cPanel can update to 11.46 with MySQL 5.1
Cannot copy a Database or rename it under myphpadmin using WHM as root