{"id":38495,"date":"2021-03-23T09:15:05","date_gmt":"2021-03-23T08:15:05","guid":{"rendered":"https:\/\/staging.kinsta.site\/?post_type=knowledgebase&#038;p=86689"},"modified":"2021-07-08T09:40:38","modified_gmt":"2021-07-08T09:40:38","slug":"databashanteraren","status":"publish","type":"knowledgebase","link":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/","title":{"rendered":"Databashanteraren"},"content":{"rendered":"<p>Adminer \u00e4r ett anv\u00e4ndargr\u00e4nssnitt f\u00f6r att justera databasen. Det \u00e4r mycket likt phpMyAdmin men \u00e4r betydligt mer l\u00e4ttviktigt och \u00e4r d\u00e4rmed snabbare att arbeta med. Dokumentation finns p\u00e5 <a href=\"https:\/\/www.adminer.org\/\">Adminer\u00b4s webbplats<\/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\">Komma \u00e5t databashanteraren<\/h2>\n<p>Du kan komma \u00e5t Databashanteraren p\u00e5 tre s\u00e4tt.<\/p>\n<ul>\n<li>Klicka p\u00e5 menyn &#8221;Mer&#8221; (tre punkter) i webbplatslistan och v\u00e4lj &#8221;\u00d6ppna databashanteraren&#8221;<\/li>\n<li>Klicka p\u00e5 knappen &#8221;Databashanteraren&#8221; h\u00f6gst upp p\u00e5 sidan f\u00f6r webbplatsdetaljer<\/li>\n<li>Databashanteraren \u00e4r tillg\u00e4nglig p\u00e5 port <code>15001<\/code> p\u00e5 webbplatsens IP (som du hittar p\u00e5 sidan f\u00f6r webbplatsdetaljer)<\/li>\n<\/ul>\n<h2 id=\"basic-usage\">Grundl\u00e4ggande anv\u00e4ndning<\/h2>\n<h3 id=\"switching-databases\">Byta databaser<\/h3>\n<p>N\u00e4r du bes\u00f6ker Adminer genom att klicka p\u00e5 en knapp i DevKinsta tas du alltid till r\u00e4tt databas automatiskt men du kan \u00e4ven v\u00e4xla mellan dem inom Adminer. Du kan v\u00e4xla mellan databaser med hj\u00e4lp av listrutan h\u00f6gst upp i v\u00e4nster sidof\u00e4lt.<\/p>\n<h3 id=\"viewing-table-structure\">Visa tabellstruktur<\/h3>\n<p>Om du klickar p\u00e5 ett tabellnamn i sidof\u00e4ltet kommer du till tabellens strukturvy. Du kan se varje f\u00e4lt och vilken typ av data det inneh\u00e5ller.<\/p>\n<h3 id=\"viewing-table-data\">Visa tabelldata<\/h3>\n<p>Om du klickar p\u00e5 &#8221;V\u00c4LJ&#8221; i sidof\u00e4ltet bredvid tabellnamnet kommer du till en sida som visar de f\u00f6rsta 50 objekten i tabellen. Du kan dyka in i olika delar av tabellen med hj\u00e4lp av kontrollerna h\u00f6gst upp p\u00e5 sidan.<\/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 m\u00e5ste klicka p\u00e5 den bl\u00e5a titeln ovanf\u00f6r rutorna f\u00f6r att f\u00e5 tillg\u00e5ng till de formul\u00e4r som de inneh\u00e5ller. Du kan sedan st\u00e4lla in vyer med hj\u00e4lp av flera val-, s\u00f6k-, sorterings-, begr\u00e4nsnings- och l\u00e4ngddirektiv. Observera att dina s\u00f6kningar \u00e4r mappade till webbadressen s\u00e5 du kan spara vyer genom att bokm\u00e4rka sidan.<\/p>\n<p>Om du beh\u00f6ver en mer detaljerad SQL-s\u00f6kfr\u00e5ga f\u00f6r att visa data kan du klicka p\u00e5 redigera bredvid fr\u00e5gan som visas h\u00f6gst upp p\u00e5 sk\u00e4rmen och f\u00e5 tillg\u00e5ng till en SQL-redigerare.<\/p>\n<h3 id=\"manipulating-data\">Manipulera data<\/h3>\n<p>Du kan redigera vilken rad som helst genom att klicka p\u00e5 redigeringsl\u00e4nken i resultatet. N\u00e4r du \u00e4r p\u00e5 den valda datasidan kan du l\u00e4gga till nya objekt genom att klicka p\u00e5 knappen &#8221;NYTT OBJEKT&#8221;. Detta ger dig ett formul\u00e4r med f\u00e4lt som du kan fylla i.<\/p>\n<p>Du kan k\u00f6ra komplexa SQL-s\u00f6kfr\u00e5gor genom att klicka p\u00e5 l\u00e4nken &#8221;SQL COMMAND&#8221; h\u00f6gst upp i sidof\u00e4ltet. Detta tar dig till SQL-redigeraren d\u00e4r du kan skriva din fr\u00e5ga. Om du klickar p\u00e5 &#8221;Historik&#8221; i rutan under redigeraren visas nyligen k\u00f6rda kommandon som du kan ladda upp.<\/p>\n<h2 id=\"go-deeper-via-command-line\">G\u00e5 djupare via kommandoraden<\/h2>\n<p>Om du vill justera databasen via konsol kan du g\u00f6ra detta.<\/p>\n<h3 id=\"enter-through-virtual-machine\">G\u00e5 in via virtuell dator<\/h3>\n<pre class=\"language-shell\"><code># G\u00e5 in i devkinsta_db container\ndocker exec -it devkinsta_db bash\n\n# Anslut till databas\nmysql -h localhost -u root -p\n\n# K\u00f6r SQL-kommandon\nvisa databaser;<\/code><\/pre>\n<h3>G\u00e5 in via v\u00e4rddator<\/h3>\n<p>Du hittar denna information p\u00e5 sidan f\u00f6r webbplatsdetaljer.<\/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># G\u00e5 in i databasen direkt fr\u00e5n hostens operativsystem\nmysql -h 192.168.99.254 -P 15100 -u root -p<\/code><\/pre>\n","protected":false},"author":115,"featured_media":38468,"parent":38466,"menu_order":8,"template":"","tags":[],"knowledge_categories":[329],"topic":[],"class_list":["post-38495","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>Databashanteraren - DevKinsta - Kinsta<\/title>\n<meta name=\"description\" content=\"L\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.\" \/>\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\/se\/kunskapsbas\/devkinsta\/databashanteraren\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Databashanteraren\" \/>\n<meta property=\"og:description\" content=\"L\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/kinstasweden\/\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-08T09:40:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.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\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_se\" \/>\n<meta name=\"twitter:label1\" content=\"Ber\u00e4knad l\u00e4stid\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minuter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/\",\"url\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/\",\"name\":\"Databashanteraren - DevKinsta - Kinsta\",\"isPartOf\":{\"@id\":\"https:\/\/staging.kinsta.site\/se\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg\",\"datePublished\":\"2021-03-23T08:15:05+00:00\",\"dateModified\":\"2021-07-08T09:40:38+00:00\",\"description\":\"L\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#primaryimage\",\"url\":\"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg\",\"contentUrl\":\"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/staging.kinsta.site\/se\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kunskapsbas\",\"item\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DevKinsta Dokumentation\",\"item\":\"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Databashanteraren\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/staging.kinsta.site\/se\/#website\",\"url\":\"https:\/\/staging.kinsta.site\/se\/\",\"name\":\"Kinsta\",\"description\":\"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/staging.kinsta.site\/se\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sv-SE\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Databashanteraren - DevKinsta - Kinsta","description":"L\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.","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\/se\/kunskapsbas\/devkinsta\/databashanteraren\/","og_locale":"sv_SE","og_type":"article","og_title":"Databashanteraren","og_description":"L\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.","og_url":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/","og_site_name":"Kinsta","article_publisher":"https:\/\/www.facebook.com\/kinstasweden\/","article_modified_time":"2021-07-08T09:40:38+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_description":"L\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.","twitter_image":"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg","twitter_site":"@kinsta_se","twitter_misc":{"Ber\u00e4knad l\u00e4stid":"3 minuter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/","url":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/","name":"Databashanteraren - DevKinsta - Kinsta","isPartOf":{"@id":"https:\/\/staging.kinsta.site\/se\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#primaryimage"},"image":{"@id":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg","datePublished":"2021-03-23T08:15:05+00:00","dateModified":"2021-07-08T09:40:38+00:00","description":"L\u00e4r dig hur du kommer \u00e5t Databashanteraren, hur du utf\u00f6r n\u00e5gra av de grundl\u00e4ggande uppgifterna och hur du justerar databasen via konsolen.","breadcrumb":{"@id":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#primaryimage","url":"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg","contentUrl":"https:\/\/staging.kinsta.site\/se\/wp-content\/uploads\/sites\/9\/2021\/03\/devkinsta-featured-image.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/databashanteraren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/staging.kinsta.site\/se\/"},{"@type":"ListItem","position":2,"name":"Kunskapsbas","item":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/"},{"@type":"ListItem","position":3,"name":"DevKinsta Dokumentation","item":"https:\/\/staging.kinsta.site\/se\/kunskapsbas\/devkinsta\/"},{"@type":"ListItem","position":4,"name":"Databashanteraren"}]},{"@type":"WebSite","@id":"https:\/\/staging.kinsta.site\/se\/#website","url":"https:\/\/staging.kinsta.site\/se\/","name":"Kinsta","description":"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/staging.kinsta.site\/se\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sv-SE"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/knowledgebase\/38495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/users\/115"}],"version-history":[{"count":3,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/knowledgebase\/38495\/revisions"}],"predecessor-version":[{"id":38525,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/knowledgebase\/38495\/revisions\/38525"}],"up":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/knowledgebase\/38466"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/en"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/es"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/jp"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/fr"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/pt"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/de"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/nl"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/se"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/translations\/dk"},{"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/kinsta\/v1\/posts\/38495\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/media\/38468"}],"wp:attachment":[{"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/media?parent=38495"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/tags?post=38495"},{"taxonomy":"knowledge_categories","embeddable":true,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/knowledge_categories?post=38495"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/staging.kinsta.site\/se\/wp-json\/wp\/v2\/topic?post=38495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}