Skip to main content

[case CPANEL-9751] Phpmyadmin - PHP MySQL library version

linux.system25
I have a problem with the server This message appears when you open phpmyadmin
Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.6.35. This may cause unpredictable behavior. Warning in ./libraries/dbi/DBIMysqli.php#262 mysqli_query(): (HY000/1018): Can't read dir of '.' (errno: 13 - Permission denied) Backtrace ./libraries/dbi/DBIMysqli.php#262: mysqli_query( , string 'SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ', integer 0, ) ./libraries/DatabaseInterface.php#244: PMA\libraries\dbi\DBIMysqli->realQuery( string 'SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ', , integer 1, ) ./libraries/DatabaseInterface.php#1549: PMA\libraries\DatabaseInterface->tryQuery( string 'SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ', NULL, integer 1, boolean false, ) ./libraries/navigation/nodes/Node.php#618: PMA\libraries\DatabaseInterface->fetchValue(string 'SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ') ./libraries/navigation/NavigationTree.php#1352: PMA\libraries\navigation\nodes\Node->getPresence() ./libraries/navigation/NavigationTree.php#850: PMA\libraries\navigation\NavigationTree->_fastFilterHtml() ./libraries/navigation/Navigation.php#43: PMA\libraries\navigation\NavigationTree->renderState() ./libraries/Header.php#428: PMA\libraries\navigation\Navigation->getDisplay() ./libraries/Response.php#266: PMA\libraries\Header->getDisplay() ./libraries/Response.php#279: PMA\libraries\Response->_getDisplay() ./libraries/Response.php#443: PMA\libraries\Response->_htmlResponse() PMA\libraries\Response::response()

Comments

12 comments

Date Votes
  • SysSachin
    Hello, Please check if there is any error message while restarting the MySQL service. Restart MySQL service through command line.
    0
  • Eminds
    Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.6.35 Check the versions of mysql libraries and compile the required modules
    0
  • cPanelMichael
    Hello,
    Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.6.35. This may cause unpredictable behavior.

    Internal case CPANEL-9751 is open to address an issue where version 5.1 of the MySQL client library results in a warning message upon accessing phpMyAdmin in cPanel 64. I'll update this thread once we've published a resolution. In the meantime, you can safely ignore this warning message.
    Warning in ./libraries/dbi/DBIMysqli.php#262 mysqli_query(): (HY000/1018): Can't read dir of '.' (errno: 13 - Permission denied)

    This looks like a separate error message. Could you review /var/lib/mysql and verify no rogue directories exist (e.g. directories unrelated to actual databases)? Thank you.
    0
  • Outlier
    I just want to let you know that I have the exact same issue. When I log into phpmyadmin, I see a message at the bottom saying: "Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.6.35. This may cause unpredictable behavior." I noticed this after I updated my cPanel version (from build 62 to 64) and I don't remember seeing this message before the update (it could've been there, if it was I didn't notice it). So far I don't notice any problems but this is concerning to me because this database is going to be filled with hundreds of products and product attributes and potentially years of customer data. I wouldn't want to see a corrupted database in the future which would instantly cripple the website. What should I do? Ignore the warning as some people have suggested?
    0
  • cPanelMichael
    So far I don't notice any problems but this is concerning to me because this database is going to be filled with hundreds of products and product attributes and potentially years of customer data. I wouldn't want to see a corrupted database in the future which would instantly cripple the website. What should I do? Ignore the warning as some people have suggested?

    Hello, You can safely ignore this warning message until a resolution (internal case CPANEL-9751) is published. Thank you.
    0
  • Serverkh
    Hi. i see this warning in phpmyadmin: Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.6.35. This may cause unpredictable behavior. How i can update PHP MySQL library? when this problem happened, in wordpress log i see this: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
    0
  • nhadsall
    I have the same issue with phpmyadmin. No news yet on this?
    0
  • cPanelMichael
    Hello, The warning message will no longer appear with the inclusion of phpMyAdmin 4.7 in cPanel version 66. There's no additional update to report on the removal of the warning message in cPanel 64 at this time, however I will update this thread as soon as more information is available. You can use the following command as a temporary workaround to hide the message in the meantime:
    echo "\$cfg['ServerLibraryDifference_DisableWarning"> = 'true';" >> /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php
    Thank you. Update: cPanel 64 is now EOL, and thus no further updates to it are planned. The referenced case is fixed as of cPanel 66.
    0
  • Outlier
    The warning message will no longer appear with the inclusion of phpMyAdmin 4.7 in cPanel version 66. There's no additional update to report on the removal of the warning message in cPanel 64 at this time

    When I log into cPanel, I see an option to update to version 64.0.20. If I update to that, will I still see the warning message? If so, should I just ignore this update and wait until I see the option to update to version 66?
    0
  • cPanelMichael
    When I log into cPanel, I see an option to update to version 64.0.20. If I update to that, will I still see the warning message? If so, should I just ignore this update and wait until I see the option to update to version 66?

    This case isn't fixed in cPanel 64.0.20, but you should still update to that build to receive resolutions for other issues. You can find the full cPanel 64 Change Log at: 64 Change Log - Change Logs - cPanel Documentation Thank you.
    0
  • Outlier
    You can use the following command as a temporary workaround to hide the message in the meantime:
    echo "\$cfg['ServerLibraryDifference_DisableWarning"> = 'true';" >> /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

    Cosmetically, I don't mind if the message is displayed. I'm more concerned if there is actually a real problem that can cause unpredictable behavior of the database. Based on your workaround to hide the message, is this more of a cosmetic issue where that message text is showing up when it shouldn't or is this a deeper problem that truly can affect the behavior of the database?
    0
  • cPanelMichael
    Cosmetically, I don't mind if the message is displayed. I'm more concerned if there is actually a real problem that can cause unpredictable behavior of the database. Based on your workaround to hide the message, is this more of a cosmetic issue where that message text is showing up when it shouldn't or is this a deeper problem that truly can affect the behavior of the database?

    This should not result in any issues with your databases. Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post