{"id":39727,"date":"2021-03-23T14:46:05","date_gmt":"2021-03-23T13:46:05","guid":{"rendered":"https:\/\/staging.kinsta.site\/?post_type=knowledgebase&#038;p=86689"},"modified":"2021-07-08T10:54:03","modified_gmt":"2021-07-08T09:54:03","slug":"database-manager","status":"publish","type":"knowledgebase","link":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/","title":{"rendered":"Database Manager"},"content":{"rendered":"<p>Adminer er en brugergr\u00e6nseflade til manipulation af din database. Det ligner meget p\u00e5 phpMyAdmin, men har et meget reduceret fodaftryk og er derfor snappere at arbejde med. For dokumentation se <a href=\"https:\/\/www.adminer.org\/\">Adminers websted<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large\" src=\"https:\/\/staging.kinsta.site\/wp-content\/uploads\/2021\/01\/adminer-1024x570.png\" alt=\"Adminer user interface\" width=\"1024\" height=\"570\"><\/p>\n<h2 id=\"accessing-database-manager\">Adgang til Database Manager<\/h2>\n<p>Du kan f\u00e5 adgang til Database manager p\u00e5 tre m\u00e5der.<\/p>\n<ul>\n<li>Klik p\u00e5 menuen &#8220;Mere&#8221; (tre prikker) p\u00e5 listen over websteder, og v\u00e6lg &#8220;\u00c5bn Database manager&#8221;<\/li>\n<li>Klik p\u00e5 knappen &#8220;Database manager&#8221; \u00f8verst p\u00e5 siden med webstedsdetaljer<\/li>\n<li>Database manager er tilg\u00e6ngelig p\u00e5 port <code>15001<\/code> p\u00e5 dit websteds IP (som du kan finde p\u00e5 siden med detaljer om siden)<\/li>\n<\/ul>\n<h2 id=\"basic-usage\">Grundl\u00e6ggende brug<\/h2>\n<h3 id=\"switching-databases\">Skift af databaser<\/h3>\n<p>N\u00e5r du bes\u00f8ger Adminer ved at klikke p\u00e5 en knap i DevKinsta, f\u00f8res du altid automatisk til den relevante database, men du kan ogs\u00e5 skifte mellem dem inden for Adminer. Du kan skifte mellem databaser ved hj\u00e6lp af rullemenuen \u00f8verst i venstre sidebar.<\/p>\n<h3 id=\"viewing-table-structure\">Visning af struktur<\/h3>\n<p>Hvis du klikker p\u00e5 et hvilket som helst tabelnavn i sidebaren, kommer du til strukturoversigten for den p\u00e5g\u00e6ldende tabel. Du kan se hvert felt og den type data, det indeholder.<\/p>\n<h3 id=\"viewing-table-data\">Visning af tabeldata<\/h3>\n<p>Ved at klikke p\u00e5 &#8220;V\u00c6LG&#8221; i sidebar ved siden af \u200b\u200btabelnavnet, f\u00f8res du til en side, der viser dig de f\u00f8rste 50 emner i den p\u00e5g\u00e6ldende tabel. Du kan dykke ned i forskellige dele af tabellen ved hj\u00e6lp af kontrollerne \u00f8verst p\u00e5 siden.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large\" src=\"https:\/\/staging.kinsta.site\/wp-content\/uploads\/2021\/01\/adminer-select-1024x268.png\" alt=\"Adminer select data\" width=\"1024\" height=\"268\"><\/p>\n<p>Du skal klikke p\u00e5 den bl\u00e5 titel over felterne for at f\u00e5 adgang til de formularer, de indeholder. Du kan derefter oprette visninger ved hj\u00e6lp af flere direktiver for valg, s\u00f8gning, sortering, begr\u00e6nsning og l\u00e6ngde. Bem\u00e6rk, at dine s\u00f8gninger er tilknyttet URL&#8217;en, s\u00e5 du kan gemme visninger ved at bogm\u00e6rke siden.<\/p>\n<p>Hvis du har brug for en mere detaljeret SQL-foresp\u00f8rgsel for at se data, kan du klikke p\u00e5 rediger ud for foresp\u00f8rgslen, der vises \u00f8verst p\u00e5 sk\u00e6rmen for at f\u00e5 adgang til en SQL-editor.<\/p>\n<h3 id=\"manipulating-data\">Manipulering af data<\/h3>\n<p>Du kan redigere enhver r\u00e6kke ved at klikke p\u00e5 inket til redigering i resultaterne. N\u00e5r du er p\u00e5 den valgte dataside, kan du tilf\u00f8je nye emner ved at klikke p\u00e5 knappen &#8220;NYT OBJEKT&#8221;. Dette giver dig en formular med alle felterne, der skal udfyldes.<\/p>\n<p>Du kan k\u00f8re komplekse SQL-foresp\u00f8rgsler ved at klikke p\u00e5 &#8220;SQL COMMAND&#8221; -linket \u00f8verst i sidepanelet. Dette f\u00f8rer dig til SQL-editoren, hvor du kan skrive din foresp\u00f8rgsel. Ved at klikke p\u00e5 &#8220;Historik&#8221; i feltet under redakt\u00f8ren vises kommandoer, der for nylig er k\u00f8rt, du kan indl\u00e6se.<\/p>\n<h2 id=\"go-deeper-via-command-line\">G\u00e5 dybere via kommandolinjen<\/h2>\n<p>Hvis du gerne vil manipulere din database via konsol, kan du g\u00f8re det.<\/p>\n<h3 id=\"enter-through-virtual-machine\">G\u00e5 ind via virtuel maskine<\/h3>\n<pre class=\"language-shell\"><code># Enter into devkinsta_db container\ndocker exec -it devkinsta_db bash\n\n# Connect to database\nmysql -h localhost -u root -p\n\n# Run SQL commands\nshow databases;<\/code><\/pre>\n<h3>Indtast gennem host maskinen<\/h3>\n<p>Du kan finde disse oplysninger p\u00e5 siden med oplysninger om webstedet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large\" src=\"https:\/\/staging.kinsta.site\/wp-content\/uploads\/2021\/01\/site-db-info-1024x309.png\" alt=\"Database details\" width=\"1024\" height=\"309\"><\/p>\n<pre class=\"language-shell\"><code># Enter into database directly from host OS\nmysql -h 192.168.99.254 -P 15100 -u root -p<\/code><\/pre>\n","protected":false},"author":115,"featured_media":39705,"parent":39703,"menu_order":8,"template":"","tags":[],"knowledge_categories":[299],"topic":[],"class_list":["post-39727","knowledgebase","type-knowledgebase","status-publish","has-post-thumbnail","hentry","knowledge_categories-devkinsta"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v17.1.2 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database Manager - DevKinsta - Kinsta<\/title>\n<meta name=\"description\" content=\"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Manager\" \/>\n<meta property=\"og:description\" content=\"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-08T09:54:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_dk\" \/>\n<meta name=\"twitter:label1\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/\",\"url\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/\",\"name\":\"Database Manager - DevKinsta - Kinsta\",\"isPartOf\":{\"@id\":\"https:\/\/staging.kinsta.site\/dk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg\",\"datePublished\":\"2021-03-23T13:46:05+00:00\",\"dateModified\":\"2021-07-08T09:54:03+00:00\",\"description\":\"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#breadcrumb\"},\"inLanguage\":\"da-DK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#primaryimage\",\"url\":\"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg\",\"contentUrl\":\"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg\",\"width\":1200,\"height\":628,\"caption\":\"devkinsta-featured-image-dk\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/staging.kinsta.site\/dk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Videnbase\",\"item\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DevKinsta Dokumentation\",\"item\":\"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Database Manager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/staging.kinsta.site\/dk\/#website\",\"url\":\"https:\/\/staging.kinsta.site\/dk\/\",\"name\":\"Kinsta\",\"description\":\"Hurtig, sikker, premium hostingl\u00f8sninger\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/staging.kinsta.site\/dk\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"da-DK\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database Manager - DevKinsta - Kinsta","description":"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.","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:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/","og_locale":"da_DK","og_type":"article","og_title":"Database Manager","og_description":"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.","og_url":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/","og_site_name":"Kinsta","article_publisher":"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/","article_modified_time":"2021-07-08T09:54:03+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_description":"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.","twitter_image":"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg","twitter_site":"@kinsta_dk","twitter_misc":{"Estimeret l\u00e6setid":"3 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/","url":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/","name":"Database Manager - DevKinsta - Kinsta","isPartOf":{"@id":"https:\/\/staging.kinsta.site\/dk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#primaryimage"},"image":{"@id":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg","datePublished":"2021-03-23T13:46:05+00:00","dateModified":"2021-07-08T09:54:03+00:00","description":"L\u00e6r, hvordan du f\u00e5r adgang til Database manager, hvordan du udf\u00f8rer nogle af de grundl\u00e6ggende opgaver, og hvordan du manipulerer din database via konsol.","breadcrumb":{"@id":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/"]}]},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#primaryimage","url":"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg","contentUrl":"https:\/\/staging.kinsta.site\/dk\/wp-content\/uploads\/sites\/12\/2021\/03\/devkinsta-featured-image-nl.jpg","width":1200,"height":628,"caption":"devkinsta-featured-image-dk"},{"@type":"BreadcrumbList","@id":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/database-manager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/staging.kinsta.site\/dk\/"},{"@type":"ListItem","position":2,"name":"Videnbase","item":"https:\/\/staging.kinsta.site\/dk\/videnbase\/"},{"@type":"ListItem","position":3,"name":"DevKinsta Dokumentation","item":"https:\/\/staging.kinsta.site\/dk\/videnbase\/devkinsta\/"},{"@type":"ListItem","position":4,"name":"Database Manager"}]},{"@type":"WebSite","@id":"https:\/\/staging.kinsta.site\/dk\/#website","url":"https:\/\/staging.kinsta.site\/dk\/","name":"Kinsta","description":"Hurtig, sikker, premium hostingl\u00f8sninger","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/staging.kinsta.site\/dk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/knowledgebase\/39727","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/users\/115"}],"version-history":[{"count":2,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/knowledgebase\/39727\/revisions"}],"predecessor-version":[{"id":39729,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/knowledgebase\/39727\/revisions\/39729"}],"up":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/knowledgebase\/39703"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/en"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/es"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/jp"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/fr"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/pt"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/de"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/nl"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/se"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/translations\/dk"},{"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/kinsta\/v1\/posts\/39727\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/media\/39705"}],"wp:attachment":[{"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/media?parent=39727"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/tags?post=39727"},{"taxonomy":"knowledge_categories","embeddable":true,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/knowledge_categories?post=39727"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/staging.kinsta.site\/dk\/wp-json\/wp\/v2\/topic?post=39727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}