{"id":1374,"date":"2021-06-24T10:56:26","date_gmt":"2021-06-24T08:56:26","guid":{"rendered":"https:\/\/dev.sourcecode.sk\/wsczkb\/?post_type=ht_kb&#038;p=1374"},"modified":"2024-08-15T10:54:50","modified_gmt":"2024-08-15T08:54:50","slug":"pripojeni-databaze-na-webovou-aplikaci","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/","title":{"rendered":"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci"},"content":{"rendered":"\n<p>P\u0159i p\u0159ipojovan\u00ed datab\u00e1ze na Va\u0161i webovou aplikaci je mo\u017en\u00e9 pou\u017e\u00edt v\u00edcero mo\u017enost\u00ed, v z\u00e1vislosti od konkr\u00e9tn\u00ed verzi datab\u00e1ze, kterou pou\u017e\u00edv\u00e1te. Pro spr\u00e1vn\u00e9 p\u0159ipojen\u00ed je pot\u0159eba pou\u017e\u00edt 4 z\u00e1kladn\u00ed parametry:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>n\u00e1zev datab\u00e1ze&nbsp;<\/li>\n\n\n\n<li>jm\u00e9no u\u017eivatele datab\u00e1ze<\/li>\n\n\n\n<li>heslo k datab\u00e1zi<\/li>\n\n\n\n<li>n\u00e1zev serveru (hostitele) datab\u00e1ze<\/li>\n<\/ul>\n\n\n\n<p>O tom, jak si m\u016f\u017eete p\u0159ipojit datab\u00e1zi na redak\u010dn\u00ed syst\u00e9my se m\u016f\u017eete do\u010d\u00edst i v na\u0161em&nbsp;<a href=\"https:\/\/www.websupport.cz\/podpora\/kb\/uprava-konfiguracniho-souboru-ve-wordpressu\/\">n\u00e1vodu<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Nastaven\u00ed hesla, n\u00e1zvu a u\u017eivatele datab\u00e1ze<\/strong><\/h4>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>V r\u00e1mci konfigura\u010dn\u00edho souboru, kde si nastavujete p\u0159ipojen\u00ed datab\u00e1ze pro v\u00e1\u0161 web je pot\u0159eba zadat n\u00e1zev, u\u017eivatele a heslo k datab\u00e1zi. Tyto \u00fadaje si generujete vy sami, p\u0159i vytv\u00e1\u0159en\u00ed dan\u00e9 datab\u00e1ze. Kdy\u017e u\u017e m\u00e1te datab\u00e1zi ve Webadminu vytvo\u0159enou, sta\u010d\u00ed jen j\u00edt do sekce&nbsp;<strong>Datab\u00e1ze<\/strong>&nbsp;a po kliknut\u00ed na konkr\u00e9tn\u00ed datab\u00e1zi je najdete v poli <strong>P\u0159ihla\u0161ovac\u00ed \u00fadaje<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"528\" src=\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-800x528.png\" alt=\"\" class=\"wp-image-8785\" srcset=\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-800x528.png 800w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-400x264.png 400w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-768x507.png 768w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-50x33.png 50w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-60x40.png 60w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-100x66.png 100w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje.png 1322w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Nastaven\u00ed hostitele pro datab\u00e1zi<\/strong><\/h4>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>Pro nastaven\u00ed hostit\u011ble, tedy serveru, pro datab\u00e1zi, je pot\u0159eba si ov\u011b\u0159it, o jak\u00fd typ datab\u00e1ze jde. K dispozici jsou tyto typy datab\u00e1z\u00ed:&nbsp;<strong>MySQL&nbsp;5.7 a 8.0, Maria DB 10.1 a 10.3,&nbsp;&nbsp;PostgreSQL 9.0 a 10.0.<\/strong>&nbsp;\u00dadaj o tom, jak\u00fd typ datab\u00e1ze vyu\u017e\u00edvate, zjist\u00edte jednodu\u0161e &#8211; v seznamu datab\u00e1z\u00ed jsou dostupn\u00e9 informace o tom, jak\u00fd typ datab\u00e1ze m\u00e1te vytvo\u0159en\u00fd:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"413\" src=\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-800x413.png\" alt=\"\" class=\"wp-image-8782\" srcset=\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-800x413.png 800w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-400x207.png 400w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-768x397.png 768w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-50x26.png 50w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-1536x793.png 1536w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-60x31.png 60w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze-100x52.png 100w, https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/Database-verze.png 1801w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p>Standardn\u011b v\u00e1m v\u017edy bude fungovat n\u00e1sledovn\u00e9 napojen\u00ed datab\u00e1zov\u00e9ho serveru pomoc\u00ed extern\u00edho p\u0159\u00edstupu:<br><br><\/p>\n\n\n\n<p><strong>pro MySQL&nbsp;5.7 server:&nbsp;mysql57.websupport.sk:3311<\/strong><\/p>\n\n\n\n<p><strong>pro MariaDB 10.1 server: mariadb101.websupport.sk:3312<\/strong><\/p>\n\n\n\n<p><strong>pro PostgreSQL 9.0 a 10.0 server: postgresql.websupport.sk:5432<\/strong><\/p>\n\n\n\n<p><strong>pro MySQL 8.0 server:&nbsp;mysql80.websupport.sk:3314&nbsp;<\/strong><\/p>\n\n\n\n<p><strong>pro MariaDB 10.3 server:&nbsp;mariadb103.websupport.sk:3313<\/strong><br><br><\/p>\n\n\n\n<p>Stejn\u011b m\u016f\u017eete pou\u017e\u00edt i n\u00e1sledovn\u00e9 hodnoty pro lok\u00e1ln\u00ed p\u0159ipojen\u00ed:<br><br><\/p>\n\n\n\n<p><strong>pro MySQL 5.7 server: localhost:\/tmp\/mysql57.sock<\/strong><\/p>\n\n\n\n<p><strong>pro MariaDB 10.1 server: localhost:\/tmp\/mariadb101.sock<\/strong><\/p>\n\n\n\n<p><strong>pro MySQL 8.0 server:&nbsp;localhost:\/tmp\/mysql80.sock<\/strong><\/p>\n\n\n\n<p><strong>pro MariaDB 10.3 server:&nbsp;localhost:\/tmp\/mariadb103.sock<\/strong><br><br><\/p>\n\n\n\n<p>Rozd\u00edl mezi prvn\u00edm a druh\u00fdm nastaven\u00edm je v tom, \u017ee extern\u00ed p\u0159\u00edstup (prvn\u00ed mo\u017enost) se p\u0159ipojuje p\u0159\u00edmo na datab\u00e1zov\u00fd server, proto doporu\u010dujeme pou\u017e\u00edt p\u0159\u00edmo toto p\u0159ipojen\u00ed.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>P\u0159i p\u0159ipojovan\u00ed datab\u00e1ze na Va\u0161i webovou aplikaci je mo\u017en\u00e9 pou\u017e\u00edt v\u00edcero mo\u017enost\u00ed, v z\u00e1vislosti od konkr\u00e9tn\u00ed verzi datab\u00e1ze, kterou pou\u017e\u00edv\u00e1te. Pro spr\u00e1vn\u00e9 p\u0159ipojen\u00ed je pot\u0159eba pou\u017e\u00edt 4 z\u00e1kladn\u00ed parametry: O tom, jak si m\u016f\u017eete p\u0159ipojit datab\u00e1zi na redak\u010dn\u00ed syst\u00e9my se m\u016f\u017eete do\u010d\u00edst i v na\u0161em&nbsp;n\u00e1vodu. Nastaven\u00ed hesla, n\u00e1zvu a u\u017eivatele&#8230;<\/p>\n","protected":false},"author":3,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-1374","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci - Websupport Centrum n\u00e1pov\u011bdy<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"P\u0159i p\u0159ipojovan\u00ed datab\u00e1ze na Va\u0161i webovou aplikaci je mo\u017en\u00e9 pou\u017e\u00edt v\u00edcero mo\u017enost\u00ed, v z\u00e1vislosti od konkr\u00e9tn\u00ed verzi datab\u00e1ze, kterou pou\u017e\u00edv\u00e1te. Pro spr\u00e1vn\u00e9 p\u0159ipojen\u00ed je pot\u0159eba pou\u017e\u00edt 4 z\u00e1kladn\u00ed parametry: O tom, jak si m\u016f\u017eete p\u0159ipojit datab\u00e1zi na redak\u010dn\u00ed syst\u00e9my se m\u016f\u017eete do\u010d\u00edst i v na\u0161em&nbsp;n\u00e1vodu. Nastaven\u00ed hesla, n\u00e1zvu a u\u017eivatele...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-15T08:54:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-800x528.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/\",\"name\":\"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/app\\\/uploads\\\/2022\\\/06\\\/database-udaje-800x528.png\",\"datePublished\":\"2021-06-24T08:56:26+00:00\",\"dateModified\":\"2024-08-15T08:54:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/app\\\/uploads\\\/2022\\\/06\\\/database-udaje.png\",\"contentUrl\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/app\\\/uploads\\\/2022\\\/06\\\/database-udaje.png\",\"width\":1322,\"height\":873},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/pripojeni-databaze-na-webovou-aplikaci\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\",\"name\":\"Websupport Centrum n\u00e1pov\u011bdy\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci - Websupport Centrum n\u00e1pov\u011bdy","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:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/","og_locale":"cs_CZ","og_type":"article","og_title":"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci - Websupport Centrum n\u00e1pov\u011bdy","og_description":"P\u0159i p\u0159ipojovan\u00ed datab\u00e1ze na Va\u0161i webovou aplikaci je mo\u017en\u00e9 pou\u017e\u00edt v\u00edcero mo\u017enost\u00ed, v z\u00e1vislosti od konkr\u00e9tn\u00ed verzi datab\u00e1ze, kterou pou\u017e\u00edv\u00e1te. Pro spr\u00e1vn\u00e9 p\u0159ipojen\u00ed je pot\u0159eba pou\u017e\u00edt 4 z\u00e1kladn\u00ed parametry: O tom, jak si m\u016f\u017eete p\u0159ipojit datab\u00e1zi na redak\u010dn\u00ed syst\u00e9my se m\u016f\u017eete do\u010d\u00edst i v na\u0161em&nbsp;n\u00e1vodu. Nastaven\u00ed hesla, n\u00e1zvu a u\u017eivatele...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2024-08-15T08:54:50+00:00","og_image":[{"url":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-800x528.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/","name":"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje-800x528.png","datePublished":"2021-06-24T08:56:26+00:00","dateModified":"2024-08-15T08:54:50+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/#primaryimage","url":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje.png","contentUrl":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/06\/database-udaje.png","width":1322,"height":873},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pripojeni-databaze-na-webovou-aplikaci\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"P\u0159ipojen\u00ed datab\u00e1ze na webovou aplikaci"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.cz\/podpora\/#website","url":"https:\/\/www.websupport.cz\/podpora\/","name":"Websupport Centrum n\u00e1pov\u011bdy","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.cz\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/1374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":3,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/1374\/revisions"}],"predecessor-version":[{"id":12537,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/1374\/revisions\/12537"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=1374"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=1374"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=1374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}