{"id":46882,"date":"2022-11-02T15:16:05","date_gmt":"2022-11-02T15:16:05","guid":{"rendered":"https:\/\/kinqsta.com\/se\/?p=46882&#038;preview=true&#038;preview_id=46882"},"modified":"2023-09-21T09:17:30","modified_gmt":"2023-09-21T09:17:30","slug":"lista-mysql-databaser","status":"publish","type":"post","link":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/","title":{"rendered":"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)"},"content":{"rendered":"<p><a href=\"https:\/\/kinqsta.com\/se\/blog\/vad-ar-mysql\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL<\/a> \u00e4r ett av dagens mest anv\u00e4nda relationella databashanteringssystem (RDBMS). Det \u00e4r en robust databasplattform som g\u00f6r det m\u00f6jligt att skapa och hantera skalbara databaser, huvudsakligen med hj\u00e4lp av ett strukturerat fr\u00e5gespr\u00e5k (SQL).<\/p>\n<p>MySQL-servern \u00e4r den milj\u00f6 d\u00e4r databaserna finns &#8211; och d\u00e4r de n\u00e5s. Som serveradministrat\u00f6r s\u00e5 beh\u00f6ver du ofta h\u00e4mta information om den h\u00e4r milj\u00f6n &#8211; lista de databaser som finns p\u00e5 servern, visa tabeller fr\u00e5n en viss databas, visa anv\u00e4ndarroller och privilegier, f\u00e5 tillg\u00e5ng till begr\u00e4nsningar och s\u00e5 vidare.<\/p>\n<p>Den h\u00e4r artikeln f\u00f6rklarar hur du listar MySQL-databaser via kommandotolken.<\/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>F\u00f6ruts\u00e4ttningar f\u00f6r att lista MySQL-databaser<\/h2>\n<p>MySQL-servern m\u00e5ste vara ig\u00e5ng p\u00e5 din lokala maskin f\u00f6r att du ska kunna b\u00f6rja. Om du inte har MySQL s\u00e5 finns det n\u00e5gra s\u00e4tt att installera det:<\/p>\n<ul>\n<li>Installera <a href=\"https:\/\/kinqsta.com\/blog\/mamp-alternative\/#2-wampserver\" target=\"_blank\" rel=\"noopener noreferrer\">WAMPServer<\/a>, <a href=\"https:\/\/kinqsta.com\/blog\/mamp-alternative\/#3-xampp\" target=\"_blank\" rel=\"noopener noreferrer\">XAMPP<\/a>, <a href=\"https:\/\/kinqsta.com\/blog\/mamp-alternative\/#pros-and-cons-of-mamp-and-when-to-consider-an-alternative\" target=\"_blank\" rel=\"noopener noreferrer\">MAMP<\/a> eller n\u00e5gon annan programvarudistribuerings-stack som inkluderar MySQL.<\/li>\n<li>Ladda ner och k\u00f6r <a href=\"https:\/\/dev.mysql.com\/downloads\/installer\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL-installationsprogrammet<\/a> direkt fr\u00e5n deras officiella webbplats och g\u00e5 igenom installationsprocessen f\u00f6r att konfigurera och installera MySQL-servern och andra verktyg.<\/li>\n<\/ul>\n<p>F\u00f6r att bekv\u00e4mt kunna k\u00f6ra MySQL-kommandon via kommandoraden s\u00e5 m\u00e5ste du l\u00e4gga till s\u00f6kv\u00e4gen f\u00f6r MySQL:s k\u00f6rbara fil i din systemmilj\u00f6. Om du har installerat MySQL med alternativ tv\u00e5 s\u00e5 \u00e4r det h\u00e4r steget on\u00f6digt, s\u00e5 du kan g\u00e4rna hoppa \u00f6ver n\u00e4sta avsnitt.<\/p>\n<h2>L\u00e4gg till MySQL:s s\u00f6kv\u00e4g till systemmilj\u00f6variabeln<\/h2>\n<p>I det h\u00e4r avsnittet s\u00e5 f\u00e5r du v\u00e4gledning om hur du l\u00e4gger till s\u00f6kv\u00e4gen f\u00f6r MySQL:s k\u00f6rbara fil till din systemmilj\u00f6variabel om du k\u00f6r XAMPP eller WAMP p\u00e5 en Windows-dator.<\/p>\n<p>B\u00f6rja med att starta din Windows-filutforskare och navigera till <strong>Denna PC<\/strong>. Klicka p\u00e5 den enhet d\u00e4r du har installerat WAMP- eller XAMPP-paketet (<strong>C:<\/strong>).<\/p>\n<p>Om du k\u00f6r XAMPP s\u00e5 navigerar du till <strong>xampp<\/strong> &gt; <strong>mysql<\/strong> &gt; <strong>bin<\/strong> och kopierar den fullst\u00e4ndiga s\u00f6kv\u00e4gen till <strong>bin-mappen<\/strong>. F\u00f6r WAMP s\u00e5 navigerar du via <strong>{your-wamp-version}<\/strong> &gt; <strong>bin<\/strong> &gt; <strong>mysql<\/strong> &gt; <strong>{your-mysql-version}<\/strong> &gt; <strong>bin<\/strong> till den fullst\u00e4ndiga s\u00f6kv\u00e4gen.<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 647px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinqsta.com\/wp-content\/uploads\/2022\/10\/cli-mysql-fullpath.png\" alt=\"Den fullst\u00e4ndiga s\u00f6kv\u00e4gen till mappen bin.\" width=\"647\" height=\"244\"><figcaption class=\"wp-caption-text\">Den fullst\u00e4ndiga s\u00f6kv\u00e4gen till mappen bin.<\/figcaption><\/figure><\/figure>\n<p>Klicka p\u00e5 <strong>Start-menyn<\/strong> och s\u00f6k efter &#8221;path&#8221;. Klicka p\u00e5 <strong>Redigera systemmilj\u00f6variabeln<\/strong>.<\/p>\n<p>Klicka sedan p\u00e5 <strong>Milj\u00f6variabler<\/strong> under <strong>Start och \u00e5terst\u00e4llning<\/strong>, v\u00e4lj variabeln PATH och klicka p\u00e5 <strong>Redigera<\/strong>.<\/p>\n<p>Klicka sedan p\u00e5 <b>Ny <\/b>och klistra in den fullst\u00e4ndiga s\u00f6kv\u00e4gen till MySQL-k\u00f6rprogrammet (som du kopierade tidigare).<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 525px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinqsta.com\/wp-content\/uploads\/2022\/10\/edit-environment-variables-menu.png\" alt=\"Redigera milj\u00f6variabeln.\" width=\"525\" height=\"206\"><figcaption class=\"wp-caption-text\">Redigera milj\u00f6variabeln.<\/figcaption><\/figure><\/figure>\n<p>Spara sedan \u00e4ndringarna genom att klicka p\u00e5 <strong>OK<\/strong>.<\/p>\n<p>Nu n\u00e4r s\u00f6kv\u00e4gen har lagts till s\u00e5 kan du utf\u00f6ra MySQL-kommandon i terminalen.<\/p>\n<h2>Logga in p\u00e5 MySQL<\/h2>\n<p>F\u00f6r att lista MySQL-databaser s\u00e5 m\u00e5ste anv\u00e4ndaren ha beh\u00f6righet att komma \u00e5t alla databaser, eller s\u00e5 m\u00e5ste du st\u00e4lla in ett globalt <code>SHOW DATABASES<\/code>-privilegium som ger tillg\u00e5ng till alla anv\u00e4ndare.<\/p>\n<p>Kontrollera att din MySQL-server \u00e4r ig\u00e5ng innan du loggar in via kommandotolken:<\/p>\n<pre><code class=\"language-bash\">mysql -u  -p<\/code><\/pre>\n<p>OBS: Ers\u00e4tt <code><\/code>\u00a0med ditt anv\u00e4ndarnamn. Standardanv\u00e4ndarnamnet f\u00f6r MySQL \u00e4r <code>root<\/code>, och l\u00f6senordet \u00e4r tomt (det finns som standard inget l\u00f6senord).<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 632px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinqsta.com\/wp-content\/uploads\/2022\/10\/MySQL-login-terminal.png\" alt=\"Logga in p\u00e5 MySQL.\" width=\"632\" height=\"335\"><figcaption class=\"wp-caption-text\">Logga in p\u00e5 MySQL.<\/figcaption><\/figure><\/figure>\n<h2>Visa databaser inuti MySQL-servern<\/h2>\n<p>Nu n\u00e4r du \u00e4r inloggad s\u00e5 kan du lista de MySQL-databaser som finns p\u00e5 servern genom att k\u00f6ra kommandot <code>SHOW DATABASES<\/code>:<\/p>\n<pre><code class=\"language-sql\">SHOW DATABASES;<\/code><\/pre>\n<p>I geng\u00e4ld s\u00e5 f\u00e5r du alla databaser som finns i arkivet:<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 220px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinqsta.com\/wp-content\/uploads\/2022\/10\/show-MySQL-databases.png\" alt=\"En lista \u00f6ver databaser som finns i arkivet.\" width=\"220\" height=\"232\"><figcaption class=\"wp-caption-text\">En lista \u00f6ver databaser som finns i arkivet.<\/figcaption><\/figure><\/figure>\n<p>Av de sex databaser som returneras s\u00e5 \u00e4r <code>information_schema<\/code> och <code>performance_schema<\/code> standarddatabaserna som genereras automatiskt n\u00e4r du installerar MySQL.<\/p>\n<p>Databasen <code>information_schema<\/code> \u00e4r en icke-modifierbar databas som lagrar all information om databaser och andra objekt (vyer, anv\u00e4ndarr\u00e4ttigheter, tabeller, begr\u00e4nsningar osv.) som lagras p\u00e5 MySQL-servern.<\/p>\n<h2>Filtrering av resultaten fr\u00e5n databasutmatningen<\/h2>\n<p>Tidigare s\u00e5 returnerade man alla databaser p\u00e5 MySQL-servern med <code>SHOW DATABASES<\/code>, men man beh\u00f6vde ofta filtrera databasutmatningen, fr\u00e4mst n\u00e4r det fanns m\u00e5nga databaser p\u00e5 servern.<\/p>\n<p>Med klausulen <code>LIKE<\/code> s\u00e5 filtreras resultatet av <code>SHOW DATABASE<\/code> utifr\u00e5n ett angivet m\u00f6nster. H\u00e4r \u00e4r den allm\u00e4nna syntaxen:<\/p>\n<pre><code class=\"language-sql\">SHOW DATABASES LIKE '';<\/code><\/pre>\n<p>Det m\u00e5ste vara en str\u00e4ng som representerar det m\u00f6nster som du vill matcha. Str\u00e4ngen m\u00e5ste sluta med procentsymbolen, <code>%<\/code>, som betecknar ett eller flera tecken.<\/p>\n<p>Om du exempelvis endast vill visa de databaser vars namn b\u00f6rjar p\u00e5 bokstaven <code>w<\/code>, s\u00e5 uppn\u00e5r du detta genom att k\u00f6ra f\u00f6ljande:<\/p>\n<pre><code class=\"language-sql\">SHOW DATABASES LIKE 'w%';<\/code><\/pre>\n<p>H\u00e4r \u00e4r det filtrerade resultatet:<\/p>\n<figure style=\"text-align: center\">\n<p><figure style=\"width: 270px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinqsta.com\/wp-content\/uploads\/2022\/10\/filter-list-mysql-databases.png\" alt=\"Det filtrerade databassvaret vid anv\u00e4ndning av \"w%\".\" width=\"270\" height=\"153\"><figcaption class=\"wp-caption-text\">Det filtrerade databassvaret vid anv\u00e4ndning av &#8221;w%&#8221;.<\/figcaption><\/figure><\/figure>\n<h2>Anv\u00e4ndning av informationsschema f\u00f6r att fr\u00e5ga efter tabellmetadata<\/h2>\n<p>Tidigare s\u00e5 kunde du se hur databasen <code>information_schema<\/code> lagrade all information om databaser, tabeller och andra objekt i MySQL-servermilj\u00f6n.<\/p>\n<p>Databasen <code>information_schema<\/code> anv\u00e4nder sig av schematabellen f\u00f6r att lagra information om alla databaser. F\u00f6r databasfiltrering s\u00e5 kan du utf\u00f6ra en komplex s\u00f6kning f\u00f6r att s\u00f6ka i schematabellen efter specifika databaser.<\/p>\n<p>Om du exempelvis vill ha databaser vars namn b\u00f6rjar p\u00e5 antingen &#8221;samp&#8221; eller &#8221;word&#8221; s\u00e5 kan du kombinera flera andra klausuler f\u00f6r att skapa en komplex s\u00f6kning:<\/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>H\u00e4r \u00e4r 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:\/\/kinqsta.com\/wp-content\/uploads\/2022\/10\/MySQL-SELECT-schema_name-FROM.png\" alt=\"Resultatet av den komplexa fr\u00e5gan.\" width=\"247\" height=\"161\"><figcaption class=\"wp-caption-text\">Resultatet av den komplexa fr\u00e5gan.<\/figcaption><\/figure><\/figure>\n<p>Du har dessutom tabellen <code>tables<\/code> fr\u00e5n databasen <code>information_schema<\/code>, som inkluderar information om alla tabeller. P\u00e5 samma s\u00e4tt s\u00e5 kan du utf\u00f6ra en f\u00f6rfr\u00e5gan f\u00f6r att endast h\u00e4mta de tabeller som matchar ett visst m\u00f6nster.<\/p>\n<p>F\u00f6ljande fr\u00e5ga returnerar exempelvis schemainformationen endast f\u00f6r <a href=\"https:\/\/kinqsta.com\/se\/blog\/wordpressdatabasen\/\" target=\"_blank\" rel=\"noopener noreferrer\">WordPress-tabellerna<\/a> \u2014 endast de tabeller vars namn b\u00f6rjar p\u00e5 &#8221;wp_&#8221;:<\/p>\n<pre><code class=\"language-sql\">SELECT * FROM information_schema.tables WHERE table_name LIKE 'wp_%';<\/code><\/pre>\n<p>H\u00e4r \u00e4r 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:\/\/kinqsta.com\/wp-content\/uploads\/2022\/10\/wp_tables-list-MySQL-database.png\" alt=\"Resultatet av schemainformationen endast f\u00f6r WordPress-tabellerna.\" width=\"929\" height=\"515\"><figcaption class=\"wp-caption-text\">Resultatet av schemainformationen endast f\u00f6r WordPress-tabellerna.<\/figcaption><\/figure><\/figure>\n<p>Andra tabeller som finns i <code>information_schema<\/code> \u00e4r <code>columns<\/code>, <code>constraints<\/code>, <code>table_constraints<\/code>, <code>check_constraints<\/code> och <code>referential_constraints<\/code>.<\/p>\n<h2>Vanliga problem och b\u00e4sta praxis<\/h2>\n<p>En av de vanligaste orsakerna till fel vid SQL-exekvering \u00e4r att man inte anv\u00e4nder semikolon i slutet av uttalanden.<\/p>\n<p>En annan orsak \u00e4r att man anv\u00e4nder en ogiltig SQL-syntax eller ett felaktigt stavat tabell-\/kolumnnamn. F\u00f6r att undvika detta s\u00e5 b\u00f6r du dubbelkontrollera tabell- eller kolumnnamnet f\u00f6r att se till att det \u00e4r korrekt stavat. Se \u00e4ven till att dubbelkolla syntaxen.<\/p>\n<p>H\u00e4r \u00e4r n\u00e5gra andra bra metoder att ha i \u00e5tanke.<\/p>\n<h3>Anv\u00e4nd versaler f\u00f6r SQL-nyckelord<\/h3>\n<p>N\u00e4r du skriver SQL-kod s\u00e5 ska du alltid anv\u00e4nda versaler f\u00f6r SQL-nyckelord och sm\u00e5 bokst\u00e4ver f\u00f6r tabell- och kolumnnamn. Detta g\u00f6r din kod mer l\u00e4ttl\u00e4st och mindre k\u00e4nslig f\u00f6r fel.<\/p>\n<p>S\u00e5 i st\u00e4llet f\u00f6r det h\u00e4r:<\/p>\n<pre><code class=\"language-sql\">select * from information_schema.tables where table_name like 'wp_%';<\/code><\/pre>\n<p>G\u00f6r s\u00e5 h\u00e4r:<\/p>\n<pre><code class=\"language-sql\">SELECT * FROM information_schema.tables WHERE table_name LIKE 'wp_%';<\/code><\/pre>\n<h3>Undvik att anv\u00e4nda <code>SELECT *<\/code><\/h3>\n<p>Undvik att anv\u00e4nda <code>SELECT *<\/code> i dina SQL-f\u00f6rfr\u00e5gningar. Din f\u00f6rfr\u00e5gan blir otydlig eftersom du inte alltid kan veta vad den kommer att ge tillbaka. Ange i st\u00e4llet de kolumner som du vill v\u00e4lja fr\u00e5n tabellen.<\/p>\n<p>S\u00e5 ist\u00e4llet f\u00f6r detta:<\/p>\n<pre><code class=\"language-sql\">SELECT * EXCEPT(phone) FROM users.profile<\/code><\/pre>\n<p>G\u00f6r s\u00e5 h\u00e4r:<\/p>\n<pre><code class=\"language-sql\">SELECT name,\n    dob,\n    address,\n    country,\n    address,\nFROM user.profile<\/code><\/pre>\n<h3>Dra in din kod<\/h3>\n<p>Slutligen s\u00e5 finns det ytterligare ett tips f\u00f6r att g\u00f6ra det l\u00e4ttare att hitta fel: att dra in koden. Det g\u00f6r den mer l\u00e4ttl\u00e4st!<\/p>\n<h2>Databashanterare<\/h2>\n<p>Du kan alternativt v\u00e4lja att hantera dina databaser utan att skriva SQL genom att anv\u00e4nda en databashanterare. Detta ger anv\u00e4ndarna tillg\u00e5ng till funktioner f\u00f6r databashantering utan att det beh\u00f6ver skrivas SQL-f\u00f6rfr\u00e5gningar. Denna programvara ansluter till en MySQL-server och tillhandah\u00e5ller ett anv\u00e4ndargr\u00e4nssnitt f\u00f6r att exponera databasfunktionerna. N\u00e4r den \u00e4r ansluten s\u00e5 visar anv\u00e4ndargr\u00e4nssnittet alla databaser p\u00e5 servern. Utseendet och k\u00e4nslan varierar mellan hanteringsverktygen, men processen \u00e4r likartad.<\/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:\/\/kinqsta.com\/wp-content\/uploads\/2021\/05\/devkinsta-adminer.png\" alt=\"DevKinsta's databashanterare.\" width=\"1200\" height=\"624\"><figcaption id=\"caption-attachment-95411\" class=\"wp-caption-text\">DevKinsta&#8217;s databashanterare.<\/figcaption><\/figure>\n<p>Det finns flera verktyg att v\u00e4lja mellan, bland annat <a href=\"https:\/\/kinqsta.com\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\" target=\"_blank\" rel=\"noopener noreferrer\">phpMyAdmin<\/a> och <a href=\"https:\/\/kinqsta.com\/se\/topics\/adminer\/\" target=\"_blank\" rel=\"noopener noreferrer\">Adminer<\/a>, som b\u00e5da finns tillg\u00e4ngliga via <a href=\"https:\/\/kinqsta.com\/se\/devkinsta\/\" target=\"_blank\" rel=\"noopener noreferrer\">DevKinsta<\/a>. Standardhanteringsverktyget f\u00f6r DevKinsta \u00e4r Adminer, eftersom det \u00e4r l\u00e4ttviktigt, enkelt och snabbt, <a href=\"https:\/\/kinqsta.com\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\" target=\"_blank\" rel=\"noopener noreferrer\">men phpMyAdmin kan n\u00e5s med l\u00e4tthet<\/a>.<\/p>\n<h2>Sammanfattning<\/h2>\n<p>Som serveradministrat\u00f6r s\u00e5 m\u00e5ste du kunna h\u00e4mta detaljer om databaserna p\u00e5 din MySQL-server p\u00e5 ett effektivt och korrekt s\u00e4tt. F\u00f6rm\u00e5gorna att se vilka databaser som finns p\u00e5 servern, visa specifika tabeller och informationen fr\u00e5n dem samt att f\u00e5 tillg\u00e5ng till information om anv\u00e4ndarroller och privilegier \u00e4r viktiga uppgifter. Du kan lyckligtvis anv\u00e4nda SQL fr\u00e5n din kommandorad f\u00f6r att g\u00f6ra allt detta till en barnlek.<\/p>\n<p><em>N\u00e4r din databashantering beh\u00f6ver g\u00e5 djupare \u00e4n till att bara fr\u00e5ga ut tabeller s\u00e5 kan Kinsta hj\u00e4lpa dig. L\u00e4r dig mer om v\u00e5ra <a href=\"https:\/\/sevalla.com\/application-hosting\/\" target=\"_blank\" rel=\"noopener noreferrer\">skalbara alternativ f\u00f6r databashosting<\/a> idag!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \u00e4r ett av dagens mest anv\u00e4nda relationella databashanteringssystem (RDBMS). Det \u00e4r en robust databasplattform som g\u00f6r det m\u00f6jligt att skapa och hantera skalbara databaser, huvudsakligen &#8230;<\/p>\n","protected":false},"author":117,"featured_media":46935,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[124,42],"topic":[754,768,796],"class_list":["post-46882","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-mysql","tag-webdev","topic-adminer","topic-devkinsta","topic-mysql-databas"],"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>Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)<\/title>\n<meta name=\"description\" content=\"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)\" \/>\n<meta property=\"og:description\" content=\"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/kinstasweden\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-02T15:16:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-21T09:17:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser-1.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=\"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser-1.png\" \/>\n<meta name=\"twitter:creator\" content=\"@salmanravoof\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_se\" \/>\n<meta name=\"twitter:label1\" content=\"Skriven av\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salman Ravoof\" \/>\n\t<meta name=\"twitter:label2\" content=\"Ber\u00e4knad l\u00e4stid\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minuter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/\"},\"author\":{\"name\":\"Salman Ravoof\",\"@id\":\"https:\/\/kinqsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\"},\"headline\":\"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)\",\"datePublished\":\"2022-11-02T15:16:05+00:00\",\"dateModified\":\"2023-09-21T09:17:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/\"},\"wordCount\":1473,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kinqsta.com\/se\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png\",\"keywords\":[\"mySQL\",\"webdev\"],\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/\",\"url\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/\",\"name\":\"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)\",\"isPartOf\":{\"@id\":\"https:\/\/kinqsta.com\/se\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png\",\"datePublished\":\"2022-11-02T15:16:05+00:00\",\"dateModified\":\"2023-09-21T09:17:30+00:00\",\"description\":\"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage\",\"url\":\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png\",\"contentUrl\":\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png\",\"width\":1460,\"height\":730,\"caption\":\"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinqsta.com\/se\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adminer\",\"item\":\"https:\/\/kinqsta.com\/se\/topics\/adminer\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinqsta.com\/se\/#website\",\"url\":\"https:\/\/kinqsta.com\/se\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar\",\"publisher\":{\"@id\":\"https:\/\/kinqsta.com\/se\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinqsta.com\/se\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sv-SE\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinqsta.com\/se\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinqsta.com\/se\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinqsta.com\/se\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinqsta.com\/se\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/kinstasweden\/\",\"https:\/\/x.com\/kinsta_se\",\"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:\/\/kinqsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\",\"name\":\"Salman Ravoof\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinqsta.com\/se\/#\/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:\/\/kinqsta.com\/se\/blog\/author\/salmanravoof\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)","description":"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.","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:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/","og_locale":"sv_SE","og_type":"article","og_title":"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)","og_description":"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.","og_url":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/kinstasweden\/","article_published_time":"2022-11-02T15:16:05+00:00","article_modified_time":"2023-09-21T09:17:30+00:00","og_image":[{"width":1460,"height":730,"url":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser-1.png","type":"image\/png"}],"author":"Salman Ravoof","twitter_card":"summary_large_image","twitter_description":"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.","twitter_image":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser-1.png","twitter_creator":"@salmanravoof","twitter_site":"@kinsta_se","twitter_misc":{"Skriven av":"Salman Ravoof","Ber\u00e4knad l\u00e4stid":"8 minuter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#article","isPartOf":{"@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/"},"author":{"name":"Salman Ravoof","@id":"https:\/\/kinqsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987"},"headline":"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)","datePublished":"2022-11-02T15:16:05+00:00","dateModified":"2023-09-21T09:17:30+00:00","mainEntityOfPage":{"@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/"},"wordCount":1473,"commentCount":0,"publisher":{"@id":"https:\/\/kinqsta.com\/se\/#organization"},"image":{"@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage"},"thumbnailUrl":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png","keywords":["mySQL","webdev"],"inLanguage":"sv-SE","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/","url":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/","name":"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)","isPartOf":{"@id":"https:\/\/kinqsta.com\/se\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage"},"image":{"@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage"},"thumbnailUrl":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png","datePublished":"2022-11-02T15:16:05+00:00","dateModified":"2023-09-21T09:17:30+00:00","description":"Ta din serveradministration till en ny niv\u00e5 genom att l\u00e4ra dig allt om hur du listar MySQL-datahbaser med terminalkommandon.","breadcrumb":{"@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#primaryimage","url":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png","contentUrl":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/11\/lista-mysql-databaser.png","width":1460,"height":730,"caption":"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)"},{"@type":"BreadcrumbList","@id":"https:\/\/kinqsta.com\/se\/blog\/lista-mysql-databaser\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinqsta.com\/se\/"},{"@type":"ListItem","position":2,"name":"Adminer","item":"https:\/\/kinqsta.com\/se\/topics\/adminer\/"},{"@type":"ListItem","position":3,"name":"Hur man listar MySQL-databaser (steg f\u00f6r steg-kodhandledning)"}]},{"@type":"WebSite","@id":"https:\/\/kinqsta.com\/se\/#website","url":"https:\/\/kinqsta.com\/se\/","name":"Kinsta\u00ae","description":"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar","publisher":{"@id":"https:\/\/kinqsta.com\/se\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinqsta.com\/se\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sv-SE"},{"@type":"Organization","@id":"https:\/\/kinqsta.com\/se\/#organization","name":"Kinsta","url":"https:\/\/kinqsta.com\/se\/","logo":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinqsta.com\/se\/#\/schema\/logo\/image\/","url":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinqsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinqsta.com\/se\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/kinstasweden\/","https:\/\/x.com\/kinsta_se","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:\/\/kinqsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987","name":"Salman Ravoof","image":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinqsta.com\/se\/#\/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:\/\/kinqsta.com\/se\/blog\/author\/salmanravoof\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/posts\/46882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/users\/117"}],"replies":[{"embeddable":true,"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/comments?post=46882"}],"version-history":[{"count":8,"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/posts\/46882\/revisions"}],"predecessor-version":[{"id":46939,"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/posts\/46882\/revisions\/46939"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/pt"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/fr"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/de"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/jp"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/nl"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/es"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/se"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/translations\/dk"},{"href":"https:\/\/kinqsta.com\/se\/wp-json\/kinsta\/v1\/posts\/46882\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/media\/46935"}],"wp:attachment":[{"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/media?parent=46882"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/tags?post=46882"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinqsta.com\/se\/wp-json\/wp\/v2\/topic?post=46882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}