{"id":1548,"date":"2017-05-29T14:04:34","date_gmt":"2017-05-29T08:34:34","guid":{"rendered":"https:\/\/blog.pheonixsolutions.com\/?p=1548"},"modified":"2017-05-29T14:12:07","modified_gmt":"2017-05-29T08:42:07","slug":"phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/","title":{"rendered":"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated"},"content":{"rendered":"

<\/code>The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated:<\/h3>\n

Date Posted: 28-05-2017<\/strong><\/p>\n

When we install phpmyadmin on linux machine and we might have seen the following error on the login page. If we click on the error page, we might have get the following\u00a0information on the phpmyadmin page.<\/p>\n

$cfg[‘Servers’][$i][‘relation’] … not OK [ Documentation ]
\nGeneral relation features: Disabled<\/p>\n

$cfg[‘Servers’][$i][‘table_info’] … not OK [ Documentation ]
\nDisplay Features: Disabled<\/p>\n

$cfg[‘Servers’][$i][‘table_coords’] … not OK [ Documentation ]<\/p>\n

$cfg[‘Servers’][$i][‘pdf_pages’] … not OK [ Documentation ]
\nCreation of PDFs: Disabled<\/p>\n

$cfg[‘Servers’][$i][‘column_info’] …not OK [ Documentation ]
\nDisplaying Column Comments: Disabled
\nBrowser transformation: Disabled<\/p>\n

$cfg[‘Servers’][$i][‘bookmarktable’] … not OK [ Documentation ]
\nBookmarked SQL query: Disabled<\/p>\n

$cfg[‘Servers’][$i][‘history’] …not OK [ Documentation ]
\nSQL history: Disabled<\/p>\n

$cfg[‘Servers’][$i][‘designer_coords’] … not OK [ Documentation ]
\nDesigner: Disabled<\/p>\n

$cfg[‘Servers’][$i][‘tracking’] … not OK [ Documentation ]
\nTracking: Disabled<\/p><\/blockquote>\n

The basic phmyadmin installation doesn’t have default configuration which is why we are getting the above error.<\/p>\n

Solution:<\/h4>\n

Inorder to fix the issue, follow the below mentioned steps.<\/p>\n

Take a copy of existing configuration file. The default location will be (\/etc\/phpmyadmin\/config.inc.php).\u00a0<\/em>If the installation path is different then you need to update corresponding configuration.<\/p>\n

vi \/etc\/phpmyadmin\/config.inc.php<\/code><\/p>\n

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';\r\n$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';\r\n$cfg['Servers'][$i]['relation'] = 'pma__relation';\r\n$cfg['Servers'][$i]['table_info'] = 'pma__table_info';\r\n$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';\r\n$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';\r\n$cfg['Servers'][$i]['column_info'] = 'pma__column_info';\r\n$cfg['Servers'][$i]['history'] = 'pma__history';\r\n$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';\r\n$cfg['Servers'][$i]['tracking'] = 'pma__tracking';\r\n$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';\r\n$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';\r\n$cfg['Servers'][$i]['recent'] = 'pma__recent';\r\n\r\n\r\n$cfg['Servers'][$i]['favorite'] = 'pma__favorite';\r\n$cfg['Servers'][$i]['users'] = 'pma__users';\r\n$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';\r\n$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';\r\n$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';\r\n$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';\r\n$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';\r\n$cfg['Servers'][$i]['export_templates']  = 'pma__export_templates';\r\n<\/pre>\n
There is two underscore(__) after pma.<\/p>\n
Save the file and logout from phpmyadmin page.<\/p>\n
Restart the webserver. Incase, if its apache2 on ubuntu host, execute the below command.<\/p>\n
\/etc\/init.d\/apache2 restart<\/code><\/p>\n
Now, the error must be vanished on phpmyadmin page.<\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated: Date Posted: 28-05-2017 When we install phpmyadmin on linux machine and we might have seen the following error on the login page. If we click on the error page, we might have get the following\u00a0information on… Continue Reading The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated<\/span><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[225],"tags":[261,339],"class_list":{"0":"post-1548","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-linux","7":"tag-linux","8":"tag-phpmyadmin","9":"h-entry","11":"h-as-article"},"yoast_head":"\nPheonix Solutions - We Empower Your Business Growth<\/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:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pheonix Solutions - We Empower Your Business Growth\" \/>\n<meta property=\"og:description\" content=\"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated: Date Posted: 28-05-2017 When we install phpmyadmin on linux machine and we might have seen the following error on the login page. If we click on the error page, we might have get the following\u00a0information on… Continue Reading The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-29T08:34:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-29T08:42:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3837\" \/>\n\t<meta property=\"og:image:height\" content=\"2540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\"},\"headline\":\"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated\",\"datePublished\":\"2017-05-29T08:34:34+00:00\",\"dateModified\":\"2017-05-29T08:42:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/\"},\"wordCount\":263,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"keywords\":[\"Linux\",\"Phpmyadmin\"],\"articleSection\":[\"Linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/\",\"name\":\"Pheonix Solutions - We Empower Your Business Growth\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"datePublished\":\"2017-05-29T08:34:34+00:00\",\"dateModified\":\"2017-05-29T08:42:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\\\/\\\/blog.pheonixsolutions.com\"],\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pheonix Solutions - We Empower Your Business Growth","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:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/","og_locale":"en_US","og_type":"article","og_title":"Pheonix Solutions - We Empower Your Business Growth","og_description":"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated: Date Posted: 28-05-2017 When we install phpmyadmin on linux machine and we might have seen the following error on the login page. If we click on the error page, we might have get the following\u00a0information on… Continue Reading The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated","og_url":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2017-05-29T08:34:34+00:00","article_modified_time":"2017-05-29T08:42:07+00:00","og_image":[{"width":3837,"height":2540,"url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/"},"author":{"name":"admin","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503"},"headline":"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated","datePublished":"2017-05-29T08:34:34+00:00","dateModified":"2017-05-29T08:42:07+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/"},"wordCount":263,"commentCount":1,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"keywords":["Linux","Phpmyadmin"],"articleSection":["Linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/","url":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/","name":"Pheonix Solutions - We Empower Your Business Growth","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"datePublished":"2017-05-29T08:34:34+00:00","dateModified":"2017-05-29T08:42:07+00:00","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/phpmyadmin-configuration-storage-not-completely-configured-extended-features-deactivated\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","caption":"admin"},"sameAs":["http:\/\/blog.pheonixsolutions.com"],"url":"https:\/\/pheonixsolutions.com\/blog\/author\/admin\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-oY","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/1548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=1548"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/1548\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=1548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=1548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=1548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}