{"id":5858,"date":"2019-04-28T10:04:20","date_gmt":"2019-04-28T08:04:20","guid":{"rendered":"https:\/\/homecloud.pl\/support\/?p=5858"},"modified":"2019-07-09T10:03:32","modified_gmt":"2019-07-09T08:03:32","slug":"jak-otworzyc-port-3306-na-vps-z-panelem-plesk","status":"publish","type":"post","link":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/","title":{"rendered":"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk?"},"content":{"rendered":"<ul>\n<li><a href=\"#1\">Firewall w panelu cp.homecloud.pl dla serwer\u00f3w VPS<\/a><\/li>\n<li><a href=\"#2\">Edycja plik\u00f3w na serwerze Centos\/Debian za pomoc\u0105 SSH<\/a><\/li>\n<li><a href=\"#3\">Firewall w Panelu Plesk<\/a><\/li>\n<li><a href=\"#4\">W\u0142\u0105czenie dost\u0119pu dla wszystkich baz danych w Panelu Plesk<\/a><\/li>\n<li><a href=\"#5\">W\u0142\u0105czenie dost\u0119pu dla wybranej bazy danych w Panelu Plesk<\/a><\/li>\n<\/ul>\n<p>Panel Plesk posiada domy\u015blnie zablokowany port 3306 (wynika to z polityki bezpiecze\u0144stwa). Je\u015bli skierujesz w stron\u0119 swojego serwera polecenie <strong>nmap<\/strong>, nie b\u0119dzie go na li\u015bcie otwartych port\u00f3w.<\/p>\n<div class=\"fade in alert alert-warning\"><strong>WA\u017bNE!<\/strong> Odblokowanie portu 3306 sk\u0142ada si\u0119 z kilku czynno\u015bci umo\u017cliwiaj\u0105cych jego pe\u0142n\u0105 obs\u0142ug\u0119 w zale\u017cno\u015bci od w\u0142asnych preferencji i dost\u0119pnych system\u00f3w\/paneli.<\/div>\n<h3><a name=\"1\"><\/a>Firewall w panelu cp.homecloud.pl dla serwer\u00f3w VPS<\/h3>\n<p>Panel cp.homecloud.pl dla ka\u017cdego <a href=\"https:\/\/homecloud.pl\/uslugi\/vps\/?utm_source=pomoc\">serwera VPS<\/a> oferuje zabezpieczenie firewall. Je\u015bli z niego korzystasz odblokuj port 3306:<\/p>\n<ul>\n<li><strong>Nazwa regu\u0142y<\/strong>: Dowolna nazwa (np. Serwer SQL),<\/li>\n<li><strong>Protok\u00f3\u0142<\/strong>: TCP,<\/li>\n<li><strong>Port lokalny<\/strong>: 3306,<\/li>\n<li><strong>Zdalny port<\/strong>: pozostaw puste pole.<\/li>\n<\/ul>\n<h3><a name=\"2\"><\/a>Edycja plik\u00f3w na serwerze Centos\/Debian za pomoc\u0105 SSH<\/h3>\n<p>Skorzystaj z po\u0142\u0105czenia SSH do serwera, a nast\u0119pnie edytuj pliki:<\/p>\n<ul>\n<li>w przypadku systemu<strong> Centos: <\/strong>\/etc\/my.cnf<\/li>\n<li>w przypadku systemu<strong> Debian \/ Ubuntu: <\/strong>\/etc\/mysql\/my.cnf<\/li>\n<\/ul>\n<p>W edytowanym pliku odszukaj linie:<\/p>\n<pre>bind-address = ::ffff:127.0.0.1<\/pre>\n<p>Zamie\u0144 na:<\/p>\n<pre>bind-address = 0.0.0.0<\/pre>\n<p>Zapisz zmiany w edytowanym pliku i nast\u0119pnie zrestartuj serwer baz danych:<\/p>\n<p>w przypadku systemu<strong> Centos <\/strong>u\u017cyj polecenia:<\/p>\n<pre># service mariadb restart<\/pre>\n<p>w przypadku systemu <strong>Debian \/ Ubuntu<\/strong> u\u017cyj polecenia:<\/p>\n<pre># service mysql restart<\/pre>\n<h3><a name=\"3\"><\/a>Firewall w Panelu Plesk<\/h3>\n<p>Je\u015bli korzystasz z firewalla w Panelu Plesk, to w konfiguracji Firewalla (<strong>Narz\u0119dzie i ustawienie<\/strong> &gt;<strong> Firewall<\/strong>) w\u0142\u0105cz opcj\u0119 o nazwie: <strong>Client MySQL server (Allow incoming connections from all on port 3306\/TCP)<\/strong>.<\/p>\n<h3><a name=\"4\"><\/a>W\u0142\u0105czenie dost\u0119pu dla wszystkich baz danych w Panelu Plesk<\/h3>\n<p>Przejd\u017a do sekcji: <strong>Narz\u0119dzia i ustawienia<\/strong> -&gt;<strong> Aplikacje &amp; bazy danych<\/strong> -&gt; <strong>Preferencje hostingu bazy danych<\/strong> i edytuj <strong>Ustawienia domy\u015blne zdalnego dost\u0119pu u\u017cytkownik\u00f3w bazy danych\u00a0<\/strong>w\u0142\u0105czaj\u0105c opcj\u0119 o nazwie:<\/p>\n<ul>\n<li>Zezwalaj na zdalne po\u0142\u0105czenia od ka\u017cdego hosta<\/li>\n<\/ul>\n<p>albo<\/p>\n<ul>\n<li>Zezwalaj na zdalne po\u0142\u0105czenia od -&gt; podaj\u0105c w tym miejscu adresy IP\/hosty, z kt\u00f3rych mo\u017ce nast\u0119powa\u0107 po\u0142\u0105czenie.<\/li>\n<\/ul>\n<h3><a name=\"5\"><\/a>W\u0142\u0105czenie dost\u0119pu dla wybranej bazy danych w Panelu Plesk<\/h3>\n<p>Przejd\u017a do sekcji: <strong>Strony WWW i domeny<\/strong> -&gt; <strong>Bazy danych<\/strong> -&gt; <strong>Domena<\/strong> -&gt; kliknij nazw\u0119 u\u017cytkownika.<\/p>\n<p>Opcja <strong>Kontrola dost\u0119pu<\/strong> powinna mie\u0107 w\u0142\u0105czone nast\u0119puj\u0105ce ustawienia<\/p>\n<ul>\n<li>Zezwalaj na zdalne po\u0142\u0105czenia od ka\u017cdego hosta<\/li>\n<\/ul>\n<p>albo<\/p>\n<ul>\n<li>Zezwalaj na zdalne po\u0142\u0105czenia od -&gt; podaj\u0105c w tym miejscu adresy IP\/hosty, z kt\u00f3rych mo\u017ce nast\u0119powa\u0107 po\u0142\u0105czenie.<\/li>\n<\/ul>\n<div class=\"helpful-block-content wth-theme-thumbs\" data-title=\"\" >\n<ul>\n<li><span class=\"wth-title\">Czy artyku\u0142 by\u0142 pomocny?<\/span><\/li>\n<li><a data-post=\"5858\" data-post-url=\"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/\" data-post-title=\"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk?\" data-response=\"1\" href=\"#\" class=\"wth-green-btn icon-thumbsup\">TAK<\/a>&nbsp; &nbsp;<a data-response=\"0\" data-post=\"5858\" data-post-url=\"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/\" data-post-title=\"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk?\" href=\"#\" class=\"wth-red-btn icon-thumbsdown\">Nie<\/a><\/li>\n<\/ul>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Firewall w panelu cp.homecloud.pl dla serwer\u00f3w VPS Edycja plik\u00f3w na serwerze Centos\/Debian za pomoc\u0105 SSH Firewall w Panelu Plesk W\u0142\u0105czenie dost\u0119pu dla wszystkich baz danych w Panelu Plesk W\u0142\u0105czenie dost\u0119pu dla wybranej <a class=\"blog-more btn btn-xxs btn-primary\" href=\"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/\">Wi\u0119cej<\/a><\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1261,1262],"tags":[1240,1258,1259,1280,1018,1019],"class_list":["post-5858","post","type-post","status-publish","format-standard","hentry","category-obsluga-i-konfiguracja-plesk","category-instrukcje-dot-ssh","tag-porty","tag-port-3306","tag-1259","tag-jak-otworzyc","tag-parallels-plesk-panel","tag-plesk-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk? - homecloud.pl\/support<\/title>\n<meta name=\"description\" content=\"Panel Plesk posiada domy\u015blnie zablokowany port 3306 co wynika z polityki bezpiecze\u0144stwa. Je\u015bli skierowujesz w stron\u0119 swojego serwera polecenie nmap, nie b\u0119dzie go na li\u015bcie otwartych port\u00f3w.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk? - homecloud.pl\/support\" \/>\n<meta property=\"og:description\" content=\"Panel Plesk posiada domy\u015blnie zablokowany port 3306 co wynika z polityki bezpiecze\u0144stwa. Je\u015bli skierowujesz w stron\u0119 swojego serwera polecenie nmap, nie b\u0119dzie go na li\u015bcie otwartych port\u00f3w.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/\" \/>\n<meta property=\"og:site_name\" content=\"homecloud.pl\/support\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Homecloudpl\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-28T08:04:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-09T08:03:32+00:00\" \/>\n<meta name=\"author\" content=\"Agnieszka Szmaj\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@home_pl\" \/>\n<meta name=\"twitter:site\" content=\"@home_pl\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"Agnieszka Szmaj\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/\"},\"author\":{\"name\":\"Agnieszka Szmaj\",\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/#\\\/schema\\\/person\\\/6310dfa97fb71ab17261927be8d60c33\"},\"headline\":\"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk?\",\"datePublished\":\"2019-04-28T08:04:20+00:00\",\"dateModified\":\"2019-07-09T08:03:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/\"},\"wordCount\":437,\"keywords\":[\"porty\",\"port 3306\",\"3306\",\"jak otworzy\u0107\",\"Plesk Panel\",\"Plesk\"],\"articleSection\":[\"Panel Plesk\",\"Instrukcje dot. SSH\"],\"inLanguage\":\"pl-PL\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/\",\"url\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/\",\"name\":\"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk? - homecloud.pl\\\/support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/#website\"},\"datePublished\":\"2019-04-28T08:04:20+00:00\",\"dateModified\":\"2019-07-09T08:03:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/#\\\/schema\\\/person\\\/6310dfa97fb71ab17261927be8d60c33\"},\"description\":\"Panel Plesk posiada domy\u015blnie zablokowany port 3306 co wynika z polityki bezpiecze\u0144stwa. Je\u015bli skierowujesz w stron\u0119 swojego serwera polecenie nmap, nie b\u0119dzie go na li\u015bcie otwartych port\u00f3w.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/\",\"name\":\"homecloud.pl\\\/support\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/#\\\/schema\\\/person\\\/6310dfa97fb71ab17261927be8d60c33\",\"name\":\"Agnieszka Szmaj\",\"url\":\"https:\\\/\\\/homecloud.pl\\\/support\\\/author\\\/agnieszka-szmaj\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk? - homecloud.pl\/support","description":"Panel Plesk posiada domy\u015blnie zablokowany port 3306 co wynika z polityki bezpiecze\u0144stwa. Je\u015bli skierowujesz w stron\u0119 swojego serwera polecenie nmap, nie b\u0119dzie go na li\u015bcie otwartych port\u00f3w.","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:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/","og_locale":"pl_PL","og_type":"article","og_title":"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk? - homecloud.pl\/support","og_description":"Panel Plesk posiada domy\u015blnie zablokowany port 3306 co wynika z polityki bezpiecze\u0144stwa. Je\u015bli skierowujesz w stron\u0119 swojego serwera polecenie nmap, nie b\u0119dzie go na li\u015bcie otwartych port\u00f3w.","og_url":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/","og_site_name":"homecloud.pl\/support","article_publisher":"https:\/\/www.facebook.com\/Homecloudpl\/","article_published_time":"2019-04-28T08:04:20+00:00","article_modified_time":"2019-07-09T08:03:32+00:00","author":"Agnieszka Szmaj","twitter_card":"summary_large_image","twitter_creator":"@home_pl","twitter_site":"@home_pl","twitter_misc":{"Napisane przez":"Agnieszka Szmaj","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/#article","isPartOf":{"@id":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/"},"author":{"name":"Agnieszka Szmaj","@id":"https:\/\/homecloud.pl\/support\/#\/schema\/person\/6310dfa97fb71ab17261927be8d60c33"},"headline":"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk?","datePublished":"2019-04-28T08:04:20+00:00","dateModified":"2019-07-09T08:03:32+00:00","mainEntityOfPage":{"@id":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/"},"wordCount":437,"keywords":["porty","port 3306","3306","jak otworzy\u0107","Plesk Panel","Plesk"],"articleSection":["Panel Plesk","Instrukcje dot. SSH"],"inLanguage":"pl-PL"},{"@type":"WebPage","@id":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/","url":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/","name":"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk? - homecloud.pl\/support","isPartOf":{"@id":"https:\/\/homecloud.pl\/support\/#website"},"datePublished":"2019-04-28T08:04:20+00:00","dateModified":"2019-07-09T08:03:32+00:00","author":{"@id":"https:\/\/homecloud.pl\/support\/#\/schema\/person\/6310dfa97fb71ab17261927be8d60c33"},"description":"Panel Plesk posiada domy\u015blnie zablokowany port 3306 co wynika z polityki bezpiecze\u0144stwa. Je\u015bli skierowujesz w stron\u0119 swojego serwera polecenie nmap, nie b\u0119dzie go na li\u015bcie otwartych port\u00f3w.","breadcrumb":{"@id":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/homecloud.pl\/support\/jak-otworzyc-port-3306-na-vps-z-panelem-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/homecloud.pl\/support\/"},{"@type":"ListItem","position":2,"name":"Jak otworzy\u0107 port 3306 na VPS z Panelem Plesk?"}]},{"@type":"WebSite","@id":"https:\/\/homecloud.pl\/support\/#website","url":"https:\/\/homecloud.pl\/support\/","name":"homecloud.pl\/support","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/homecloud.pl\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/homecloud.pl\/support\/#\/schema\/person\/6310dfa97fb71ab17261927be8d60c33","name":"Agnieszka Szmaj","url":"https:\/\/homecloud.pl\/support\/author\/agnieszka-szmaj\/"}]}},"_links":{"self":[{"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/posts\/5858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/comments?post=5858"}],"version-history":[{"count":15,"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/posts\/5858\/revisions"}],"predecessor-version":[{"id":6392,"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/posts\/5858\/revisions\/6392"}],"wp:attachment":[{"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/media?parent=5858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/categories?post=5858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/homecloud.pl\/support\/wp-json\/wp\/v2\/tags?post=5858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}