{"id":43730,"date":"2022-05-18T07:36:45","date_gmt":"2022-05-18T07:36:45","guid":{"rendered":"https:\/\/kinsta.com\/se\/?p=43730&#038;preview=true&#038;preview_id=43730"},"modified":"2023-09-21T09:13:24","modified_gmt":"2023-09-21T09:13:24","slug":"adminer","status":"publish","type":"post","link":"https:\/\/kinsta.com\/se\/blog\/adminer\/","title":{"rendered":"Hur man anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil"},"content":{"rendered":"<p>Att kunna hantera <a href=\"https:\/\/kinsta.com\/se\/blog\/vad-ar-mysql\/\">MySQL-databaser<\/a> \u00e4r ett av de grundl\u00e4ggande kraven f\u00f6r att vara en professionell WordPress-utvecklare. Adminer f\u00f6renklar den uppgiften oerh\u00f6rt.<\/p>\n<p>Varje WordPress-webbplats kr\u00e4ver en databas f\u00f6r att fungera &#8211; det \u00e4r d\u00e4r WordPress lagrar alla dina webbplatsers kritiska data. \u00c4ven om phpMyAdmin har varit ett p\u00e5litligt databashanteringsverktyg f\u00f6r <a href=\"https:\/\/kinsta.com\/se\/blog\/mariadb-vs-mysql\/\">MySQL\/MariaDB<\/a> i m\u00e5nga \u00e5r, \u00e4r Adminer ett bra alternativ. Det levereras laddat med massor av anv\u00e4ndbara funktioner och ett vackrare anv\u00e4ndargr\u00e4nssnitt, allt i en enda, l\u00e4ttviktig PHP-fil som du snabbt kan distribuera p\u00e5 din server.<\/p>\n<p>I det h\u00e4r inl\u00e4gget kommer du att l\u00e4ra dig mer om Adminer, de m\u00e5nga f\u00f6rdelarna som det erbjuder j\u00e4mf\u00f6rt med phpMyAdmin och hur du kan anv\u00e4nda det f\u00f6r att hantera dina databaser. Vi kommer \u00e4ven att unders\u00f6ka hur <a href=\"https:\/\/kinsta.com\/se\/devkinsta\/\">DevKinsta<\/a> anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla WordPress-databashantering i <a href=\"https:\/\/kinsta.com\/se\/blog\/installerar-wordpress-lokalt\/\">lokala utvecklingsmilj\u00f6er<\/a>.<\/p>\n<p>L\u00e5t oss k\u00f6ra ig\u00e5ng!<\/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\n<h2>Vad \u00e4r Adminer?<\/h2>\n<p>Adminer (tidigare phpMinAdmin) \u00e4r ett <a href=\"https:\/\/kinsta.com\/se\/blog\/vad-ar-php\/\">PHP-baserat<\/a>, kostnadsfritt, databashanteringsverktyg med \u00f6ppen k\u00e4llkod. Det \u00e4r superenkelt att distribuera p\u00e5 din server. Allt som du beh\u00f6ver g\u00f6ra f\u00f6r att nyttja detta verktyg \u00e4r att ladda upp dess enda PHP-fil, rikta din webbl\u00e4sare mot den och logga in.<\/p>\n<figure id=\"attachment_87154\" aria-describedby=\"caption-attachment-87154\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87154 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Basic-Login-Screen.png\" alt=\"Inloggningssida f\u00f6r Adminer\" width=\"1100\" height=\"364\"><figcaption id=\"caption-attachment-87154\" class=\"wp-caption-text\">Inloggningssida f\u00f6r Adminer<\/figcaption><\/figure>\n<p>Till skillnad fr\u00e5n <a href=\"https:\/\/kinsta.com\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\">phpMyAdmin<\/a>, som endast st\u00f6der hanteringen av<strong> MySQL-<\/strong> och <strong>MariaDB-databaser<\/strong>, st\u00f6der Adminer \u00e4ven hantering av andra databaser som <a href=\"https:\/\/kinsta.com\/blog\/what-is-postgresql\/\"><strong>PostgreSQL<\/strong><\/a>, <strong>SQLite<\/strong>, <strong>MS SQL<\/strong>, <strong>Oracle<\/strong>, <strong>SimpleDB<\/strong>, <strong>Elasticsearch<\/strong>, <a href=\"https:\/\/kinsta.com\/blog\/what-is-mongodb\/\"><strong>MongoDB<\/strong><\/a>\u00a0och <strong>Firebird<\/strong>. Det finns \u00e4ven p\u00e5 <strong>43<\/strong> spr\u00e5k.<\/p>\n<p>Adminer erbjuder ett l\u00e4ttanv\u00e4nt gr\u00e4nssnitt, b\u00e4ttre st\u00f6d f\u00f6r m\u00e5nga MySQL-funktioner, mer anm\u00e4rkningsv\u00e4rd prestanda och en \u00f6kad s\u00e4kerhet.<\/p>\n<p>L\u00e5t oss nu utforska hur du installerar Adminer.<\/p>\n<h2>Hur man anv\u00e4nder Adminer<\/h2>\n<p>Men innan du installerar det, kommer h\u00e4r n\u00e5gra grundl\u00e4ggande krav f\u00f6r att Adminer ska fungera p\u00e5 din server:<\/p>\n<ul>\n<li><a href=\"https:\/\/kinsta.com\/se\/blog\/installerar-php\/\">Installera PHP<\/a> 5, 7 eller <a href=\"https:\/\/kinsta.com\/se\/blog\/php-8\/\">8<\/a><\/li>\n<li>En databasdrivrutin (t.ex. MySQL, PostgreSQL osv.)<\/li>\n<\/ul>\n<p>Det \u00e4r i stort sett allt!<\/p>\n<p>Ladda ner den <a href=\"https:\/\/www.adminer.org\/\">senaste versionen av Adminer<\/a> fr\u00e5n deras officiella webbplats. Du kan \u00e4ven hitta MySQL-exklusiva och engelska-exklusiva varianter av Adminer d\u00e4r. Om du hanterar en MySQL- eller MariaDB-databas (t.ex. f\u00f6r en WordPress-webbplats) kan du skaffa dessa l\u00e4ttviktiga varianter.<\/p>\n<figure id=\"attachment_87155\" aria-describedby=\"caption-attachment-87155\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87155 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Download-Adminer-Latest-Version-Full-English-MySQL-Only.png\" alt=\"Ladda ner Adminers senaste version\" width=\"1100\" height=\"351\"><figcaption id=\"caption-attachment-87155\" class=\"wp-caption-text\">Ladda ner Adminers senaste version<\/figcaption><\/figure>\n<p>Alternativt, om du anv\u00e4nder <a href=\"https:\/\/kinsta.com\/blog\/ssh-commands\/\">terminalen<\/a>, kan du ladda ner det direkt till din katalog med <strong>curl-kommandot<\/strong>.<\/p>\n<pre><code class=\"language-bash\">curl -o https:\/\/github.com\/vrana\/adminer\/releases\/download\/v4.7.8\/adminer-4.7.8.php<\/code><\/pre>\n<p>Adminer<strong> 4.7.8<\/strong> \u00e4r den senaste stabila versionen. Det l\u00e4gger till st\u00f6d f\u00f6r den nyss lanserade <a href=\"https:\/\/kinsta.com\/se\/blog\/php-8\/\">PHP 8.0<\/a>. Du kan \u00e4ndra Adminers versionsnummer i ovanst\u00e5ende kods nedladdnings-URL om det finns en ny version tillg\u00e4nglig.<\/p>\n<p>N\u00e4r du har laddat ner Adminer kan du placera den h\u00e4r <strong>.php-filen<\/strong> var som helst p\u00e5 din server, som exempelvis dess rotmapp. Det \u00e4r dock bra att placera alla dina verktyg fr\u00e5n tredje part i en separat katalog (t.ex. <strong>leverant\u00f6r<\/strong>, <strong>tillg\u00e5ngar<\/strong> osv.).<\/p>\n<p>Du har nu installerat Adminer p\u00e5 servern. Dess plug and play-design inneb\u00e4r att Adminer kommer att fungera p\u00e5 n\u00e4stan vilken server som helst.<\/p>\n<h3>S\u00e5 h\u00e4r f\u00e5r du \u00e5tkomst till Adminer<\/h3>\n<p>F\u00f6r att komma \u00e5t Adminer \u00e4r allt som du beh\u00f6ver g\u00f6ra att bes\u00f6ka l\u00e4nken via din webbl\u00e4sare.<\/p>\n<p>Om du exempelvis har placerat det i webbplatsens rotkatalog kan du komma \u00e5t det genom att bes\u00f6ka<strong> https:\/\/your-website.com\/adminer-4.7.8.php<\/strong>. Om du inte har en dom\u00e4nnamnskonfiguration kan du \u00e4ven komma \u00e5t det via <a href=\"https:\/\/kinsta.com\/docs\/wordpress-hosting\/site-management\/ip-addresses\/#site-ip-address-ipv4\">serverns IP-adress<\/a> eller <a href=\"https:\/\/kinsta.com\/se\/blog\/vad-ar-localhost\/\">localhost-milj\u00f6<\/a>.<\/p>\n<figure id=\"attachment_87156\" aria-describedby=\"caption-attachment-87156\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87156 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Login-Saved-Sessions-Database-Name.png\" alt=\"Logga in p\u00e5 Adminer med eller utan databasnamn\" width=\"1100\" height=\"429\"><figcaption id=\"caption-attachment-87156\" class=\"wp-caption-text\">Logga in p\u00e5 Adminer med eller utan databasnamn<\/figcaption><\/figure>\n<p>H\u00e4rifr\u00e5n kan du logga in p\u00e5 valfri databas som \u00e4r installerad p\u00e5 din server. Du kan \u00e4ven l\u00e4mna databasf\u00e4ltet tomt. Adminer visar dig en lista \u00f6ver alla databaser p\u00e5 n\u00e4sta sk\u00e4rm.<\/p>\n<p>Om du markerar alternativet <strong>Permanent inloggning<\/strong> sparas dina inloggningsuppgifter s\u00e5 att du enkelt kan bes\u00f6ka den h\u00e4r sessionen senare via l\u00e4nkarna p\u00e5 sidan.<\/p>\n<figure id=\"attachment_87157\" aria-describedby=\"caption-attachment-87157\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87157 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Database-List-Screen.png\" alt=\"Adminer listar alla databaser om du inte anger en specifik\" width=\"1100\" height=\"550\"><figcaption id=\"caption-attachment-87157\" class=\"wp-caption-text\">Adminer listar alla databaser om du inte anger en specifik<\/figcaption><\/figure>\n<h2>Adminer-funktioner<\/h2>\n<p>Adminer inkluderar m\u00e5nga funktioner som g\u00f6r databashanteringen mer enkel. Det \u00e4r dags att djupdyka i dem.<\/p>\n<div><\/div><kinsta-auto-toc list-style=\"disc\" selector=\"h3\" count-number=\"14\" sub-toc=\"true\"><\/kinsta-auto-toc>\n<h3>Ansluta till en databasserver<\/h3>\n<p>Som vi har f\u00f6rklarat tidigare kan du <a href=\"https:\/\/kinsta.com\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\">ansluta till valfri databas-server<\/a> som Adminer st\u00f6der. F\u00f6r en MySQL-databasserver \u00e4r standardanv\u00e4ndarnamnet <strong>root<\/strong> och standardl\u00f6senordet \u00e4r en tom str\u00e4ng. Du kan \u00e4ven v\u00e4lja en befintlig databas att hantera h\u00e4r.<\/p>\n<figure id=\"attachment_87158\" aria-describedby=\"caption-attachment-87158\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87158 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Exploring-WordPress-Database-With-Adminer.png\" alt=\"Utforska en WordPress-databas med Adminer\" width=\"1100\" height=\"676\"><figcaption id=\"caption-attachment-87158\" class=\"wp-caption-text\">Utforska en WordPress-databas med Adminer<\/figcaption><\/figure>\n<h3>Skapa en ny databas<\/h3>\n<p>Du kan klicka p\u00e5 l\u00e4nken <strong>Skapa databas<\/strong> f\u00f6r att skapa en ny MySQL-databas. Ange databasnamnet och v\u00e4lj dess sorteringstyp. F\u00f6r WordPress-databaser \u00e4r den rekommenderade sorteringstypen <strong>utf8mb4_unicode_ci<\/strong>.<\/p>\n<figure id=\"attachment_87193\" aria-describedby=\"caption-attachment-87193\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87193 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Create-New-Database-Adminer-MySQL.png\" alt=\"Skapa en ny databas i Adminer\" width=\"1100\" height=\"520\"><figcaption id=\"caption-attachment-87193\" class=\"wp-caption-text\">Skapa en ny databas i Adminer<\/figcaption><\/figure>\n<p>N\u00e4r du har skapat en databas kan du \u00e4ndra olika aspekter av den, exempelvis databasens namn, schema, anv\u00e4ndare och tabeller.<\/p>\n<figure id=\"attachment_87160\" aria-describedby=\"caption-attachment-87160\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87160 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Create-MySQL-Database-Adminer-Database-Name-Collation-Type.png\" alt=\"Ange databasnamn och sorteringstyp f\u00f6r att skapa en databas\" width=\"1100\" height=\"530\"><figcaption id=\"caption-attachment-87160\" class=\"wp-caption-text\">Ange databasnamn och sorteringstyp f\u00f6r att skapa en databas<\/figcaption><\/figure>\n<p>Nu har du skapat en ny MySQL-databas. N\u00e4sta sida visar fler alternativ f\u00f6r att fylla den med tabeller, kolumner och mer.<\/p>\n<figure id=\"attachment_87161\" aria-describedby=\"caption-attachment-87161\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87161 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/New-Database-Created-Adminer.png\" alt=\"Hitta den nya databasen som listas i rullgardinsmenyn och titeln\" width=\"1100\" height=\"540\"><figcaption id=\"caption-attachment-87161\" class=\"wp-caption-text\">Hitta den nya databasen som listas i rullgardinsmenyn och titeln<\/figcaption><\/figure>\n<h3>\u00c4ndra databasnamn och sorteringstyp<\/h3>\n<p>Om du klickar p\u00e5 l\u00e4nken <strong>\u00c4ndra databas<\/strong> kan du \u00e4ndra dess namn och sorteringstyp. Om du precis har skapat en databas och gjort ett stavfel kommer detta att vara till stor nytta.<\/p>\n<figure id=\"attachment_87162\" aria-describedby=\"caption-attachment-87162\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87162 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Alter-Database-Tab.png\" alt=\"Redigera databaser enkelt med Adminers alternativ \"\u00c4ndra databas\"\" width=\"1100\" height=\"540\"><figcaption id=\"caption-attachment-87162\" class=\"wp-caption-text\">Redigera databaser enkelt med Adminers alternativ &#8221;\u00c4ndra databas&#8221;<\/figcaption><\/figure>\n<p>Jag \u00e4ndrade exempelvis databasens sorteringstyp fr\u00e5n <strong>utf8_unicode_ci<\/strong> till <strong>utf8mb4_unicode_ci<\/strong>.<\/p>\n<figure id=\"attachment_87168\" aria-describedby=\"caption-attachment-87168\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87168 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Alter-Database-Screen-Change-Name-Collation-Type.png\" alt=\"\u00c4ndra en databas i Adminer\" width=\"1100\" height=\"312\"><figcaption id=\"caption-attachment-87168\" class=\"wp-caption-text\">\u00c4ndra en databas i Adminer<\/figcaption><\/figure>\n<p><strong>Obs:<\/strong> Om databasen redan anv\u00e4nds av n\u00e5got program ska du se till att de \u00e4ndringar som du g\u00f6r h\u00e4r \u00e4ven \u00e5terspeglas i programmets kod.<\/p>\n<h3>Utforska databasschemat<\/h3>\n<p>Ett databasschema refererar till den logiska konfigurationen som definierar hur alla databaselement \u00e4r relaterade. I MySQL \u00e4r <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/system-schema.html\">ett schema<\/a> synonymt med en databas. De h\u00e4nvisar med andra ord till samma sak.<\/p>\n<p>Men i andra databaser som PostgreSQL och Oracle refererar ett schema till en samling tabeller. Det \u00e4r bara en del av databasen.<\/p>\n<p>WordPress anv\u00e4nder MySQL f\u00f6r sin databas. Av den anledningen \u00e4r dess schema i huvudsak dess tabeller med sina kolumner. Adminer l\u00e5ter dig till och med flytta runt schemarutorna och leka med dem som du vill.<\/p>\n<figure id=\"attachment_87163\" aria-describedby=\"caption-attachment-87163\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87163 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/WordPress-Database-Schema-Adminer.png\" alt=\"Utforska WordPress-databasschemat i Adminer\" width=\"1100\" height=\"588\"><figcaption id=\"caption-attachment-87163\" class=\"wp-caption-text\">Utforska WordPress-databasschemat i Adminer<\/figcaption><\/figure>\n<p>Det \u00e4r ett utm\u00e4rkt s\u00e4tt att l\u00e4ra sig hur en typisk WordPress-databasstruktur \u00e4r uppbyggd.<\/p>\n<h3>Inspektera tabelldata och struktur<\/h3>\n<p>Om du klickar p\u00e5 en tabell visas mer information om den. Adminer dirigerar dig som standard till tabellens flik<strong> Visa struktur<\/strong>. H\u00e4r hittar du information om tabellens kolumner, exempelvis deras namn, typer och index.<\/p>\n<figure id=\"attachment_87164\" aria-describedby=\"caption-attachment-87164\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87164 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Show-Structure-Database-Table-Adminer.png\" alt=\"Om du klickar p\u00e5 en tabell visas dess \"Struktur\"\" width=\"1100\" height=\"580\"><figcaption id=\"caption-attachment-87164\" class=\"wp-caption-text\">Om du klickar p\u00e5 en tabell visas dess &#8221;Struktur&#8221;<\/figcaption><\/figure>\n<p>Om databastabellen har n\u00e5gra associerade fr\u00e4mmande nycklar eller utl\u00f6sare visas \u00e4ven dessa i sektionen l\u00e4ngst ned.<\/p>\n<p>Exemplet ovan visar information om tabellen <a href=\"https:\/\/kinsta.com\/se\/blog\/wp-options-autoladdad-data\/\">wp_options<\/a>. Det \u00e4r d\u00e4r WordPress lagrar alla sina viktiga inst\u00e4llningar. D\u00e4refter kan du g\u00e5 till fliken <strong>V\u00e4lj data<\/strong> f\u00f6r att se alla v\u00e4rden som lagras i den h\u00e4r tabellen.<\/p>\n<figure id=\"attachment_87165\" aria-describedby=\"caption-attachment-87165\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87165 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Select-Data-Database-Table-Tab-Adminer.png\" alt=\"Visa alla tabelldata som listas kolumnvis\" width=\"1100\" height=\"634\"><figcaption id=\"caption-attachment-87165\" class=\"wp-caption-text\">Visa alla tabelldata som listas kolumnvis<\/figcaption><\/figure>\n<p>Som du kan se \u00e4r <a href=\"https:\/\/kinsta.com\/se\/karriarer\/\">anv\u00e4ndargr\u00e4nssnittet<\/a> h\u00e4r mycket sk\u00f6nare f\u00f6r \u00f6gonen \u00e4n det som finns i phpMyAdmin.<\/p>\n<h3>\u00c4ndra tabell- och kolumninst\u00e4llningar<\/h3>\n<p>Klicka p\u00e5 l\u00e4nken <strong>\u00c4ndra tabell<\/strong> h\u00f6gst upp f\u00f6r att \u00e4ndra tabell- och kolumninst\u00e4llningarna.<\/p>\n<figure id=\"attachment_87166\" aria-describedby=\"caption-attachment-87166\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87166 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Alter-Database-Table-Engine-Collation-Column-Options.png\" alt=\"\u00c4ndra databastabeller och kolumner enkelt via Adminer\" width=\"1100\" height=\"466\"><figcaption id=\"caption-attachment-87166\" class=\"wp-caption-text\">\u00c4ndra databastabeller och kolumner enkelt via Adminer<\/figcaption><\/figure>\n<p>Du kan \u00e4ndra namn, motor och sorteringstyp f\u00f6r tabellen. L\u00e4ngst ned hittar du \u00e4ven alternativ f\u00f6r att st\u00e4lla in tabellens standardv\u00e4rde f\u00f6r att starta automatiska steg och ser om du kan st\u00e4lla in dess kolumner med ett standardv\u00e4rde och kommentarer.<\/p>\n<p>N\u00e4r det g\u00e4ller kolumnerna kan du \u00e4ndra deras namn, typ, l\u00e4ngd och sorteringstyp.<\/p>\n<p>Du kan \u00e4ven l\u00e4gga till eller ta bort kolumner genom att klicka p\u00e5 knapparna <strong>+<\/strong> och <strong>x<\/strong>.\u00a0Knappen<strong> Sl\u00e4pp<\/strong> tar bort databastabellen helt och h\u00e5llet, s\u00e5 anv\u00e4nd den med f\u00f6rsiktighet.<\/p>\n<p>N\u00e4r du har gjort \u00e4ndringarna, gl\u00f6m inte att trycka p\u00e5 <strong>Spara-knappen<\/strong>.<\/p>\n<h3>Infoga nya poster och uppdatera befintliga<\/h3>\n<p>Tryck p\u00e5 l\u00e4nken <strong>Nytt objekt<\/strong> f\u00f6r att g\u00e5 till fliken <strong>Infoga: &lt;table_name&gt;<\/strong>.<\/p>\n<figure id=\"attachment_87167\" aria-describedby=\"caption-attachment-87167\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87167 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Insert-New-Records-Items-In-Database-Table-Adminer.png\" alt=\"Infoga en ny post i databastabellens kolumner\" width=\"1100\" height=\"420\"><figcaption id=\"caption-attachment-87167\" class=\"wp-caption-text\">Infoga en ny post i databastabellens kolumner<\/figcaption><\/figure>\n<p>H\u00e4r kan du l\u00e4gga till en ny rad i tabellen. Adminer listar kolumnnamnen och deras typer s\u00e5 att du snabbt kan ange dem. Du kan \u00e4ven k\u00f6ra en hash-funktion f\u00f6r det v\u00e4rde som du anger f\u00f6r att kryptera dem automatiskt. Detta \u00e4r v\u00e4ldigt anv\u00e4ndbart om dina data \u00e4r k\u00e4nsliga, som ett l\u00f6senord. Som ett exempel <a href=\"https:\/\/kinsta.com\/se\/blog\/anda-wordpress-losenord\/#hur-man-ndrar-eller-terstller-wordpress-lsenord-frn-phpmyadmin\">lagrar WordPress sina l\u00f6senord<\/a> i databasen med MD5-algoritmen.<\/p>\n<p>Det \u00e4r lika enkelt att redigera en befintlig post. Om du exempelvis vill \u00e4ndra webbplatsens beskrivning kan du redigera <strong>v\u00e4rdet f\u00f6r bloggbeskrivningsalternativet<\/strong> i din <strong>wp_options-tabell<\/strong>.<\/p>\n<figure id=\"attachment_87169\" aria-describedby=\"caption-attachment-87169\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87169 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Editing-Existing-MySQL-Database-Record-Adminer.png\" alt=\"Redigera en befintlig databaspost i Adminer\" width=\"1100\" height=\"420\"><figcaption id=\"caption-attachment-87169\" class=\"wp-caption-text\">Redigera en befintlig databaspost i Adminer<\/figcaption><\/figure>\n<p>Ange sedan din nya bloggbeskrivning i f\u00e4ltet <strong>option_value<\/strong> och klicka p\u00e5 <strong>Spara-knappen<\/strong> f\u00f6r att dina \u00e4ndringar ska tr\u00e4da i kraft.<\/p>\n<figure id=\"attachment_87170\" aria-describedby=\"caption-attachment-87170\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87170 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/New-Database-Record-Blog-Description-Value-Adminer.png\" alt=\"\u00c4ndra en WordPress-webbplats beskrivning via Adminer\" width=\"1100\" height=\"488\"><figcaption id=\"caption-attachment-87170\" class=\"wp-caption-text\">\u00c4ndra en WordPress-webbplats beskrivning via Adminer<\/figcaption><\/figure>\n<h3>S\u00f6k data i alla tabeller<\/h3>\n<p>Adminer l\u00e5ter dig s\u00f6ka efter data i en databas samtliga tabeller samtidigt. Detta visar dig de tabeller som mest sannolikt har det h\u00e4r v\u00e4rdet.<\/p>\n<figure id=\"attachment_87171\" aria-describedby=\"caption-attachment-87171\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87171 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Searching-Term-Adminer-Dashboard.png\" alt=\"S\u00f6ka efter en term i en databas i Adminer\" width=\"1100\" height=\"500\"><figcaption id=\"caption-attachment-87171\" class=\"wp-caption-text\">S\u00f6ka efter en term i en databas i Adminer<\/figcaption><\/figure>\n<p>N\u00e4r jag s\u00f6kte efter termen <strong>home<\/strong> drog Adminer upp <strong>wp_options-tabellen<\/strong> som den mest troliga kandidaten. Genom att klicka p\u00e5 den kunde jag se den exakta kolumnen och de rader d\u00e4r Adminer hittade detta ord i databasen.<\/p>\n<p>Om du klickar p\u00e5 en tabell som listas under s\u00f6kresultatet visas mer information om den. H\u00e4rifr\u00e5n kan du <a href=\"https:\/\/kinsta.com\/blog\/wordpress-search-and-replace\/\">utf\u00f6ra en mer detaljerad s\u00f6kning<\/a> i den h\u00e4r tabellen.<\/p>\n<figure id=\"attachment_87172\" aria-describedby=\"caption-attachment-87172\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87172 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Select-Term-Adminer-Table.png\" alt=\"G\u00f6r en djups\u00f6kning i tabellen som f\u00f6resl\u00e5s\" width=\"1100\" height=\"407\"><figcaption id=\"caption-attachment-87172\" class=\"wp-caption-text\">G\u00f6r en djups\u00f6kning i tabellen som f\u00f6resl\u00e5s<\/figcaption><\/figure>\n<p>Jag kan exempelvis redigera v\u00e4rdet p\u00e5 <strong>hemalternativets<\/strong> namn och \u00e4ndra <a href=\"https:\/\/kinsta.com\/blog\/what-is-a-url\/\">webbadressen<\/a> till min webbplats hemsida.<\/p>\n<h3>Trunkera, sl\u00e4pp, flytta och kopiera tabeller<\/h3>\n<p>Med Adminer kan du utf\u00f6ra m\u00e5nga \u00e5tg\u00e4rder p\u00e5 tabeller direkt fr\u00e5n databasens instrumentpanel.<\/p>\n<figure id=\"attachment_87173\" aria-describedby=\"caption-attachment-87173\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87173 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Perform-Database-Table-Operations-Truncate-Drop-Move-Copy.png\" alt=\"K\u00f6r enkelt SQL-\u00e5tg\u00e4rder p\u00e5 tabeller\" width=\"1100\" height=\"573\"><figcaption id=\"caption-attachment-87173\" class=\"wp-caption-text\">K\u00f6r enkelt SQL-\u00e5tg\u00e4rder p\u00e5 tabeller<\/figcaption><\/figure>\n<p>Du kan utf\u00f6ra m\u00e5nga SQL-s\u00f6kfr\u00e5gor p\u00e5 tabeller genom att markera dem och klicka p\u00e5 knapparna nedan.<\/p>\n<p>Om du exempelvis vill <a href=\"https:\/\/kinsta.com\/se\/blog\/wordpress-inaktiverar-kommentarer\/\">ta bort<\/a> alla <a href=\"https:\/\/kinsta.com\/blog\/wordpress-comments\/\">kommentarer p\u00e5 din webbplats<\/a> kan du v\u00e4lja tabellen<strong> wp_comments<\/strong> och trycka p\u00e5 knappen <strong>Trunkera<\/strong>. Alla rader i tabellen t\u00f6ms, men den bevarar fortfarande den befintliga kolumnstrukturen. Om du trycker p\u00e5 <strong>Sl\u00e4pp-knappen<\/strong> raderas tabellen helt och h\u00e5llet.<\/p>\n<p>H\u00e4rifr\u00e5n kan du \u00e4ven<strong> flytta<\/strong> eller <strong>kopiera<\/strong> tabellen till en annan databas. Alternativet <strong>Skriv \u00f6ver<\/strong> \u00e4r ett snabbt och smutsigt s\u00e4tt att \u00f6verf\u00f6ra webbplatsdata som inl\u00e4gg och kommentarer fr\u00e5n en webbplats till en annan.<\/p>\n<h3>Skapa tabeller, vyer, rutiner och h\u00e4ndelser<\/h3>\n<p>Du kan anv\u00e4nda Adminer f\u00f6r att skapa nya tabeller, vyer, rutiner och h\u00e4ndelser.<\/p>\n<figure id=\"attachment_87175\" aria-describedby=\"caption-attachment-87175\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87175 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Create-Table-Screen-Adminer.png\" alt=\"Det \u00e4r enkelt att skapa en ny tabell med Adminer\" width=\"1100\" height=\"474\"><figcaption id=\"caption-attachment-87175\" class=\"wp-caption-text\">Det \u00e4r enkelt att skapa en ny tabell med Adminer<\/figcaption><\/figure>\n<p>Med funktionen <strong>Skapa tabell<\/strong> kan du definiera tabellens fullst\u00e4ndiga schema, inklusive dess kolumner och kapslade v\u00e4rden.<\/p>\n<p>Avancerade anv\u00e4ndare kan anv\u00e4nda Adminers andra avancerade funktioner f\u00f6r att definiera MySQL-vyer, procedurer, funktioner och h\u00e4ndelser.<\/p>\n<figure id=\"attachment_87176\" aria-describedby=\"caption-attachment-87176\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87176 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Create-Function-Screen-Adminer.png\" alt=\"Skapa enkelt m\u00e5nga andra SQL-funktioner med Adminer\" width=\"1100\" height=\"474\"><figcaption id=\"caption-attachment-87176\" class=\"wp-caption-text\">Skapa enkelt m\u00e5nga andra SQL-funktioner med Adminer<\/figcaption><\/figure>\n<h3>Importera eller exportera en databas<\/h3>\n<p>Med Adminer kan du enkelt importera en MySQL-databas. Allt du beh\u00f6ver g\u00f6ra \u00e4r att ladda upp den s\u00e4kerhetskopierade<strong> .sql<\/strong> eller . <strong>sql.gz<\/strong> (rekommenderas)-filen och k\u00f6ra den. Den h\u00e4r metoden \u00e4r ett enkelt s\u00e4tt att <a href=\"https:\/\/kinsta.com\/blog\/how-to-restore-mysql-database-using-phpmyadmin\/\">\u00e5terst\u00e4lla en MySQL-databas<\/a>.<\/p>\n<figure id=\"attachment_87177\" aria-describedby=\"caption-attachment-87177\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87177 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-MySQL-Database-Import-Screen.png\" alt=\"Importera en MySQL-databas i Adminer\" width=\"1100\" height=\"440\"><figcaption id=\"caption-attachment-87177\" class=\"wp-caption-text\">Importera en MySQL-databas i Adminer<\/figcaption><\/figure>\n<p>P\u00e5 samma s\u00e4tt \u00e4r det \u00e4ven otroligt enkelt att <a href=\"https:\/\/kinsta.com\/blog\/mysql-backup-database\/\">s\u00e4kerhetskopiera en befintlig databas<\/a> med Adminer. Klicka p\u00e5 <strong>exportera<\/strong> l\u00e4nken och v\u00e4lj sedan exportalternativ som utdatatyp, format och andra databasinst\u00e4llningar. Du kan \u00e4ven v\u00e4lja de tabeller som du vill exportera.<\/p>\n<figure id=\"attachment_87178\" aria-describedby=\"caption-attachment-87178\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87178 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Default-Export-Database-Output-Options.png\" alt=\"Exportera en databas i Adminer\" width=\"1100\" height=\"440\"><figcaption id=\"caption-attachment-87178\" class=\"wp-caption-text\">Exportera en databas i Adminer<\/figcaption><\/figure>\n<p>Som standard st\u00f6der Adminer export av databasen med <strong>\u00f6ppna<\/strong>, <strong>spara<\/strong> eller <strong>GZIP-utmatningar<\/strong>, med <strong>SQL<\/strong>, <strong>CSV<\/strong>, <strong>CSV<\/strong>; eller <strong>TSV-format<\/strong>. Du kan dock ut\u00f6ka den h\u00e4r funktionen enkelt med Adminer-plugins. Jag kommer att g\u00e5 igenom dem senare i den h\u00e4r artikeln.<\/p>\n<h3>K\u00f6ra SQL-s\u00f6kfr\u00e5gor<\/h3>\n<p>Du beh\u00f6ver inte hantera ett klumpigt anv\u00e4ndargr\u00e4nssnitt med Adminer f\u00f6r att k\u00f6ra en SQL-s\u00f6kfr\u00e5ga. Bes\u00f6k bara <strong>SQL-kommandosk\u00e4rmen<\/strong> och k\u00f6r vilken s\u00f6kfr\u00e5ga som du vill.<\/p>\n<figure id=\"attachment_87174\" aria-describedby=\"caption-attachment-87174\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87174 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/SQL-Command-Center-in-Adminer.png\" alt=\"K\u00f6r SQL-s\u00f6kfr\u00e5gor i Adminers SQL-kommando\" width=\"1100\" height=\"573\"><figcaption id=\"caption-attachment-87174\" class=\"wp-caption-text\">K\u00f6r SQL-s\u00f6kfr\u00e5gor i Adminers SQL-kommando<\/figcaption><\/figure>\n<p>Observera syntaxmarkeringen. Adminer l\u00e4nkar till och med de markerade SQL-nyckelorden till deras officiella dokumentation.<\/p>\n<p>Innan du k\u00f6r s\u00f6kfr\u00e5gan kan du begr\u00e4nsa dess rader, st\u00e4lla in den s\u00e5 att den slutar k\u00f6ras n\u00e4r den tr\u00e4ffar ett fel och bara visar utdata f\u00f6r fel.<\/p>\n<h3>Visa och skapa beh\u00f6righeter (anv\u00e4ndare)<\/h3>\n<p>Du kan anv\u00e4nda Adminer f\u00f6r att skapa nya anv\u00e4ndare med anpassad beh\u00f6righet f\u00f6r databasen. Detta \u00e4r on\u00f6digt i de flesta fall, men om du vill skapa en ny anv\u00e4ndare har du m\u00f6jlighet att g\u00f6ra detta snabbt.<\/p>\n<figure id=\"attachment_87179\" aria-describedby=\"caption-attachment-87179\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87179 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-User-Privileges-Database-Menu.png\" alt=\"Menyl\u00e4nken \"Privilegier\" i Adminer\" width=\"1100\" height=\"458\"><figcaption id=\"caption-attachment-87179\" class=\"wp-caption-text\">Menyl\u00e4nken &#8221;Privilegier&#8221; i Adminer<\/figcaption><\/figure>\n<figure id=\"attachment_87180\" aria-describedby=\"caption-attachment-87180\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87180 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Create-User-Privileges-Adminer.png\" alt=\"Skapa en databasanv\u00e4ndare i Adminer\" width=\"1100\" height=\"458\"><figcaption id=\"caption-attachment-87180\" class=\"wp-caption-text\">Skapa en databasanv\u00e4ndare i Adminer<\/figcaption><\/figure>\n<h3>Omfattande anpassningsalternativ<\/h3>\n<p>Du kan ut\u00f6ka eller skriva \u00f6ver Adminers standardfunktioner med din anpassade kod med hj\u00e4lp av standard <strong>Adminer-klassen<\/strong>. F\u00f6r att uppn\u00e5 detta m\u00e5ste du definiera en <strong>adminer_object-funktion<\/strong> som returnerar anpassade v\u00e4rden f\u00f6r klassen Adminer.<\/p>\n<p>Om du exempelvis vill anpassa namnet som visas i sid-huvudet och rubriken kan du g\u00f6ra detta med den h\u00e4r koden:<\/p>\n<pre><code class=\"language-php\">&lt;?php\nfunction adminer_object() {\u00a0 \n    class AdminerExtender extends Adminer {function name() {\n        \/\/ your custom name for title & heading\n        return 'Adminer for Kinsta';\n        }\n    }\n    return <span id=\"urn:enhancement-7a59daa8-5e28-4258-8724-22dc8ff7baac\" class=\"textannotation\">new<\/span> AdminerExtender;\n}\ninclude '.\/adminer-4.7.8.php';<\/code><\/pre>\n<p>Du kan nu se det anpassade namnet som vi st\u00e4ller in (&#8221;Adminer for Kinsta&#8221;) i sidhuvud-sektionen.<\/p>\n<figure id=\"attachment_87181\" aria-describedby=\"caption-attachment-87181\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87181 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Customizing-Header-Name-Kinsta-Adminer.png\" alt=\"Anpassa Adminers rubrik med dess till\u00e4ggs-API\" width=\"1100\" height=\"406\"><figcaption id=\"caption-attachment-87181\" class=\"wp-caption-text\">Anpassa Adminers rubrik med dess till\u00e4ggs-API<\/figcaption><\/figure>\n<p>Det finns m\u00e4ngder av h\u00e4ftiga saker som du kan g\u00f6ra med Adminers till\u00e4gg. Du kan <a href=\"https:\/\/www.adminer.org\/en\/extension\/\">l\u00e4sa mer om Adminers till\u00e4gg<\/a> p\u00e5 deras API-referenssida.<\/p>\n<h2>Adminer Plugins<\/h2>\n<p>Adminer-plugins \u00e4r till\u00e4gg som \u00e4r f\u00e4rdiga att anv\u00e4nda. Du kan nyttja dem f\u00f6r att enkelt ut\u00f6ka Adminers standardfunktionalitet.<\/p>\n<p>Om du exempelvis vill exportera databasen i XML-format kan du installera Adminer-pluginet <a href=\"https:\/\/raw.github.com\/vrana\/adminer\/master\/plugins\/dump-xml.php\">dump-xml<\/a>. Om du vill exportera din databas som en ZIP-komprimerad fil, kan du ansluta till\u00e4gget <a href=\"https:\/\/raw.github.com\/vrana\/adminer\/master\/plugins\/dump-zip.php\">dump-zip<\/a>.<\/p>\n<figure id=\"attachment_87182\" aria-describedby=\"caption-attachment-87182\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87182 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Plugins-Extend-Default-Functionality.png\" alt=\"Ut\u00f6ka Adminers standardutmatningsalternativ med plugins\" width=\"1100\" height=\"486\"><figcaption id=\"caption-attachment-87182\" class=\"wp-caption-text\">Ut\u00f6ka Adminers standardutmatningsalternativ med plugins<\/figcaption><\/figure>\n<p>Den officiella webbplatsen listar <a href=\"https:\/\/www.adminer.org\/en\/plugins\/\">n\u00e5gra av de mest popul\u00e4ra Adminer-pluginen<\/a>. D\u00e4r hittar du \u00e4ven information om hur du st\u00e4ller in och anv\u00e4nder Adminer-plugins.<\/p>\n<h2>Adminer teman<\/h2>\n<p>En av Adminers coolaste funktioner \u00e4r dess <a href=\"https:\/\/kinsta.com\/se\/bast-wordpress-teman\/\">tema-funktionalitet<\/a>. Den officiella webbplatsen listar n\u00e5gra f\u00e4rdiga m\u00f6nster som du kan anv\u00e4nda direkt.<\/p>\n<figure id=\"attachment_87183\" aria-describedby=\"caption-attachment-87183\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87183 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Themes-Extend-Adminer-Interface-Design.png\" alt=\"Anslut ett Adminer-tema f\u00f6r att \u00e4ndra dess utseende\" width=\"1100\" height=\"554\"><figcaption id=\"caption-attachment-87183\" class=\"wp-caption-text\">Anslut ett Adminer-tema f\u00f6r att \u00e4ndra dess utseende<\/figcaption><\/figure>\n<p>Om du vill anv\u00e4nda ett Adminer-tema m\u00e5ste du placera temats <strong>adminer.css-fil<\/strong> i samma katalog d\u00e4r<strong> adminer.php<\/strong> finns.<\/p>\n<p>S\u00e5 enkelt \u00e4r det.<\/p>\n<figure id=\"attachment_87184\" aria-describedby=\"caption-attachment-87184\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87184 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-Hydra-Material-Design-Theme.png\" alt=\"Omdesigna Adminer helt med dess teman\" width=\"1100\" height=\"522\"><figcaption id=\"caption-attachment-87184\" class=\"wp-caption-text\">Omdesigna Adminer helt med dess teman<\/figcaption><\/figure>\n<p>Ovanst\u00e5ende exempel \u00e4r <a href=\"https:\/\/raw.githubusercontent.com\/Niyko\/Hydra-Dark-Theme-for-Adminer\/master\/adminer.css\">Hydra-temat<\/a> som listas p\u00e5 Adminers webbplats. Det \u00e4r ett <a href=\"https:\/\/kinsta.com\/se\/blog\/anpassad-wordpress-panel\/#aquila-admintema\">Material Design-baserat<\/a> m\u00f6rkt tema f\u00f6r Adminer.<\/p>\n<figure id=\"attachment_87185\" aria-describedby=\"caption-attachment-87185\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87185 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Adminer-mvt-Design-Theme.png\" alt=\"Ett annat Adminer-tema (mvt) i aktion\" width=\"1100\" height=\"502\"><figcaption id=\"caption-attachment-87185\" class=\"wp-caption-text\">Ett annat Adminer-tema (mvt) i aktion<\/figcaption><\/figure>\n<p>N\u00e5gra andra bra exempel p\u00e5 Adminer-teman \u00e4r <a href=\"https:\/\/github.com\/natanfelles\/adminer-bootstrap-like\">Adminer Bootstrap-Like Design<\/a> och <a href=\"https:\/\/github.com\/pematon\/adminer-theme\">Adminer Theme av pematon<\/a>. Med n\u00e5got av ovanst\u00e5ende teman som mall kan du anpassa dem efter eget tycke genom att \u00e4ndra CSS-filen.<\/p>\n<h2>Adminer vs phpMyAdmin<\/h2>\n<p>Nu n\u00e4r vi har utforskat m\u00e5nga av Adminers funktioner \u00e4r det dags att titta p\u00e5 hur Adminer j\u00e4mf\u00f6rs med <a href=\"https:\/\/kinsta.com\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\">phpMyAdmin<\/a>, branschledaren. H\u00e4r \u00e4r en kort genomg\u00e5ng av hur de st\u00e5r sig mot varandra p\u00e5 olika fronter:<\/p>\n<h3>Adminer vs phpMyAdmin: J\u00e4mf\u00f6relse av funktioner<\/h3>\n<p>phpMyAdmin st\u00f6der endast MySQL-databaser, medan Adminer st\u00f6der m\u00e5nga andra typer av databaser. Adminer finns \u00e4ven som MySQL-exklusivt.<\/p>\n<p>Att redigera och skapa tabeller i phpMyAdmin \u00e4r kr\u00e5ngligt j\u00e4mf\u00f6rt med Adminer. Att v\u00e4lja data i massor och redigera allt p\u00e5 samma g\u00e5ng \u00e4r bekv\u00e4mt med Adminer. phpMyAdmin har brister p\u00e5 detta omr\u00e5de.<\/p>\n<p>Du kan \u00e4ven titta p\u00e5 <a href=\"https:\/\/www.adminer.org\/en\/editor\/\">Adminer Editor<\/a>, en variant av Adminer som fokuserar p\u00e5 att redigera en databas. Den fungerar bara med en databas i taget, och du m\u00e5ste ansluta den till en annan databas f\u00f6r att f\u00e5 den att fungera.<\/p>\n<p>Det finns dock n\u00e5gra omr\u00e5den d\u00e4r phpMyAdmin utm\u00e4rker sig. Det st\u00f6der exempelvis m\u00e5nga fler spr\u00e5k och exportformat \u00e4n Adminer. Dess stora anv\u00e4ndarbas s\u00e4kerst\u00e4ller att det finns ett blomstrande community som \u00e4r villigt att hj\u00e4lpa dig om du snubblar \u00f6ver n\u00e5got problem.<\/p>\n<h3>Adminer vs phpMyAdmin: S\u00e4kerhet<\/h3>\n<p>Enligt Adminers team \u00e4r <em>&#8221;S\u00e4kerhet prioritet nr 1 i utvecklingen av Adminer.&#8221;<\/em> Adminer blockerar exempelvis \u00e5tkomst till databaser utan att st\u00e4lla in ett l\u00f6senord i backend. Detta f\u00f6rsv\u00e5rar anslutningsf\u00f6rs\u00f6k och skyddar mot brute-force eller <a href=\"https:\/\/kinsta.com\/se\/blog\/sql-injektion\/\">SQL-injektionsattacker<\/a>.<\/p>\n<p>Adminers plug and play-design inneb\u00e4r \u00e4ven att du snabbt kan ta bort det fr\u00e5n din server n\u00e4r det inte beh\u00f6vs l\u00e4ngre. Om du vill anv\u00e4nda det igen i framtiden kan du ladda upp det snabbt igen. Du kan inte g\u00f6ra detta med phpMyAdmin.<\/p>\n<p>Genom att anv\u00e4nda Adminers plugin <a href=\"https:\/\/raw.github.com\/vrana\/adminer\/master\/plugins\/login-ssl.php\">login-ssl<\/a> kan du ansluta till mySQL-databasservern med SSL. Adminers instrumentpanel tipsar dig \u00e4ven om det finns en ny version tillg\u00e4nglig, s\u00e5 att du kan vara s\u00e4ker p\u00e5 att du alltid anv\u00e4nder den senaste versionen.<\/p>\n<h3>Adminer vs phpMyAdmin: Prestanda<\/h3>\n<p>Enligt ett <a href=\"http:\/\/php.vrana.cz\/dalsi-vyvoj-phpminadmin.php#d-8348\">oberoende test<\/a> av Juraj Hajd\u00fach \u00e4r Adminer i genomsnitt<strong> 28%<\/strong> snabbare \u00e4n phpMyAdmin. \u00c4ven om de publicerade dessa resultat redan \u00e5r 2009, n\u00e4r Adminer fortfarande var i sin linda, \u00e4r det det enda oberoende prestandatestet som finns tillg\u00e4ngligt (hittills).<\/p>\n<p>Eftersom Adminer endast best\u00e5r av en l\u00e4ttviktig fil kan du distribuera det p\u00e5 den mest resursbegr\u00e4nsade servern.<\/p>\n<h3>Adminer vs phpMyAdmin: Anv\u00e4ndarupplevelse<\/h3>\n<p>Att anv\u00e4nda Adminer \u00e4r en barnlek redan fr\u00e5n b\u00f6rjan, till skillnad fr\u00e5n phpMyAdmin. Du beh\u00f6ver inte kr\u00e5ngla med n\u00e5gon konfiguration eller n\u00e5gra inst\u00e4llningar. Det bara fungerar.<\/p>\n<p>Adminer har \u00e4ven ett b\u00e4ttre och v\u00e4nligare anv\u00e4ndargr\u00e4nssnitt. Att anpassa tabeller, kolumner och deras v\u00e4rden \u00e4r otroligt enkelt med Adminer. Det \u00e4r \u00e4ven enkelt att importera en databas eller <a href=\"https:\/\/kinsta.com\/blog\/mysql-backup-database\/\">ta s\u00e4kerhetskopior<\/a>.<\/p>\n<p>Adminers plugins och teman l\u00e5ter dig dessutom anpassa funktionerna och gr\u00e4nssnitten f\u00f6r att passa dina krav. Detta g\u00f6r Adminer till en tydlig vinnare ur ett anv\u00e4ndarupplevelseperspektiv.<\/p>\n<h3>Adminer vs phpMyAdmin: Filstorlek<\/h3>\n<p>Adminer \u00e4r ett kompakt databashanteringsverktyg. Det \u00e4r minst<strong> 28 g\u00e5nger<\/strong> mindre \u00e4n phpMyAdmin, \u00e4ven om det st\u00f6der fler databastyper \u00e4n phpMyAdmin.<\/p>\n<p>Den senaste fullst\u00e4ndiga versionen av Adminer (v4.7.8) ligger p\u00e5 ynka<strong> 478 KB<\/strong>, medan phpMyAdmins senaste version (v5.0.4) ligger p\u00e5 <strong>13.7 MB<\/strong> (plus att man startar med en komprimerad fil). Filstorleksskillnaden \u00e4r \u00e4nnu st\u00f6rre n\u00e4r du \u00f6verv\u00e4ger Adminers MySQL-version (<strong>354 kB<\/strong>).<\/p>\n<h2>Hur man anv\u00e4nder Adminer med WordPress<\/h2>\n<p>Det finns inget s\u00e4rskilt s\u00e4tt att anv\u00e4nda Adminer med WordPress. Det fungerar p\u00e5 samma s\u00e4tt som med alla MySQL-databaser. Ladda ner php-filen, placera den var som helst p\u00e5 din server och \u00f6ppna den fr\u00e5n din webbl\u00e4sare. N\u00e4r du har loggat in p\u00e5 Adminer kan du utforska din WordPress-webbplats databas.<\/p>\n<p>Jag rekommenderar att du tar bort Adminer-filen fr\u00e5n servern n\u00e4r du \u00e4r klar. Om du l\u00e4mnar den obevakad p\u00e5 servern under en l\u00e4ngre tid kan databasen uts\u00e4ttas f\u00f6r s\u00e5rbarheter.<\/p>\n<p>Det fanns ett WordPress-plugin som heter &#8221;ari-adminer&#8221;. Det gjorde att du kunde komma \u00e5t Adminer direkt fr\u00e5n din WordPress-instrumentpanel.\u00a0<strong>Den har dock varit st\u00e4ngd sedan april \u00e5r 2019 och \u00e4r inte l\u00e4ngre tillg\u00e4nglig f\u00f6r nedladdning<\/strong> p\u00e5 grund av ett kritiskt s\u00e4kerhetsproblem.<\/p>\n<p>Det n\u00e4st b\u00e4sta s\u00e4ttet att anv\u00e4nda Adminer med WordPress \u00e4r med <a href=\"https:\/\/kinsta.com\/se\/devkinsta\/\">DevKinsta<\/a>.<\/p>\n<h2>DevKinsta och Adminer: Enkel WordPress-databashantering<\/h2>\n<p><a href=\"https:\/\/kinsta.com\/se\/devkinsta\/\">DevKinsta<\/a>, Kinstas kostnadsfria svit av verktyg f\u00f6r lokal utveckling, anv\u00e4nder Adminer i bakgrunden f\u00f6r att driva sin databashanterare.<\/p>\n<figure id=\"attachment_87186\" aria-describedby=\"caption-attachment-87186\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87186 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Database-Manager-DevKinsta-Uses-Adminer.png\" alt=\"\u00c5tkomst till DevKinsta\u2019s databashanterare\" width=\"1100\" height=\"554\"><figcaption id=\"caption-attachment-87186\" class=\"wp-caption-text\">\u00c5tkomst till DevKinsta\u2019s databashanterare<\/figcaption><\/figure>\n<p>Klicka p\u00e5 knappen <strong>Databashanterare<\/strong> i DevKinsta-instrumentpanelen f\u00f6r att komma \u00e5t Adminer.<\/p>\n<figure id=\"attachment_87187\" aria-describedby=\"caption-attachment-87187\" style=\"width: 1100px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87187 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2021\/01\/Database-Manager-Dashboard-DevKinsta-Adminer.png\" alt=\"DevKinsta\u2019s databashanterare \u00e4r en snyggare Adminer\" width=\"1100\" height=\"530\"><figcaption id=\"caption-attachment-87187\" class=\"wp-caption-text\">DevKinsta\u2019s databashanterare \u00e4r en snyggare Adminer<\/figcaption><\/figure>\n<p>DevKinsta\u2019s databashanterare st\u00f6der alla Adminer-funktioner som vi har diskuterat tidigare i det h\u00e4r inl\u00e4gget. Du kan anv\u00e4nda den f\u00f6r att v\u00e4xla mellan olika databaser, visa och redigera tabeller, manipulera databasv\u00e4rden, importera och exportera databaser, k\u00f6ra SQL-s\u00f6kfr\u00e5gor och mycket mer.<\/p>\n<p>Om du <a href=\"https:\/\/kinsta.com\/se\/blog\/installerar-wordpress-lokalt\/\">konfigurerar flera webbplatser lokalt med DevKinsta<\/a> kan du v\u00e4xla mellan deras databaser fr\u00e5n Adminers instrumentpanel. V\u00e4lj bara den databas som du vill anv\u00e4nda fr\u00e5n rullgardinsmenyn i det \u00f6vre v\u00e4nstra h\u00f6rnet.<\/p>\n<p>Du kan <a href=\"https:\/\/kinsta.com\/se\/blog\/devkinsta\/databashanteraren\/\">bes\u00f6ka DevKinsta-dokumentationen<\/a> f\u00f6r mer information om databashanteraren.<\/p>\n\n<h2>Sammanfattning<\/h2>\n<p>Adminer \u00e4r ett av de b\u00e4sta alternativen till phpMyAdmin. Det \u00e4r inte bara mer l\u00e4ttviktigt, utan \u00e4r \u00e4ven mycket snabbare att arbeta med. Det befinner sig i en l\u00e5ngsam men \u00e4nd\u00e5 st\u00e4ndig utveckling.\u00a0<a href=\"https:\/\/github.com\/vrana\/adminer\/releases\/tag\/v4.7.8\">Adminers senaste version<\/a> lade till st\u00f6d f\u00f6r <a href=\"https:\/\/kinsta.com\/se\/changelog\/php-8\/\">PHP 8-milj\u00f6er<\/a>, vilket g\u00f6r det framtidss\u00e4kert.<\/p>\n<p>Om du vill experimentera med Adminer kan du skapa en <a href=\"https:\/\/kinsta.com\/se\/devkinsta\/\">lokal WordPress-webbplats med DevKinsta<\/a> n\u00e4stan omedelbart och b\u00f6rja utforska dess databas med Adminer.<\/p>\n<p>Nu \u00e4r det din tur: vad \u00e4r din erfarenhet av Adminer? Har du n\u00e5gra fr\u00e5gor om hur du hanterar databaser med Adminer eller DevKinsta? Om s\u00e5 \u00e4r fallet, dela dem i<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Att kunna hantera MySQL-databaser \u00e4r ett av de grundl\u00e4ggande kraven f\u00f6r att vara en professionell WordPress-utvecklare. Adminer f\u00f6renklar den uppgiften oerh\u00f6rt. Varje WordPress-webbplats kr\u00e4ver en databas &#8230;<\/p>\n","protected":false},"author":117,"featured_media":43731,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[365,556],"topic":[754,768,791],"class_list":["post-43730","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-database-management-tool","tag-devkinsta","topic-adminer","topic-devkinsta","topic-lar-dig-php"],"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>Anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil<\/title>\n<meta name=\"description\" content=\"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.\" \/>\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\/se\/blog\/adminer\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hur man anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil\" \/>\n<meta property=\"og:description\" content=\"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/se\/blog\/adminer\/\" \/>\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-05-18T07:36:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-21T09:13:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-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=\"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-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=\"22 minuter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/\"},\"author\":{\"name\":\"Salman Ravoof\",\"@id\":\"https:\/\/kinsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\"},\"headline\":\"Hur man anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil\",\"datePublished\":\"2022-05-18T07:36:45+00:00\",\"dateModified\":\"2023-09-21T09:13:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/\"},\"wordCount\":3856,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/se\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png\",\"keywords\":[\"database management tool\",\"DevKinsta\"],\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kinsta.com\/se\/blog\/adminer\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/\",\"url\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/\",\"name\":\"Anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/se\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png\",\"datePublished\":\"2022-05-18T07:36:45+00:00\",\"dateModified\":\"2023-09-21T09:13:24+00:00\",\"description\":\"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/se\/blog\/adminer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png\",\"contentUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png\",\"width\":1460,\"height\":730},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/adminer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/se\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adminer\",\"item\":\"https:\/\/kinsta.com\/se\/topics\/adminer\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Hur man anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/se\/#website\",\"url\":\"https:\/\/kinsta.com\/se\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/se\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/se\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sv-SE\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/se\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/se\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinsta.com\/se\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.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:\/\/kinsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\",\"name\":\"Salman Ravoof\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinsta.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:\/\/kinsta.com\/se\/blog\/author\/salmanravoof\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil","description":"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.","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\/se\/blog\/adminer\/","og_locale":"sv_SE","og_type":"article","og_title":"Hur man anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil","og_description":"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.","og_url":"https:\/\/kinsta.com\/se\/blog\/adminer\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/kinstasweden\/","article_published_time":"2022-05-18T07:36:45+00:00","article_modified_time":"2023-09-21T09:13:24+00:00","og_image":[{"width":1460,"height":730,"url":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png","type":"image\/png"}],"author":"Salman Ravoof","twitter_card":"summary_large_image","twitter_description":"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.","twitter_image":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png","twitter_creator":"@salmanravoof","twitter_site":"@kinsta_se","twitter_misc":{"Skriven av":"Salman Ravoof","Ber\u00e4knad l\u00e4stid":"22 minuter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/"},"author":{"name":"Salman Ravoof","@id":"https:\/\/kinsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987"},"headline":"Hur man anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil","datePublished":"2022-05-18T07:36:45+00:00","dateModified":"2023-09-21T09:13:24+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/"},"wordCount":3856,"commentCount":0,"publisher":{"@id":"https:\/\/kinsta.com\/se\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png","keywords":["database management tool","DevKinsta"],"inLanguage":"sv-SE","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kinsta.com\/se\/blog\/adminer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/","url":"https:\/\/kinsta.com\/se\/blog\/adminer\/","name":"Anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil","isPartOf":{"@id":"https:\/\/kinsta.com\/se\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png","datePublished":"2022-05-18T07:36:45+00:00","dateModified":"2023-09-21T09:13:24+00:00","description":"L\u00e4r dig hur du anv\u00e4nder Adminer f\u00f6r att f\u00f6renkla databashantering. Det \u00e4r l\u00e4tt, snabbt och enkelt. DevKinsta anv\u00e4nder Adminer f\u00f6r sin databashanterare.","breadcrumb":{"@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/se\/blog\/adminer\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/#primaryimage","url":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png","contentUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2022\/05\/adminer-1.png","width":1460,"height":730},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/se\/blog\/adminer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/se\/"},{"@type":"ListItem","position":2,"name":"Adminer","item":"https:\/\/kinsta.com\/se\/topics\/adminer\/"},{"@type":"ListItem","position":3,"name":"Hur man anv\u00e4nder Adminer f\u00f6r att enkelt hantera databaser med en enda PHP-fil"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/se\/#website","url":"https:\/\/kinsta.com\/se\/","name":"Kinsta\u00ae","description":"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar","publisher":{"@id":"https:\/\/kinsta.com\/se\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/se\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sv-SE"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/se\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/se\/","logo":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinsta.com\/se\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.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:\/\/kinsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987","name":"Salman Ravoof","image":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinsta.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:\/\/kinsta.com\/se\/blog\/author\/salmanravoof\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts\/43730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/users\/117"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/comments?post=43730"}],"version-history":[{"count":12,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts\/43730\/revisions"}],"predecessor-version":[{"id":54177,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts\/43730\/revisions\/54177"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/pt"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/es"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/fr"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/nl"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/dk"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/de"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/jp"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/translations\/se"},{"href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/43730\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/media\/43731"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/media?parent=43730"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/tags?post=43730"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/topic?post=43730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}