{"id":37425,"date":"2021-03-17T15:39:46","date_gmt":"2021-03-17T14:39:46","guid":{"rendered":"https:\/\/staging.kinsta.site\/?post_type=knowledgebase&#038;p=86689"},"modified":"2021-07-21T10:31:49","modified_gmt":"2021-07-21T08:31:49","slug":"databasemanager","status":"publish","type":"knowledgebase","link":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/","title":{"rendered":"Databasemanager"},"content":{"rendered":"<p>Adminer is een gebruikersinterface voor het bewerken van je database. Het lijkt sterk op phpMyAdmin maar is veel lichter, en dus sneller om mee te werken. Voor documentatie kan je de <a href=\"https:\/\/www.adminer.org\/\">Adminer website<\/a> gebruiken.<\/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\">Openen van de databasemanager<\/h2>\n<p>Je kan de databasemanager op drie manieren openen.<\/p>\n<ul>\n<li>Klik op het menu &#8220;More&#8221; (drie puntjes) in de lijst met sites en vervolgens op &#8220;Open database manager&#8221;.<\/li>\n<li>Klik op de knop &#8220;Database Manager&#8221; boven de pagina met details van een site.<\/li>\n<li>De Database manager is ook beschikbaar via port <code>15001<\/code> binnen het IP adres van je site (te vinden in de pagina met details)<\/li>\n<\/ul>\n<h2 id=\"basic-usage\">Dagelijks gebruik<\/h2>\n<h3 id=\"switching-databases\">Wisselen tussen database<\/h3>\n<p>Wanneer je Adminer opent via een knop in DevKinsta zal je altijd meteen automatisch naar de juiste database gaan, maar je kan ook van database veranderen via Adminer. Je kan wisselen tussen databases via het dropdownmenu bovenin de linker zijbalk.<\/p>\n<h3 id=\"viewing-table-structure\">Tabelstructuur bekijken<\/h3>\n<p>Klik op de tabelnaam in de zijbalk om de structuur van de betreffende tabel te zien. Je kan elk veld en het type data erin zien.<\/p>\n<h3 id=\"viewing-table-data\">Tabelgegevens bekijken<\/h3>\n<p>Klik op &#8220;SELECT&#8221; in de zijbalk naast de tabelnaam om naar een pagina te gaan met de eerste 50 items in de tabel. Je kan verschillende delen van de tabel openen via de instellingen bovenaan de pagina.<\/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>Je moet op de blauwe titel boven de boxen klikken om de bijbehorende formulieren te openen. Je kan views instellen via verschillende select, search, sort, limit en length opdrachten. Let erop dat je zoekopdrachten worden gekoppeld aan de URL, dus je kan een view opslaan door de pagina in je favorieten te zetten.<\/p>\n<p>Heb je een uitgebreide SQL query nodig voor je data dan kan je op &#8220;Edit&#8221; klikken naast de query bovenaan, waarna een SQL editor zal openen.<\/p>\n<h3 id=\"manipulating-data\">Data manipuleren<\/h3>\n<p>Je kan elke rij in de tabel bewerken door op de &#8220;Edit&#8221; link te klikken in de resultaten. Op de &#8220;Select data&#8221; pagina kan je nieuwe items toevoegen door op &#8220;NEW ITEM&#8221; te klikken. Daar krijg je een formulier met alle velden die je in moet vullen.<\/p>\n<p>Je kan complexe SQL query&#8217;s uitvoeren door op de link &#8220;SQL COMMAND&#8221; te klikken bovenaan in de zijbalk. Hiermee ga je naar een SQL editor waar je een query kan typen. Klik op &#8220;History&#8221; onder de editor om te opdrachten te zien die je recentelijk hebt uitgevoerd.<\/p>\n<h2 id=\"go-deeper-via-command-line\">Ga verder via de opdrachtregel<\/h2>\n<p>Wil je de database bewerken via de console dan kan dat ook.<\/p>\n<h3 id=\"enter-through-virtual-machine\">Open via de virtual machine<\/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>Openen via de host machine<\/h3>\n<p>Je kan deze informatie vinden via de pagina met details over de site.<\/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":37404,"parent":37398,"menu_order":8,"template":"","tags":[],"knowledge_categories":[395],"topic":[],"class_list":["post-37425","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>Databasemanager - DevKinsta - Kinsta<\/title>\n<meta name=\"description\" content=\"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.\" \/>\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\/nl\/kennisbank\/devkinsta\/databasemanager\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Databasemanager\" \/>\n<meta property=\"og:description\" content=\"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-21T08:31:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.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=\"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg\" \/>\n<meta name=\"twitter:site\" content=\"@Kinsta_NL\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/\",\"url\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/\",\"name\":\"Databasemanager - DevKinsta - Kinsta\",\"isPartOf\":{\"@id\":\"https:\/\/staging.kinsta.site\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg\",\"datePublished\":\"2021-03-17T14:39:46+00:00\",\"dateModified\":\"2021-07-21T08:31:49+00:00\",\"description\":\"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#primaryimage\",\"url\":\"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg\",\"contentUrl\":\"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg\",\"width\":1200,\"height\":628,\"caption\":\"devkinsta-featured-image-nl\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/staging.kinsta.site\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kennisbank\",\"item\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DevKinsta documentatie\",\"item\":\"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Databasemanager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/staging.kinsta.site\/nl\/#website\",\"url\":\"https:\/\/staging.kinsta.site\/nl\/\",\"name\":\"Kinsta\",\"description\":\"Snelle, veilige, premium hostingoplossingen\",\"publisher\":{\"@id\":\"https:\/\/staging.kinsta.site\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/staging.kinsta.site\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/staging.kinsta.site\/nl\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/staging.kinsta.site\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/staging.kinsta.site\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2020\/12\/kinsta.png\",\"contentUrl\":\"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2020\/12\/kinsta.png\",\"width\":580,\"height\":580,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/staging.kinsta.site\/nl\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/\",\"https:\/\/x.com\/Kinsta_NL\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Databasemanager - DevKinsta - Kinsta","description":"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.","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\/nl\/kennisbank\/devkinsta\/databasemanager\/","og_locale":"nl_NL","og_type":"article","og_title":"Databasemanager","og_description":"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.","og_url":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/","og_site_name":"Kinsta","article_publisher":"https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/","article_modified_time":"2021-07-21T08:31:49+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_description":"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.","twitter_image":"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg","twitter_site":"@Kinsta_NL","twitter_misc":{"Geschatte leestijd":"3 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/","url":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/","name":"Databasemanager - DevKinsta - Kinsta","isPartOf":{"@id":"https:\/\/staging.kinsta.site\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#primaryimage"},"image":{"@id":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg","datePublished":"2021-03-17T14:39:46+00:00","dateModified":"2021-07-21T08:31:49+00:00","description":"Lees hier hoe je de databasemanager kan openen, enkele eenvoudige taken kan uitvoeren en je database kan manipuleren via de console.","breadcrumb":{"@id":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#primaryimage","url":"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg","contentUrl":"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2021\/03\/devkinsta-featured-image-nl-1.jpg","width":1200,"height":628,"caption":"devkinsta-featured-image-nl"},{"@type":"BreadcrumbList","@id":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/databasemanager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/staging.kinsta.site\/nl\/"},{"@type":"ListItem","position":2,"name":"Kennisbank","item":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/"},{"@type":"ListItem","position":3,"name":"DevKinsta documentatie","item":"https:\/\/staging.kinsta.site\/nl\/kennisbank\/devkinsta\/"},{"@type":"ListItem","position":4,"name":"Databasemanager"}]},{"@type":"WebSite","@id":"https:\/\/staging.kinsta.site\/nl\/#website","url":"https:\/\/staging.kinsta.site\/nl\/","name":"Kinsta","description":"Snelle, veilige, premium hostingoplossingen","publisher":{"@id":"https:\/\/staging.kinsta.site\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/staging.kinsta.site\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/staging.kinsta.site\/nl\/#organization","name":"Kinsta","url":"https:\/\/staging.kinsta.site\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/staging.kinsta.site\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2020\/12\/kinsta.png","contentUrl":"https:\/\/staging.kinsta.site\/nl\/wp-content\/uploads\/sites\/7\/2020\/12\/kinsta.png","width":580,"height":580,"caption":"Kinsta"},"image":{"@id":"https:\/\/staging.kinsta.site\/nl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/","https:\/\/x.com\/Kinsta_NL"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/knowledgebase\/37425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/users\/115"}],"version-history":[{"count":3,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/knowledgebase\/37425\/revisions"}],"predecessor-version":[{"id":39146,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/knowledgebase\/37425\/revisions\/39146"}],"up":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/knowledgebase\/37398"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/en"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/es"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/jp"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/fr"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/pt"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/de"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/nl"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/se"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/translations\/dk"},{"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/kinsta\/v1\/posts\/37425\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/media\/37404"}],"wp:attachment":[{"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/media?parent=37425"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/tags?post=37425"},{"taxonomy":"knowledge_categories","embeddable":true,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/knowledge_categories?post=37425"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/staging.kinsta.site\/nl\/wp-json\/wp\/v2\/topic?post=37425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}