{"id":3254,"date":"2020-11-11T05:29:37","date_gmt":"2020-11-10T23:59:37","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=3254"},"modified":"2023-01-23T17:05:52","modified_gmt":"2023-01-23T11:35:52","slug":"cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/","title":{"rendered":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11"},"content":{"rendered":"\n<p>Because of Bug in the CPanel release lots of our client are facing issue that MySQL is showing down in cPanel interface. But the MySQL\/MariaDB was still running. It\u2019s only the cPanel interface that was showing the error. And cPanel error logs were being populated with below string.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Invalid grant string: SET DEFAULT ROLE 0 FOR 'xxxxxxxx'@'xx.xx.xx.xx'\n&#91;2020-11-10  -0500] warn &#91;cpanel] Cpanel::Wrap::send_cpwrapd_request adminbin Cpanel\/cpmysql\/DBCACHE: exit 11: namespace=&#91;Cpanel] module=&#91;cpmysql] function=&#91;DBCACHE]: set error in context mysql: raw_response=&#91;{\"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.\n        Cpanel::Wrap::send_cpwrapd_request(\"namespace\", \"Cpanel\", \"module\", \"cpmysql\", \"function\", \"DBCACHE\", \"data\", \"\", ...) called at \/usr\/local\/cpanel\/Cpanel\/AdminBin.pm line 57\n        Cpanel::AdminBin::adminrun(\"cpmysql\", \"DBCACHE\", undef) called at \/usr\/local\/cpanel\/Cpanel\/MysqlFE\/DB.pm line 236\n        Cpanel::MysqlFE::DB::_initcache() called at \/usr\/local\/cpanel\/Cpanel\/Template\/Plugin\/Mysql.pm line 196<\/code><\/pre>\n\n\n\n<p>To fix the issue please follow below steps.<\/p>\n\n\n\n<p>First backup your MySQL database<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump mysql &gt; \/root\/mysql.sql<\/code><\/pre>\n\n\n\n<p>The we have to alter the database column order. You can do it by running below command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>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\"<\/code><\/pre>\n\n\n\n<p>Then restart the MySQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/scripts\/restartsrv_mysql <\/code><\/pre>\n\n\n\n<p>And the error showing up in cPanel will be gone.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Because of Bug in the CPanel release lots of our client are facing issue that MySQL is showing down in cPanel interface. But the MySQL\/MariaDB was still running. It\u2019s only the cPanel interface that was showing the error. And cPanel error logs were being populated with below string. To fix the issue please follow below [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3502,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[30,38,33],"tags":[32,165,25],"class_list":["post-3254","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-cloudlinux","category-cpanel","tag-cpanel","tag-mariadb","tag-mysql"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 | 24x7serversupport Blog<\/title>\n<meta name=\"description\" content=\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 | 24x7serversupport Blog\" \/>\n<meta property=\"og:description\" content=\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-10T23:59:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-23T11:35:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/\",\"name\":\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp?fit=900%2C350&ssl=1\",\"datePublished\":\"2020-11-10T23:59:37+00:00\",\"dateModified\":\"2023-01-23T11:35:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"description\":\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11\",\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp?fit=900%2C350&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp?fit=900%2C350&ssl=1\",\"width\":900,\"height\":350,\"caption\":\"adminbin Cpanel\/cpmysql\/DBCACHE: exit 11\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 | 24x7serversupport Blog","description":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11","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:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/","og_locale":"en_US","og_type":"article","og_title":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 | 24x7serversupport Blog","og_description":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11","og_url":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/","og_site_name":"24x7serversupport Blog","article_published_time":"2020-11-10T23:59:37+00:00","article_modified_time":"2023-01-23T11:35:52+00:00","og_image":[{"width":900,"height":350,"url":"https:\/\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp","type":"image\/webp"}],"author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/","url":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/","name":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11 | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#primaryimage"},"image":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp?fit=900%2C350&ssl=1","datePublished":"2020-11-10T23:59:37+00:00","dateModified":"2023-01-23T11:35:52+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"description":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11","breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#primaryimage","url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp?fit=900%2C350&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp?fit=900%2C350&ssl=1","width":900,"height":350,"caption":"adminbin Cpanel\/cpmysql\/DBCACHE: exit 11"},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/cpanel-mysql-mariabb-error-adminbin-cpanel-cpmysql-dbcache-exit-11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"cPanel MySQL\/MariaBB error: adminbin Cpanel\/cpmysql\/DBCACHE: exit 11"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/Cara-mengatasi-The-MySQL-server-is-currently-offline.-adminbin-Cpanel-cpmysql-DBCACHE-exit-11.webp?fit=900%2C350&ssl=1","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=3254"}],"version-history":[{"count":2,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3254\/revisions"}],"predecessor-version":[{"id":3503,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3254\/revisions\/3503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media\/3502"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=3254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=3254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=3254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}