{"id":491,"date":"2017-02-06T16:13:31","date_gmt":"2017-02-06T15:13:31","guid":{"rendered":"http:\/\/oderland.se\/support\/?post_type=ht_kb&#038;p=491"},"modified":"2026-02-13T09:44:50","modified_gmt":"2026-02-13T08:44:50","slug":"hur-skapar-jag-databaser-i-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/www.oderland.se\/support\/artikel\/hur-skapar-jag-databaser-i-cpanel\/","title":{"rendered":"Hur skapar jag databaser i cPanel?"},"content":{"rendered":"\n<p>F\u00f6r att l\u00e4gga till databaser, b\u00f6rja med att logga in p\u00e5 cPanel, om du inte vet hur du g\u00f6r finns det en guide om hur du g\u00f6r <a title=\"S\u00e5 loggar du in p\u00e5 cPanel\" rel=\"noopener noreferrer\" href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-loggar-jag-in-pa-cpanel\/\" target=\"_blank\">h\u00e4r<\/a>. N\u00e4r du v\u00e4l \u00e4r inne kan du skapa en databas med tillh\u00f6rande anv\u00e4ndare p\u00e5 tv\u00e5 s\u00e4tt: igenom en enklare guidad process via ikonen <code>MySQL-databasguide<\/code> eller manuellt via ikonen <code>Databaser<\/code>.<\/p>\n\n\n\n<p>Den manuella metoden kan vara bra om du t.ex. redan har en databas som du vill skapa en till anv\u00e4ndare till men i de flesta fall vill man skapa en ny databas med en ny anv\u00e4ndare vilket den guidade metoden l\u00f6ser.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\"><strong>Databasanv\u00e4ndning externt<\/strong><br><br>Om du ska anv\u00e4nda databasen p\u00e5 en annan server \u00e4n den du skapat den p\u00e5 kan du beh\u00f6va till\u00e5ta extern \u00e5tkomst till databasen. Se <a rel=\"noreferrer noopener\" href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-mojliggor-jag-for-fjarratkomst-till-mina-databaser\/\" target=\"_blank\">denna guide<\/a> f\u00f6r instruktioner om hur du g\u00f6r detta.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Via Databasguiden<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Klicka p\u00e5 ikonen <code>Databasguiden<\/code> i <a href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-loggar-jag-in-pa-cpanel\/\" target=\"_blank\" rel=\"noopener noreferrer\">cPanel<\/a>.<br><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_databasguiden.png\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"192\" class=\"wp-image-24913\" style=\"width: 739px;\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_databasguiden.png\" alt=\"\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_databasguiden.png 739w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_databasguiden-300x78.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_databasguiden-50x13.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_databasguiden-60x16.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_databasguiden-100x26.png 100w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/a><\/li>\n\n\n\n<li>V\u00e4lj slutet av databasnamnet, b\u00f6rjan \u00e4r alltid baserad p\u00e5 ditt cPanel-anv\u00e4ndarnamn (i det h\u00e4r fallet <code>exempel_<\/code>).<br><figure><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4677 size-full\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-2.png\" alt=\"\" width=\"743\" height=\"201\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-2.png 743w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-2-300x81.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-2-50x14.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-2-60x16.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-2-100x27.png 100w\" sizes=\"auto, (max-width: 743px) 100vw, 743px\" \/><\/a><\/figure><\/li>\n\n\n\n<li>V\u00e4lj namn och l\u00f6senord f\u00f6r databasanv\u00e4ndaren.<figure><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4678 size-full\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3.png\" alt=\"\" width=\"916\" height=\"501\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3.png 916w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3-300x164.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3-768x420.png 768w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3-50x27.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3-60x33.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-3-100x55.png 100w\" sizes=\"auto, (max-width: 916px) 100vw, 916px\" \/><\/a><\/figure><\/li>\n\n\n\n<li>L\u00e4gg till anv\u00e4ndaren till databasen (Oftast vill du ge anv\u00e4ndaren &#8221;Alla&#8221; beh\u00f6righeter igenom att bocka i rutan h\u00f6gst upp.)<br><figure><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4701 size-full\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4.png\" alt=\"\" width=\"1112\" height=\"796\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4.png 1112w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4-300x215.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4-768x550.png 768w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4-1024x733.png 1024w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4-50x36.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4-60x43.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-4-100x72.png 100w\" sizes=\"auto, (max-width: 1112px) 100vw, 1112px\" \/><\/a><\/figure><\/li>\n\n\n\n<li>D\u00e5 \u00e4r du klar och kan anv\u00e4nda databasen med uppgifterna du nyss skrev in.<br><figure><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4689 size-full\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-5.png\" alt=\"\" width=\"583\" height=\"334\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-5.png 583w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-5-300x172.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-5-50x29.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-5-60x34.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysqlguide-5-100x57.png 100w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/a><\/figure><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Manuellt<\/h2>\n\n\n\n<p>Inne i cPanel klickar du sedan p\u00e5 ikonen <code>Databaser<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_hantera_databaser.png\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"192\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_hantera_databaser.png\" alt=\"\" class=\"wp-image-24916\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_hantera_databaser.png 739w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_hantera_databaser-300x78.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_hantera_databaser-50x13.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_hantera_databaser-60x16.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/cpanel_ikon_hantera_databaser-100x26.png 100w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Skapa en databas<\/h3>\n\n\n\n<p>Det f\u00f6rsta du beh\u00f6ver g\u00f6ra h\u00e4r \u00e4r att skapa en ny databas om du inte redan har gjort det, det g\u00f6r du under rubriken <code>Skapa ny databas<\/code>. Skriv in ett namn p\u00e5 din databas och klicka sedan <code>Skapa databas<\/code>. Det fulla namnet p\u00e5 din databas kommer bli <strong>cpanelanv\u00e4ndarnamn_databasnamn<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"191\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide2.png\" alt=\"\" class=\"wp-image-487\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide2.png 420w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide2-300x136.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide2-50x23.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide2-60x27.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide2-35x16.png 35w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">L\u00e4gg till en anv\u00e4ndare<\/h3>\n\n\n\n<p>Nu beh\u00f6ver du en anv\u00e4ndare om du inte redan har det, har du en redan kan du hoppa \u00f6ver detta steg. Under rubriken <code>L\u00e4gg till ny anv\u00e4ndare<\/code> hittar du ett formul\u00e4r f\u00f6r anv\u00e4ndarnamn och l\u00f6senord. T\u00e4nk p\u00e5 att l\u00f6senordsm\u00e4taren m\u00e5ste vara \u00f6ver 50 f\u00f6r att l\u00f6senordet ska accepteras. Fyll i alla f\u00e4lt och klicka sedan p\u00e5 ikonen <code>Skapa Anv\u00e4ndare<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide3-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"398\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide3-1.png\" alt=\"\" class=\"wp-image-24918\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide3-1.png 573w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide3-1-300x208.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide3-1-50x35.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide3-1-60x42.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide3-1-100x69.png 100w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Koppla en anv\u00e4ndare till en databas<\/h3>\n\n\n\n<p>Sist beh\u00f6ver du koppla anv\u00e4ndaren till databasen du skapat, under <code>L\u00e4gg till anv\u00e4ndare i databas<\/code> s\u00e5 v\u00e4ljer du anv\u00e4ndaren och databasen som skall kopplas samman. Klicka p\u00e5 <code>L\u00e4gg till<\/code> n\u00e4r du har gjort dina val.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"242\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide4.png\" alt=\"\" class=\"wp-image-489\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide4.png 448w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide4-300x162.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide4-50x27.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide4-60x32.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide4-35x19.png 35w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><\/figure>\n\n\n\n<p>Nu f\u00e5r du upp ett formul\u00e4r d\u00e4r du v\u00e4ljer de r\u00e4ttigheter som anv\u00e4ndaren skall f\u00e5. Det vanligaste \u00e4r att man ger anv\u00e4ndaren alla r\u00e4ttigheter, CMS-system s\u00e5 som Joomla och WordPress kommer kr\u00e4va alla r\u00e4ttigheter f\u00f6r att fungera. Du kan l\u00e4sa mer om MariaDB-r\u00e4ttigheter <a href=\"https:\/\/mariadb.com\/docs\/server\/security\/user-account-management\/roles\" target=\"_blank\" rel=\"noreferrer noopener\">h\u00e4r<\/a>. Avsluta genom att klicka p\u00e5 <code>G\u00f6r \u00e4ndringar<\/code>, nu \u00e4r din databas och databasanv\u00e4ndare redo att anv\u00e4ndas.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"635\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5.png\" alt=\"\" class=\"wp-image-490\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5.png 783w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5-300x243.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5-768x623.png 768w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5-50x41.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5-60x49.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2017\/02\/mysql-guide5-35x28.png 35w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>F\u00f6r att l\u00e4gga till databaser, b\u00f6rja med att logga in p\u00e5 cPanel, om du inte vet hur du g\u00f6r finns det en guide om hur du g\u00f6r h\u00e4r. N\u00e4r du v\u00e4l \u00e4r inne kan du skapa en databas med tillh\u00f6rande anv\u00e4ndare p\u00e5 tv\u00e5 s\u00e4tt: igenom en enklare guidad process via&#8230;<\/p>\n","protected":false},"author":12,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"ht-kb-category":[4],"ht-kb-tag":[],"class_list":["post-491","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databaser"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/comments?post=491"}],"version-history":[{"count":32,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/491\/revisions"}],"predecessor-version":[{"id":24921,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/491\/revisions\/24921"}],"wp:attachment":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/media?parent=491"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb-category?post=491"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}