{"id":1019,"date":"2021-05-05T11:04:44","date_gmt":"2021-05-05T11:04:44","guid":{"rendered":"https:\/\/dev.sourcecode.sk\/wsczkb\/?post_type=ht_kb&#038;p=1019"},"modified":"2022-03-03T16:06:52","modified_gmt":"2022-03-03T15:06:52","slug":"externi-pristup-k-databazi-na-virtualnim-serveru","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/","title":{"rendered":"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>EXTERN\u00dd P\u0158\u00cdSTUP NA DATAB\u00c1ZI NA VIRTU\u00c1LN\u00cdM SERVERU (VPS)<\/strong><\/h2>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>V &#8222;tov\u00e1rn\u00edm&#8220; nastaven\u00ed je vzd\u00e1len\u00fd p\u0159\u00edstup k MySQL serveru z bezpe\u010dnostn\u00edch d\u016fvod\u016f zak\u00e1zan\u00fd. N\u011bkdy ale&nbsp;budete pot\u0159ebovat poskytnout vzd\u00e1len\u00fd p\u0159\u00edstup k datab\u00e1zov\u00e9mu serveru&nbsp;pro kolegy, p\u0159\u00edpadn\u011b budete cht\u00edt vyu\u017e\u00edvat datab\u00e1zi ze str\u00e1nky, kter\u00e1 nen\u00ed na dan\u00e9m serveru. Tento n\u00e1vod bude vysv\u011btlovat, jak na va\u0161em VPS nastavit vzd\u00e1len\u00fd p\u0159\u00edstup k MySQL serveru.<\/p>\n\n\n\n<p>Pro jeho pou\u017eit\u00ed je pot\u0159eba se p\u0159ihl\u00e1sit na server pomoc\u00ed SSH.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>UPRAVTE KONFIGURA\u010cN\u00cd SOUBOR MYSQL&nbsp;<\/strong><\/h3>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>V souboru \/etc\/mysql\/my.cnf je v\u00edcero konfigura\u010dn\u00edch direktiv pro parametry, se kter\u00fdmi MySQL datab\u00e1zov\u00fd server startuje. Jejich zm\u011bny tedy nen\u00ed mo\u017en\u00e9 uplatnit b\u011bhem b\u011bhu MySQL.<\/p>\n\n\n\n<p>Adresu na kter\u00e9 m\u00e1 MySQL p\u0159ij\u00edmat spojen\u00ed ur\u010duje parametr bind-address . Po instalaci je nastaven\u00e9 tak, aby p\u0159ij\u00edmal spojen\u00ed na 127.0.0.1 , tj. pouze z vnit\u0159ku VPS .&nbsp;Pot\u0159ebujeme ho zm\u011bnit na ve\u0159ejnou IP adresu serveru.<\/p>\n\n\n\n<p>Soubor je mo\u017en\u00e9 upravit r\u016fzn\u00fdmi editory dostupn\u00fdmi na VPS&nbsp;<\/p>\n\n\n\n<p>Proto\u017ee je \u00faprava pom\u011brn\u011b jednoduch\u00e1, posta\u010d\u00ed n\u00e1m jednoduch\u00fd textov\u00fd editor&nbsp;nano&nbsp;, spust\u00edme ho pro \u00fapravu souboru p\u0159es:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>root@server:~# nano \/etc\/mysql\/my.cnf<\/p><\/blockquote>\n\n\n\n<p>P\u0159i hled\u00e1n\u00ed direktivy bind-address n\u00e1m pom\u016f\u017ee zkratka CTRL+W<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/Screenshot-from-2015-01-28-14_58_24-783x111.png\" alt=\"\" class=\"wp-image-2157\"\/><\/figure>\n\n\n\n<p>Hodnotu bind-address p\u0159ep\u00ed\u0161eme na IP adresu serveru. \u00a0Pokud ji nezn\u00e1te, IP adresu m\u016f\u017eete naj\u00edt ve v\u00fdstupu p\u0159\u00edkazu ifconfig pod n\u00e1zvem \u00a0<em>inet addr:.\u00a0<\/em>T\u00edmto nastav\u00edte, \u017ee mysql bude poslouchat jen na dan\u00e9 ve\u0159ejn\u00e9 IP adrese. Pokud chcete, aby mysql poslouchal na localhost (127.0.0.1) adrese, m\u016f\u017eete uv\u00e9st IP adresu jako 0.0.0.0<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>RESTARTUJTE MYSQL SERVER<\/strong><\/h3>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>Aby se zm\u011bny projevily, je pot\u0159eba restartovat MySQL server. Znamen\u00e1 to v\u0161ak kr\u00e1tkodobou nedostupnost spojen\u00ed s datab\u00e1z\u00ed (do 5minut), &nbsp;proto je vhodn\u00e9 si restart napl\u00e1novat na vhodn\u00fd \u010das .<\/p>\n\n\n\n<p>MySQL daemon na serveru restartujeme pomoc\u00ed&nbsp;service mysql restart<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/Screenshot-from-2015-01-28-15_09_42.png\" alt=\"\" class=\"wp-image-2158\"\/><\/figure>\n\n\n\n<p>T\u00edmto je extern\u00ed p\u0159\u00edstup k serveru povolen\u00fd, z\u016fst\u00e1v\u00e1 tedy povolit p\u0159\u00edstup pro jednotliv\u00e9 datab\u00e1ze a jejich u\u017eivatel\u016f.<\/p>\n\n\n\n<p>\u00daprava opr\u00e1vn\u011bn\u00ed datab\u00e1z\u00ed a u\u017eivatel\u016f pro extern\u00ed spojen\u00ed. &nbsp;<\/p>\n\n\n\n<p>Po p\u0159ihl\u00e1\u0161en\u00ed k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek vybereme datab\u00e1zi s n\u00e1zvem mysql a uprav\u00edme v n\u00ed z\u00e1znamy pro u\u017eivatele a datab\u00e1zi<\/p>\n\n\n\n<p>Nastaven\u00ed p\u0159\u00edstup\u016f jednotliv\u00e9 datab\u00e1ze jsou v tabulce mysql.db , pro u\u017eivatele jsou v tabulce mysql.user. Pot\u0159ebujeme zm\u011bnit obsah sloupce Host tak, aby se sm\u011bli p\u0159ihl\u00e1sit z libovoln\u00e9 adresy.<\/p>\n\n\n\n<p>Pro \u00fapravu je pot\u0159eba se p\u0159ihl\u00e1sit k datab\u00e1zi z p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku, nap\u0159\u00edklad podle na\u0161eho&nbsp;<a href=\"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/\">n\u00e1vodu<\/a><\/p>\n\n\n\n<p>Zm\u011bny realizujeme pomoc\u00ed p\u0159\u00edkaz\u016f:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>use mysql<\/p><p>UPDATE db SET Host=\u2019%\u2019 WHERE Db=\u2019NAZOV_DATABAZY\u2019 ;<\/p><p>UPDATE user set Host =\u2019%\u2019 WHERE User=\u2019USERNAME\u2019<\/p><p>FLUSH PRIVILEGES;<\/p><\/blockquote>\n\n\n\n<p>Po dokon\u010den\u00ed t\u011bchto p\u0159\u00edkaz\u016f je extern\u00ed p\u0159\u00edstup k datab\u00e1z\u00edm na VPS povolen\u00fd.&nbsp;<\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>EXTERN\u00dd P\u0158\u00cdSTUP NA DATAB\u00c1ZI NA VIRTU\u00c1LN\u00cdM SERVERU (VPS) V &#8222;tov\u00e1rn\u00edm&#8220; nastaven\u00ed je vzd\u00e1len\u00fd p\u0159\u00edstup k MySQL serveru z bezpe\u010dnostn\u00edch d\u016fvod\u016f zak\u00e1zan\u00fd. N\u011bkdy ale&nbsp;budete pot\u0159ebovat poskytnout vzd\u00e1len\u00fd p\u0159\u00edstup k datab\u00e1zov\u00e9mu serveru&nbsp;pro kolegy, p\u0159\u00edpadn\u011b budete cht\u00edt vyu\u017e\u00edvat datab\u00e1zi ze str\u00e1nky, kter\u00e1 nen\u00ed na dan\u00e9m serveru. Tento n\u00e1vod bude vysv\u011btlovat, jak na va\u0161em&#8230;<\/p>\n","protected":false},"author":3,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[48],"ht-kb-tag":[],"class_list":["post-1019","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-vps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru - 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\/externi-pristup-k-databazi-na-virtualnim-serveru\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"EXTERN\u00dd P\u0158\u00cdSTUP NA DATAB\u00c1ZI NA VIRTU\u00c1LN\u00cdM SERVERU (VPS) V &#8222;tov\u00e1rn\u00edm&#8220; nastaven\u00ed je vzd\u00e1len\u00fd p\u0159\u00edstup k MySQL serveru z bezpe\u010dnostn\u00edch d\u016fvod\u016f zak\u00e1zan\u00fd. N\u011bkdy ale&nbsp;budete pot\u0159ebovat poskytnout vzd\u00e1len\u00fd p\u0159\u00edstup k datab\u00e1zov\u00e9mu serveru&nbsp;pro kolegy, p\u0159\u00edpadn\u011b budete cht\u00edt vyu\u017e\u00edvat datab\u00e1zi ze str\u00e1nky, kter\u00e1 nen\u00ed na dan\u00e9m serveru. Tento n\u00e1vod bude vysv\u011btlovat, jak na va\u0161em...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-03T15:06:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/Screenshot-from-2015-01-28-14_58_24-783x111.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=\"3 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\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/\",\"name\":\"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.sk\\\/support\\\/app\\\/uploads\\\/2018\\\/12\\\/Screenshot-from-2015-01-28-14_58_24-783x111.png\",\"datePublished\":\"2021-05-05T11:04:44+00:00\",\"dateModified\":\"2022-03-03T15:06:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/support\\\/app\\\/uploads\\\/2018\\\/12\\\/Screenshot-from-2015-01-28-14_58_24-783x111.png\",\"contentUrl\":\"https:\\\/\\\/www.websupport.sk\\\/support\\\/app\\\/uploads\\\/2018\\\/12\\\/Screenshot-from-2015-01-28-14_58_24-783x111.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/externi-pristup-k-databazi-na-virtualnim-serveru\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru\"}]},{\"@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":"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru - 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\/externi-pristup-k-databazi-na-virtualnim-serveru\/","og_locale":"cs_CZ","og_type":"article","og_title":"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru - Websupport Centrum n\u00e1pov\u011bdy","og_description":"EXTERN\u00dd P\u0158\u00cdSTUP NA DATAB\u00c1ZI NA VIRTU\u00c1LN\u00cdM SERVERU (VPS) V &#8222;tov\u00e1rn\u00edm&#8220; nastaven\u00ed je vzd\u00e1len\u00fd p\u0159\u00edstup k MySQL serveru z bezpe\u010dnostn\u00edch d\u016fvod\u016f zak\u00e1zan\u00fd. N\u011bkdy ale&nbsp;budete pot\u0159ebovat poskytnout vzd\u00e1len\u00fd p\u0159\u00edstup k datab\u00e1zov\u00e9mu serveru&nbsp;pro kolegy, p\u0159\u00edpadn\u011b budete cht\u00edt vyu\u017e\u00edvat datab\u00e1zi ze str\u00e1nky, kter\u00e1 nen\u00ed na dan\u00e9m serveru. Tento n\u00e1vod bude vysv\u011btlovat, jak na va\u0161em...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2022-03-03T15:06:52+00:00","og_image":[{"url":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/Screenshot-from-2015-01-28-14_58_24-783x111.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"3 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/","name":"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/Screenshot-from-2015-01-28-14_58_24-783x111.png","datePublished":"2021-05-05T11:04:44+00:00","dateModified":"2022-03-03T15:06:52+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/#primaryimage","url":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/Screenshot-from-2015-01-28-14_58_24-783x111.png","contentUrl":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/Screenshot-from-2015-01-28-14_58_24-783x111.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/externi-pristup-k-databazi-na-virtualnim-serveru\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"Extern\u00ed p\u0159\u00edstup k datab\u00e1zi na virtu\u00e1ln\u00edm serveru"}]},{"@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\/1019","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\/1019\/revisions"}],"predecessor-version":[{"id":7503,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/1019\/revisions\/7503"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=1019"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=1019"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=1019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}