{"id":394,"date":"2024-02-29T11:48:52","date_gmt":"2024-02-29T18:48:52","guid":{"rendered":"https:\/\/www.businesstechnologyassociates.com\/blog\/?p=394"},"modified":"2024-02-29T11:48:52","modified_gmt":"2024-02-29T18:48:52","slug":"upgrading-drupal-and-blocked-by-mysql-library-version","status":"publish","type":"post","link":"https:\/\/www.businesstechnologyassociates.com\/blog\/2024\/02\/upgrading-drupal-and-blocked-by-mysql-library-version\/","title":{"rendered":"Upgrading Drupal and blocked by MySQL library version"},"content":{"rendered":"<p>Recently I was upgrading a Drupal installation to version 9.5.11 and when in maintenance mode, received the error:<\/p>\n<p><code>10.5.20-MariaDB-cll-lve-log<br \/>\nThe libmysqlclient driver version 3.1.21 is less than the minimum required version. Upgrade to libmysqlclient version 5.5.3 or up, or alternatively switch mysql drivers to MySQLnd version 5.0.9 or up.<\/code><\/p>\n<p>Since this installation was on a shared hosting account, I have limited control over the software version.\u00a0 I could switch to the <code>MySQLnd<\/code> driver. The MySQL native driver for PHP (mysqlnd) is a drop-in replacement for the MySQL Client Library (libmysql) for the PHP script language.<\/p>\n<p>To make the change in cPanel, find the &#8220;<strong><em>Select PHP Version<\/em><\/strong>&#8221; in the <em><strong>Software<\/strong><\/em> section and click to select.\u00a0 In the &#8220;<strong><em>PHP Extension<\/em><\/strong>&#8221; tab make the following changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-397\" src=\"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-content\/uploads\/2024\/02\/cPanel_PHP_MySQL_options.png\" alt=\"PHP Extensions image\" width=\"740\" height=\"710\" srcset=\"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-content\/uploads\/2024\/02\/cPanel_PHP_MySQL_options.png 740w, https:\/\/www.businesstechnologyassociates.com\/blog\/wp-content\/uploads\/2024\/02\/cPanel_PHP_MySQL_options-300x288.png 300w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/p>\n<p>After doing this you should be able to continue your Drupal upgrade with no error.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently I was upgrading a Drupal installation to version 9.5.11 and when in maintenance mode, received the error: 10.5.20-MariaDB-cll-lve-log The libmysqlclient driver version 3.1.21 is less than the minimum required version. Upgrade to libmysqlclient version 5.5.3 or up, or alternatively switch mysql drivers to MySQLnd version 5.0.9 or up. Since this installation was on a &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.businesstechnologyassociates.com\/blog\/2024\/02\/upgrading-drupal-and-blocked-by-mysql-library-version\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Upgrading Drupal and blocked by MySQL library version&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,34,14],"tags":[],"class_list":["post-394","post","type-post","status-publish","format-standard","hentry","category-drupal","category-how-to","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/posts\/394","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/comments?post=394"}],"version-history":[{"count":4,"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/posts\/394\/revisions"}],"predecessor-version":[{"id":399,"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/posts\/394\/revisions\/399"}],"wp:attachment":[{"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/media?parent=394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/categories?post=394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesstechnologyassociates.com\/blog\/wp-json\/wp\/v2\/tags?post=394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}