{"id":46325,"date":"2022-11-02T16:17:38","date_gmt":"2022-11-02T15:17:38","guid":{"rendered":"https:\/\/kinsta.com\/dk\/?p=46325&#038;preview=true&#038;preview_id=46325"},"modified":"2023-08-24T11:17:42","modified_gmt":"2023-08-24T10:17:42","slug":"listes-mysql-databaser","status":"publish","type":"post","link":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/","title":{"rendered":"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)"},"content":{"rendered":"<p><a href=\"https:\/\/kinsta.com\/dk\/blog\/hvad-er-mysql\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL<\/a> er et af nutidens mest udbredte relationelle databaseadministrationssystemer (RDBMS). Det er en robust databaseplatform, der g\u00f8r det muligt at oprette og administrere skalerbare databaser, prim\u00e6rt ved hj\u00e6lp af et struktureret foresp\u00f8rgselssprog (SQL).<\/p>\n<p>MySQL-serveren er det milj\u00f8, hvor databaserne befinder sig &#8211; og hvor der er adgang til dem. Som serveradministrator vil du ofte have brug for at hente detaljer om dette milj\u00f8 &#8211; liste over de databaser, der findes p\u00e5 serveren, vise tabeller fra en bestemt database, se brugerroller og -rettigheder, f\u00e5 adgang til begr\u00e6nsninger osv.<\/p>\n<p>Denne artikel vil forklare hvordan du kan liste MySQL-databaser via kommandoprompten.<\/p>\n<div><\/div><kinsta-auto-toc heading=\"Table of Contents\" exclude=\"last\" list-style=\"arrow\" selector=\"h2\" count-number=\"-1\"><\/kinsta-auto-toc>\n<h2>Foruds\u00e6tninger for at liste MySQL-databaser<\/h2>\n<p>Du skal have MySQL-serveren k\u00f8rende p\u00e5 din lokale maskine for at komme i gang. Hvis du ikke har MySQL, er der et par m\u00e5der at installere det p\u00e5:<\/p>\n<ul>\n<li>Installer <a href=\"https:\/\/kinsta.com\/blog\/mamp-alternative\/#2-wampserver\" target=\"_blank\" rel=\"noopener noreferrer\">WAMPServer<\/a>, <a href=\"https:\/\/kinsta.com\/blog\/mamp-alternative\/#3-xampp\" target=\"_blank\" rel=\"noopener noreferrer\">XAMPP<\/a>, <a href=\"https:\/\/kinsta.com\/blog\/mamp-alternative\/#pros-and-cons-of-mamp-and-when-to-consider-an-alternative\" target=\"_blank\" rel=\"noopener noreferrer\">MAMP<\/a> eller en anden softwaredistributions stack, der indeholder MySQL.<\/li>\n<li>Download og k\u00f8r <a href=\"https:\/\/dev.mysql.com\/downloads\/installer\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL-installationsprogrammet<\/a> direkte fra deres officielle websted, og g\u00e5 gennem ops\u00e6tningsprocessen for at konfigurere og installere MySQL-serveren og andre v\u00e6rkt\u00f8jer.<\/li>\n<\/ul>\n<p>For at kunne k\u00f8re MySQL-kommandoer p\u00e5 kommandolinjen skal du tilf\u00f8je stien til MySQL&#8217;s eksekverbare fil til dit systemmilj\u00f8. Hvis du har installeret MySQL ved hj\u00e6lp af mulighed to, er dette trin un\u00f8dvendigt, og du er velkommen til at springe det n\u00e6ste afsnit over.<\/p>\n<h2>Tilf\u00f8j MySQL-stien til dit systems variabelmilj\u00f8<\/h2>\n<p>Dette afsnit guider dig i at tilf\u00f8je stien til MySQL&#8217;s eksekverbare fil til dit systems variable milj\u00f8, hvis du k\u00f8rer XAMPP eller WAMP p\u00e5 en Windows-computer.<\/p>\n<p>F\u00f8rst skal du starte din Windows-filudforskeren og navigere til <strong>Denne pc<\/strong>. Klik p\u00e5 det drev, hvor du har installeret WAMP- eller XAMPP-pakken (<strong>C:<\/strong>).<\/p>\n<p>Hvis du k\u00f8rer XAMPP, skal du navigere til <strong>xampp<\/strong> &gt; <strong>mysql<\/strong> &gt; <strong>bin<\/strong> og kopiere den fulde sti til <strong>bin-mappen<\/strong>. For WAMP skal du navigere gennem <strong>{din-wamp-version}<\/strong> &gt; <strong>bin<\/strong> &gt; <strong>mysql<\/strong> &gt; <strong>{din-mysql-version}<\/strong> &gt; <strong>bin<\/strong> til den fulde sti.<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 647px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2022\/10\/cli-mysql-fullpath.png\" alt=\"Den fulde sti til bin-mappen.\" width=\"647\" height=\"244\"><figcaption class=\"wp-caption-text\">Den fulde sti til bin-mappen.<\/figcaption><\/figure><\/figure>\n<p>Klik p\u00e5 menuen <strong>Start<\/strong>, og s\u00f8g efter &#8220;path&#8221; Klik p\u00e5 <strong>Rediger systemmilj\u00f8variablen<\/strong>.<\/p>\n<p>Klik derefter p\u00e5 <strong>Milj\u00f8variabler<\/strong> under <strong>Start og genopretning<\/strong>, v\u00e6lg variablen PATH, og klik p\u00e5 <strong>Rediger<\/strong>.<\/p>\n<p>Klik derefter p\u00e5 <strong>Ny<\/strong>, og inds\u00e6t den fulde sti til din MySQL-k\u00f8reprogram (som du kopierede tidligere).<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 525px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2022\/10\/edit-environment-variables-menu.png\" alt=\"Redigering af milj\u00f8variabler.\" width=\"525\" height=\"206\"><figcaption class=\"wp-caption-text\">Redigering af milj\u00f8variablen.<\/figcaption><\/figure><\/figure>\n<p>Gem derefter \u00e6ndringerne ved at klikke p\u00e5 <strong>OK<\/strong>.<\/p>\n<p>Nu hvor stien er blevet tilf\u00f8jet, kan du udf\u00f8re MySQL-kommandoer i terminalen.<\/p>\n<h2>Login til MySQL<\/h2>\n<p>For at kunne liste MySQL-databaser skal brugeren have tilladelse til at f\u00e5 adgang til alle databaser, eller du skal indstille et globalt <code>SHOW DATABASES<\/code> -privilegium, der giver adgang til alle brugere.<\/p>\n<p>S\u00f8rg for, at din MySQL-server k\u00f8rer, f\u00f8r du logger ind via kommandoprompten:<\/p>\n<pre><code class=\"language-bash\">mysql -u  -p<\/code><\/pre>\n<p>BEM\u00c6RK: erstat <code><\/code>\u00a0med dit brugernavn. Standardbrugernavnet for MySQL er <code>root<\/code>, og password er tomt (der er intet password som standard).<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 632px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2022\/10\/MySQL-login-terminal.png\" alt=\"Log ind p\u00e5 MySQL via terminalen.\" width=\"632\" height=\"335\"><figcaption class=\"wp-caption-text\">Logger ind p\u00e5 MySQL.<\/figcaption><\/figure><\/figure>\n<h2>Vis databaser inde i MySQL-serveren<\/h2>\n<p>Nu hvor du er logget ind, kan du liste de MySQL-databaser, der findes i serveren, ved at udf\u00f8re kommandoen <code>SHOW DATABASES<\/code>:<\/p>\n<pre><code class=\"language-sql\">SHOW DATABASES;<\/code><\/pre>\n<p>Til geng\u00e6ld f\u00e5r du alle de databaser, der er til stede i lageret:<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 220px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2022\/10\/show-MySQL-databases.png\" alt=\"En liste over de databaser, der findes i lageret.\" width=\"220\" height=\"232\"><figcaption class=\"wp-caption-text\">En liste over de databaser, der findes i lageret.<\/figcaption><\/figure><\/figure>\n<p>Ud af de seks databaser, der returneres, er <code>information_schema<\/code> og <code>performance_schema<\/code> standarddatabaser, som automatisk genereres, n\u00e5r du installerer MySQL.<\/p>\n<p>Databasen <code>information_schema<\/code> er en database, der ikke kan \u00e6ndres, og som gemmer alle oplysninger vedr\u00f8rende databaser og andre objekter (visninger, brugerrettigheder, tabeller, begr\u00e6nsninger osv.), der er gemt p\u00e5 MySQL-serveren.<\/p>\n<h2>Filtrering af resultaterne af databasens output<\/h2>\n<p>Tidligere returnerede du alle databaserne p\u00e5 MySQL-serveren med <code>SHOW DATABASES<\/code>, men du er ofte n\u00f8dt til at filtrere databasens output, is\u00e6r n\u00e5r der er mange databaser p\u00e5 serveren.<\/p>\n<p>Med klausulen <code>LIKE<\/code> filtreres resultatet af <code>SHOW DATABASE<\/code> ud fra et angivet m\u00f8nster. Her er den generelle syntaks:<\/p>\n<pre><code class=\"language-sql\">SHOW DATABASES LIKE '';<\/code><\/pre>\n<p>Det skal v\u00e6re en streng, der repr\u00e6senterer det m\u00f8nster, du \u00f8nsker at matche. Strengen skal slutte med procentsymbolet, <code>%<\/code>, som angiver et eller flere tegn.<\/p>\n<p>Hvis du f.eks. kun vil vise de databaser, hvis navne begynder med bogstavet <code>w<\/code>, kan du g\u00f8re det ved at k\u00f8re f\u00f8lgende:<\/p>\n<pre><code class=\"language-sql\">SHOW DATABASES LIKE 'w%';<\/code><\/pre>\n<p>Her er det filtrerede resultat:<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 270px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2022\/10\/filter-list-mysql-databases.png\" alt=\"Det filtrerede databasesvar ved brug af 'w%'.\" width=\"270\" height=\"153\"><figcaption class=\"wp-caption-text\">Det filtrerede databasesvar ved brug af &#8216;w%&#8217;.<\/figcaption><\/figure><\/figure>\n<h2>Brug af informationsskema til at foresp\u00f8rge p\u00e5 tabelmetadata<\/h2>\n<p>Tidligere s\u00e5 du, hvordan databasen <code>information_schema<\/code> gemmer alle oplysninger relateret til databaser, tabeller og andre objekter i MySQL-servermilj\u00f8et.<\/p>\n<p>Databasen <code>information_schema<\/code> g\u00f8r brug af skema-tabellen til at gemme oplysninger om alle databaser. Med henblik p\u00e5 databasefiltrering kan du udf\u00f8re en kompleks s\u00f8gning for at foresp\u00f8rge i schema-tabellen efter bestemte databaser.<\/p>\n<p>Hvis du f.eks. vil have databaser, hvis navne starter med enten &#8220;samp&#8221; eller &#8220;word&#8221;, kan du kombinere flere andre klausuler for at lave en kompleks foresp\u00f8rgsel:<\/p>\n<pre><code class=\"language-sql\">SELECT schema_name FROM information_schema.schemata WHERE schema_name LIKE 'samp%' OR schema_name LIKE 'word%';<\/code><\/pre>\n<p>Her er resultatet:<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 247px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2022\/10\/MySQL-SELECT-schema_name-FROM.png\" alt=\"Brug af MySQL's \"SELECT schema_name FROM\" kommando.\" width=\"247\" height=\"161\"><figcaption class=\"wp-caption-text\">Resultaterne af den komplekse foresp\u00f8rgsel.<\/figcaption><\/figure><\/figure>\n<p>Derudover har du tabellen <code>tables<\/code> fra databasen <code>information_schema<\/code>, som indeholder oplysninger om alle tabeller. P\u00e5 samme m\u00e5de kan du udf\u00f8re en foresp\u00f8rgsel for kun at hente de tabeller, der passer til et bestemt m\u00f8nster.<\/p>\n<p>F\u00f8lgende foresp\u00f8rgsel returnerer f.eks. kun schemaoplysningerne for <a href=\"https:\/\/kinsta.com\/dk\/blog\/wordpress-databasen\/\" target=\"_blank\" rel=\"noopener noreferrer\">WordPress-tabellerne<\/a> &#8211; kun de tabeller, hvis navne begynder med &#8220;wp_&#8221;:<\/p>\n<pre><code class=\"language-sql\">SELECT * FROM information_schema.tables WHERE table_name LIKE 'wp_%';<\/code><\/pre>\n<p>Her er resultatet:<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 929px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2022\/10\/wp_tables-list-MySQL-database.png\" alt=\"Visning af wp_tables MySQL-databasetabellen.\" width=\"929\" height=\"515\"><figcaption class=\"wp-caption-text\">Resultaterne af skemaoplysningerne for kun WordPress-tabellerne.<\/figcaption><\/figure><\/figure>\n<p>Andre tabeller fundet i <code>information_schema<\/code> omfatter <code>columns<\/code>, <code>constraints<\/code>, <code>table_constraints<\/code>, <code>check_constraints<\/code>, og <code>referential_constraints<\/code>.<\/p>\n<h2>F\u00e6lles problemer og bedste praksis<\/h2>\n<p>En af de mest almindelige \u00e5rsager til fejl ved udf\u00f8relse af SQL er den manglende brug af et semikolon i slutningen af udsagn.<\/p>\n<p>En anden er at bruge en ugyldig SQL-syntaks eller et forkert stavet tabel-\/kolonnenavn. For at undg\u00e5 dette skal du krydstjekke tabel- eller kolonnenavnet for at sikre, at det er stavet korrekt. S\u00f8rg ogs\u00e5 for at krydstjekke din syntaks.<\/p>\n<p>Her er nogle andre bedste praksis, som du skal huske p\u00e5.<\/p>\n<h3>Brug store bogstaver til SQL-ord<\/h3>\n<p>N\u00e5r du skriver SQL-kode, skal du altid bruge store bogstaver til SQL-n\u00f8gleord og sm\u00e5 bogstaver til tabel- og kolonnenavne. Dette g\u00f8r din kode mere l\u00e6sbar og mindre udsat for fejl.<\/p>\n<p>S\u00e5 i stedet for dette:<\/p>\n<pre><code class=\"language-sql\">select * from information_schema.tables where table_name like 'wp_%';<\/code><\/pre>\n<p>G\u00f8r dette:<\/p>\n<pre><code class=\"language-sql\">SELECT * FROM information_schema.tables WHERE table_name LIKE 'wp_%';<\/code><\/pre>\n<h3>Undg\u00e5 at bruge <code>SELECT *<\/code><\/h3>\n<p>Undg\u00e5 at bruge <code>SELECT *<\/code> i dine SQL-foresp\u00f8rgsler. Din foresp\u00f8rgsel er uklar, fordi du ikke altid kan vide, hvad den vil returnere. Angiv i stedet de kolonner, du \u00f8nsker at v\u00e6lge fra tabellen.<\/p>\n<p>S\u00e5 i stedet for dette:<\/p>\n<pre><code class=\"language-sql\">SELECT * EXCEPT(phone) FROM users.profile<\/code><\/pre>\n<p>G\u00f8r dette:<\/p>\n<pre><code class=\"language-sql\">SELECT name,\n    dob,\n    address,\n    country,\n    address,\nFROM user.profile<\/code><\/pre>\n<h3>Indryk din kode<\/h3>\n<p>Endelig er der endnu et tip til at g\u00f8re det lettere at finde fejl: Indryk din kode. Det g\u00f8r den mere l\u00e6sbar!<\/p>\n<h2>Databasemanagere<\/h2>\n<p>Alternativt kan du v\u00e6lge at administrere dine databaser uden at skrive SQL ved hj\u00e6lp af en database manager. Dette giver brugerne adgang til databasestyringsfunktioner uden at skulle skrive SQL-foresp\u00f8rgsler. Denne software opretter forbindelse til en MySQL-server og giver en brugergr\u00e6nseflade til at eksponere databasefunktionerne. N\u00e5r den er tilsluttet, vil brugergr\u00e6nsefladen vise alle databaser p\u00e5 serveren. Udseendet varierer p\u00e5 tv\u00e6rs af administrationsv\u00e6rkt\u00f8jer, men processen er ens.<\/p>\n<figure id=\"attachment_95411\" aria-describedby=\"caption-attachment-95411\" style=\"width: 1200px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-95411 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/05\/devkinsta-adminer.png\" alt=\"DevKinsta's database manager.\" width=\"1200\" height=\"624\"><figcaption id=\"caption-attachment-95411\" class=\"wp-caption-text\">DevKinsta&#8217;s database manager.<\/figcaption><\/figure>\n<p>Der er flere v\u00e6rkt\u00f8jer at v\u00e6lge imellem, herunder <a href=\"https:\/\/kinsta.com\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\" target=\"_blank\" rel=\"noopener noreferrer\">phpMyAdmin<\/a> og <a href=\"https:\/\/kinsta.com\/dk\/emner\/adminer\/\" target=\"_blank\" rel=\"noopener noreferrer\">Adminer<\/a>, som begge er tilg\u00e6ngelige via <a href=\"https:\/\/kinsta.com\/dk\/devkinsta\/\" target=\"_blank\" rel=\"noopener noreferrer\">DevKinsta<\/a>. Standardh\u00e5ndteringsv\u00e6rkt\u00f8jet til DevKinsta er Adminer, da det er let, nemt og hurtigt, <a href=\"https:\/\/kinsta.com\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\" target=\"_blank\" rel=\"noopener noreferrer\">men phpMyAdmin kan nemt tilg\u00e5s<\/a>.<\/p>\n<h2>Oversigt<\/h2>\n<p>Som serveradministrator skal du v\u00e6re i stand til effektivt og pr\u00e6cist at hente detaljer om databaserne p\u00e5 din MySQL-server. Evnerne til at se, hvilke databaser der er p\u00e5 serveren, se specifikke tabeller og oplysningerne fra dem og f\u00e5 adgang til oplysninger om brugerroller og privilegier er alle afg\u00f8rende opgaver. Heldigvis kan du g\u00f8re alt dette til en leg ved hj\u00e6lp af SQL fra din kommandolinje.<\/p>\n<p><em>N\u00e5r din databaseadministration skal str\u00e6kke sig ud over foresp\u00f8rgsler til tabeller, kan Kinsta hj\u00e6lpe dig. F\u00e5 mere at vide om vores <a href=\"https:\/\/sevalla.com\/application-hosting\/\" target=\"_blank\" rel=\"noopener noreferrer\">muligheder for skalerbar databasehosting<\/a> i dag!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL er et af nutidens mest udbredte relationelle databaseadministrationssystemer (RDBMS). Det er en robust databaseplatform, der g\u00f8r det muligt at oprette og administrere skalerbare databaser, prim\u00e6rt &#8230;<\/p>\n","protected":false},"author":117,"featured_media":46995,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[134,38],"topic":[676,690,718],"class_list":["post-46325","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-mysql","tag-webdev","topic-adminer","topic-devkinsta","topic-mysql-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.6 (Yoast SEO v24.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)<\/title>\n<meta name=\"description\" content=\"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)\" \/>\n<meta property=\"og:description\" content=\"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-02T15:17:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-24T10:17:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1460\" \/>\n\t<meta property=\"og:image:height\" content=\"730\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Salman Ravoof\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png\" \/>\n<meta name=\"twitter:creator\" content=\"@salmanravoof\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_dk\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet af\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salman Ravoof\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/\"},\"author\":{\"name\":\"Salman Ravoof\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\"},\"headline\":\"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)\",\"datePublished\":\"2022-11-02T15:17:38+00:00\",\"dateModified\":\"2023-08-24T10:17:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/\"},\"wordCount\":1342,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png\",\"keywords\":[\"mySQL\",\"webdev\"],\"inLanguage\":\"da-DK\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/\",\"url\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/\",\"name\":\"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png\",\"datePublished\":\"2022-11-02T15:17:38+00:00\",\"dateModified\":\"2023-08-24T10:17:42+00:00\",\"description\":\"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#breadcrumb\"},\"inLanguage\":\"da-DK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png\",\"contentUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png\",\"width\":1460,\"height\":730,\"caption\":\"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/dk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adminer\",\"item\":\"https:\/\/kinsta.com\/dk\/emner\/adminer\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/dk\/#website\",\"url\":\"https:\/\/kinsta.com\/dk\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Hurtig, sikker, premium hostingl\u00f8sninger\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/dk\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"da-DK\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/dk\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/dk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/\",\"https:\/\/x.com\/kinsta_dk\",\"https:\/\/www.instagram.com\/kinstahosting\/\",\"https:\/\/www.linkedin.com\/company\/kinsta\/\",\"https:\/\/www.pinterest.com\/kinstahosting\/\",\"https:\/\/www.youtube.com\/c\/Kinsta\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\",\"name\":\"Salman Ravoof\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g\",\"caption\":\"Salman Ravoof\"},\"description\":\"Salman Ravoof is a self-taught web developer, writer, creator, and a huge admirer of Free and Open Source Software (FOSS). Besides tech, he's excited by science, philosophy, photography, arts, cats, and food. Learn more about him on his website, and connect with Salman on Twitter.\",\"sameAs\":[\"https:\/\/salmanravoof.com\",\"https:\/\/www.linkedin.com\/in\/salman-ravoof-5a749133\/\",\"https:\/\/x.com\/salmanravoof\"],\"url\":\"https:\/\/kinsta.com\/dk\/blog\/author\/salmanravoof\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)","description":"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.","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:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/","og_locale":"da_DK","og_type":"article","og_title":"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)","og_description":"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.","og_url":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/","article_published_time":"2022-11-02T15:17:38+00:00","article_modified_time":"2023-08-24T10:17:42+00:00","og_image":[{"width":1460,"height":730,"url":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png","type":"image\/png"}],"author":"Salman Ravoof","twitter_card":"summary_large_image","twitter_description":"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.","twitter_image":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png","twitter_creator":"@salmanravoof","twitter_site":"@kinsta_dk","twitter_misc":{"Skrevet af":"Salman Ravoof","Estimeret l\u00e6setid":"7 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/"},"author":{"name":"Salman Ravoof","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987"},"headline":"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)","datePublished":"2022-11-02T15:17:38+00:00","dateModified":"2023-08-24T10:17:42+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/"},"wordCount":1342,"commentCount":0,"publisher":{"@id":"https:\/\/kinsta.com\/dk\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png","keywords":["mySQL","webdev"],"inLanguage":"da-DK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/","url":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/","name":"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)","isPartOf":{"@id":"https:\/\/kinsta.com\/dk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png","datePublished":"2022-11-02T15:17:38+00:00","dateModified":"2023-08-24T10:17:42+00:00","description":"Udvid din serveradministration ved at l\u00e6re ins og outs at vise MySQL-databaser ved hj\u00e6lp af kommandoer i terminalen.","breadcrumb":{"@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/"]}]},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#primaryimage","url":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png","contentUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2022\/11\/listes-mysql-databaser.png","width":1460,"height":730,"caption":"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)"},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/dk\/blog\/listes-mysql-databaser\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/dk\/"},{"@type":"ListItem","position":2,"name":"Adminer","item":"https:\/\/kinsta.com\/dk\/emner\/adminer\/"},{"@type":"ListItem","position":3,"name":"S\u00e5dan listes MySQL-databaser (trin for trin kodevejledning)"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/dk\/#website","url":"https:\/\/kinsta.com\/dk\/","name":"Kinsta\u00ae","description":"Hurtig, sikker, premium hostingl\u00f8sninger","publisher":{"@id":"https:\/\/kinsta.com\/dk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/dk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/dk\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/dk\/","logo":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/","https:\/\/x.com\/kinsta_dk","https:\/\/www.instagram.com\/kinstahosting\/","https:\/\/www.linkedin.com\/company\/kinsta\/","https:\/\/www.pinterest.com\/kinstahosting\/","https:\/\/www.youtube.com\/c\/Kinsta"]},{"@type":"Person","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987","name":"Salman Ravoof","image":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g","caption":"Salman Ravoof"},"description":"Salman Ravoof is a self-taught web developer, writer, creator, and a huge admirer of Free and Open Source Software (FOSS). Besides tech, he's excited by science, philosophy, photography, arts, cats, and food. Learn more about him on his website, and connect with Salman on Twitter.","sameAs":["https:\/\/salmanravoof.com","https:\/\/www.linkedin.com\/in\/salman-ravoof-5a749133\/","https:\/\/x.com\/salmanravoof"],"url":"https:\/\/kinsta.com\/dk\/blog\/author\/salmanravoof\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts\/46325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/users\/117"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/comments?post=46325"}],"version-history":[{"count":7,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts\/46325\/revisions"}],"predecessor-version":[{"id":46997,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts\/46325\/revisions\/46997"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/pt"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/fr"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/de"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/jp"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/nl"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/es"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/se"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/translations\/dk"},{"href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/46325\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/media\/46995"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/media?parent=46325"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/tags?post=46325"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/topic?post=46325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}