{"id":7387,"date":"2021-02-02T10:53:51","date_gmt":"2021-02-02T10:53:51","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=7387"},"modified":"2021-02-02T11:41:18","modified_gmt":"2021-02-02T11:41:18","slug":"cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/","title":{"rendered":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED]"},"content":{"rendered":"<p>Many cPanel users are experiencing the above error within the cPanel interface recently; The error appears within cPanel, giving the impression that MariaDB\/ MySQL is not working. Infect the error is a false positive, MariaDB\/MySQL is infect working perfectly fine.<\/p>\n<p>Another similar error was being reported like this some time ago with &#8220;Exit 255&#8221; code. If you are facing the following MySQL\/MariaDB offline error, then the solution is available on cPanel&#8217;s official website. <a href=\"https:\/\/support.cpanel.net\/hc\/en-us\/articles\/360052622453-cPanel-MySQL-Databases-page-shows-The-MySQL-server-is-currently-offline-adminbin-Cpanel-cpmysql-DBCACHE-exit-255-\" class=\"broken_link\">MariaDB\/ MySQL error<\/a><\/p>\n<div class=\"error-sh\">\n<pre>\"The MySQL server is currently offline. adminbin Cpanel\/cpmysql\/DBCACHE: exit 255\"<\/pre>\n<\/div>\n<p>If the error is with Exit code 11 like below, then the solution listed in this post will apply.<\/p>\n<div class=\"space1\"><\/div>\n<div class=\"error-sh\">\n<pre>\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11:\"<\/pre>\n<\/div>\n<p>on checking the cpanel error log,<\/p>\n<div class=\"space1\"><\/div>\n<div class=\"command-sh\">\n<pre>\/usr\/local\/cpanel\/logs\/error_log<\/pre>\n<\/div>\n<div class=\"space1\"><\/div>\n<p>you will find them entries like this.<\/p>\n<div class=\"error-sh\">\n<pre>Invalid grant string: SET DEFAULT ROLE 0 FOR 'xxxxxxxx'@'xx.xx.xx.xx' [2020-11-10 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request adminbin Cpanel\/cpmysql\/DBCACHE: exit 11: namespace=[Cpanel] module=[cpmysql] function=[DBCACHE]: set error in context mysql: raw_response=[{\"mode\":\"simple\",\"status\":1,\"statusmsg\":\"adminbin Cpanel\/cpmysql\/DBCACHE: exit 11\",\"error\":1,\"exit_code\":2816,\"action\":\"run\",\"version\":\"2.4\",\"timeout\":0,\"data\":\"\"}] at \/usr\/local\/cpanel\/Cpanel\/Wrap.pm line 120, &lt;$socket&gt; line 1. Cpanel::Wrap::send_cpwrapd_request(\"namespace\", \"Cpanel\", \"module\", \"cpmysql\", \"function\", \"DBCACHE\", \"data\", \"\", ...) called at \/usr\/local\/cpanel\/Cpanel\/AdminBin.pm line 57 Cpanel::AdminBin::adminrun(\"cpmysql\", \"DBCACHE\", undef) called at \/usr\/local\/cpanel\/Cpanel\/MysqlFE\/DB.pm line 236 Cpanel::MysqlFE::DB::_initcache() called at \/usr\/local\/cpanel\/Cpanel\/Template\/Plugin\/Mysql.pm line 196\r\n<\/pre>\n<\/div>\n<p>The error is due to the non-compatible order of columns within the &#8220;user&#8221; table of &#8220;MySQL&#8221; database. To fix the issue, you need to alter the MySQL database. We have found the following alter queries to be fixing the issue.<\/p>\n<p>Before you go any further, make a backup of your current MySQL database.<\/p>\n<div class=\"space1\"><\/div>\n<div class=\"command-sh\">\n<pre>mysqldump MySQL &gt; \/root\/mysql-backup.sql<\/pre>\n<\/div>\n<div class=\"space1\"><\/div>\n<p>Then run the following command.<\/p>\n<div class=\"space1\"><\/div>\n<div class=\"command-sh\">\n<pre>mysql -e \"ALTER TABLE mysql.user MODIFY COLUMN password_last_changed timestamp AFTER max_statement_time, MODIFY COLUMN password_lifetime smallint AFTER password_last_changed, MODIFY COLUMN account_locked enum('N','Y') AFTER password_lifetime\"<\/pre>\n<\/div>\n<div class=\"space1\"><\/div>\n<p>And after that, you need to restart the MySQL database.<\/p>\n<div class=\"space1\"><\/div>\n<div class=\"command-sh\">\n<pre>\/scripts\/restartsrv_mysql<\/pre>\n<\/div>\n<div class=\"space1\"><\/div>\n<p>Refresh the MySQL page of cPanel, and the error is gone.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Many cPanel users are experiencing the above error within the cPanel interface recently; The error appears within cPanel, giving the impression that MariaDB\/ MySQL is not working. Infect the error is a false positive, MariaDB\/MySQL is infect working perfectly fine. Another similar error was being reported like this some time ago with &#8220;Exit 255&#8221; code. [&#8230;]<\/p>\n<p><a class=\"understrap-read-more-link\" href=\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/\">Continue Reading&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7387","post","type-post","status-publish","format-standard","hentry","category-cpanel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED] - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED] - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"Many cPanel users are experiencing the above error within the cPanel interface recently; The error appears within cPanel, giving the impression that MariaDB\/ MySQL is not working. Infect the error is a false positive, MariaDB\/MySQL is infect working perfectly fine. Another similar error was being reported like this some time ago with &#8220;Exit 255&#8221; code. [...]Continue Reading...\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Farooq Omer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/\"},\"author\":{\"name\":\"Farooq Omer\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"headline\":\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED]\",\"datePublished\":\"2021-02-02T10:53:51+00:00\",\"dateModified\":\"2021-02-02T11:41:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/\"},\"wordCount\":198,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"articleSection\":[\"Cpanel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/\",\"name\":\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED] - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"datePublished\":\"2021-02-02T10:53:51+00:00\",\"dateModified\":\"2021-02-02T11:41:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"},\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/fokado\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED] - cPanel Plesk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/","twitter_card":"summary_large_image","twitter_title":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED] - cPanel Plesk","twitter_description":"Many cPanel users are experiencing the above error within the cPanel interface recently; The error appears within cPanel, giving the impression that MariaDB\/ MySQL is not working. Infect the error is a false positive, MariaDB\/MySQL is infect working perfectly fine. Another similar error was being reported like this some time ago with &#8220;Exit 255&#8221; code. [...]Continue Reading...","twitter_misc":{"Written by":"Farooq Omer","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/"},"author":{"name":"Farooq Omer","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"headline":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED]","datePublished":"2021-02-02T10:53:51+00:00","dateModified":"2021-02-02T11:41:18+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/"},"wordCount":198,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"articleSection":["Cpanel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/","url":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/","name":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED] - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"datePublished":"2021-02-02T10:53:51+00:00","dateModified":"2021-02-02T11:41:18+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11-solved\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 [SOLVED]"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"},"url":"https:\/\/cpanelplesk.com\/wp62\/author\/fokado\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/7387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=7387"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/7387\/revisions"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=7387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=7387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=7387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}