{"id":8586,"date":"2015-10-17T21:59:42","date_gmt":"2015-10-17T20:59:42","guid":{"rendered":"https:\/\/wp.okra.host\/article\/database-appears-in-mysql-manager-but-not-phpmyadmin\/"},"modified":"2021-03-07T14:32:21","modified_gmt":"2021-03-07T13:32:21","slug":"database-appears-in-mysql-manager-but-not-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/kb.okra.host\/de\/article\/database-appears-in-mysql-manager-but-not-phpmyadmin\/","title":{"rendered":"Datenbank erscheint im MySQL Manager, aber nicht in phpMyAdmin"},"content":{"rendered":"

\u00dcbersicht<\/h2>\n

A MySQL database that appears within the control panel under Databases<\/strong> > MySQL Manager<\/strong> does not show in Databases<\/strong> > phpMyAdmin<\/strong><\/p>\n

Ursache<\/h2>\n

Read permissions have been revoked on that database from the primary user.<\/p>\n

L\u00f6sung<\/h2>\n

Visit Databases<\/strong> > MySQL Manager<\/strong> > Change Mode:<\/em>\u00a0List Databases & Users<\/strong>\u00a0innerhalb der Bedienfeld<\/a>.<\/p>\n

    \n
  1. Select the database that does not appear<\/li>\n
  2. Navigate to\u00a0the primary user<\/li>\n
  3. Lesen Sie<\/em> will be unchecked. Check Lesen Sie<\/em> under privileges.<\/li>\n
  4. Click Save
    \n<\/strong><\/strong><\/p>\n
    \"Sample<\/a><\/p>\n

    Sample permission listing where the database will not appear in phpMyAdmin due to insufficient permissions.<\/p>\n<\/div>\n


    \n<\/a>
    \n<\/strong><\/p>\n<\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"

    Overview A MySQL database that appears within the control panel under Databases > MySQL Manager does not show in Databases > phpMyAdmin Cause Read permissions have been revoked on that database from the primary user. Solution Visit Databases > MySQL Manager > Change Mode:\u00a0List Databases & Users\u00a0within the control panel….<\/p>","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[61],"ht-kb-tag":[],"class_list":["post-8586","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-mysql"],"_links":{"self":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb\/8586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/comments?post=8586"}],"version-history":[{"count":1,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb\/8586\/revisions"}],"predecessor-version":[{"id":8587,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb\/8586\/revisions\/8587"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/media\/8588"}],"wp:attachment":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/media?parent=8586"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb-category?post=8586"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb-tag?post=8586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}