{"id":14763,"date":"2024-02-19T13:22:21","date_gmt":"2024-02-19T09:52:21","guid":{"rendered":"https:\/\/www.itpiran.net\/blog\/?p=14763"},"modified":"2024-02-19T13:22:21","modified_gmt":"2024-02-19T09:52:21","slug":"how-to-remote-mysql-server-with-pvt-net","status":"publish","type":"post","link":"https:\/\/www.itpiran.net\/blog\/en\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/","title":{"rendered":"Using a remote MySQL server on a Hetzner Cloud private network securely"},"content":{"rendered":"<h2 id=\"%d9%85%d9%82%d8%af%d9%85%d9%87\">Introduction<\/h2>\n<p>This tutorial explains how to use Hetzner Cloud Networks to access a MySQL database managed on one cloud server (MySQL Server) from a second cloud server (MySQL Client).<\/p>\n<h5 id=\"%d9%be%db%8c%d8%b4-%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\">Prerequisites<\/h5>\n<ul>\n<li>1 Hetzner cloud server with MySQL already installed.<\/li>\n<\/ul>\n<p>You can install MySQL manually or you can simply select the \u201cLAMP Stack\u201d when creating the server.<\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-1-%db%8c%da%a9-%d8%b4%d8%a8%da%a9%d9%87-%d8%ae%d8%b5%d9%88%d8%b5%db%8c-%d8%a7%db%8c%d8%ac%d8%a7%d8%af-%da%a9%d9%86%db%8c%d8%af\"><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"800\"  height=\"352\"  class=\"aligncenter wp-image-14764 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 800px) 100vw, 800px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app.png 800w, https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app-300x132.png 300w, https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app-768x338.png 768w, https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app-110x48.png 110w, https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app-200x88.png 200w, https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app-380x167.png 380w, https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app-255x112.png 255w, https:\/\/cdn.itpiran.net\/2024\/02\/19113342\/lamp-stack-app-550x242.png 550w\" ><br \/>\nStep 1 \u2013 Create a private network<\/h2>\n<p>Create your private network under your Hetzner Cloud project in the region you want to use.<\/p>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"800\"  height=\"433\"  class=\"aligncenter wp-image-14765 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 800px) 100vw, 800px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network.png 800w, https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network-300x162.png 300w, https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network-768x416.png 768w, https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network-110x60.png 110w, https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network-200x108.png 200w, https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network-380x206.png 380w, https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network-255x138.png 255w, https:\/\/cdn.itpiran.net\/2024\/02\/19113517\/create-network-550x298.png 550w\" ><br \/>\nRemember that the default IP range is set to 10.0.0.0\/16.<\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-2-%d8%b3%d8%b1%d9%88%d8%b1-%d8%b1%d8%a7-%d8%a8%d9%87-%d8%b4%d8%a8%da%a9%d9%87-%d9%85%d8%aa%d8%b5%d9%84-%da%a9%d9%86%db%8c%d8%af\">Step 2 \u2013 Connect the server to the network<\/h2>\n<p>Now you can connect the MySQL server to the new network. You can do this using the Cloud Console or the tool <code>hcloud<\/code> Do it.<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>hcloud server attach-to-network &lt;your-server-name&gt; --network &lt;your-network-name&gt; --ip &lt;pvt-ip&gt;\r\n<\/code><\/pre>\n<\/div>\n<p>The last part with <code>--ip<\/code>; Optional. If you do not specify a specific private IP, the Hetzner Cloud system will automatically assign you a free private IP.<\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-3-%d9%be%db%8c%da%a9%d8%b1%d8%a8%d9%86%d8%af%db%8c-mysql-%d8%b1%d8%a7-%d8%aa%d8%ba%db%8c%db%8c%d8%b1-%d8%af%d9%87%db%8c%d8%af\">Step 3 \u2013 Change MySQL configuration<\/h2>\n<p>To access MySQL from another machine, you need to make a change to the file <code>\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code> Create.<\/p>\n<h5 id=\"%d9%81%d8%a7%db%8c%d9%84-mysqld-cnf-%d8%b1%d8%a7-%d9%88%db%8c%d8%b1%d8%a7%db%8c%d8%b4-%da%a9%d9%86%db%8c%d8%af\">File <code>mysqld.cnf<\/code> Edit<\/h5>\n<p>To open the MySQL configuration file, use the following command:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\r\n<\/code><\/pre>\n<\/div>\n<p>Parameter <code>bind-address<\/code> from <code>127.0.0.1<\/code> To <code>0.0.0.0<\/code> Change.<\/p>\n<p>If you installed MySQL via the \u201cLAMP Stack\u201d program, you need to specify a MySQL port (by default <code>3306<\/code>) using the tool <code>ufw<\/code> Open.<\/p>\n<p>If you installed MySQL manually, you need to install the firewall with this command: <code>apt-get <\/code><code>install ufw<\/code><\/p>\n<h5 id=\"%d9%81%d8%a7%db%8c%d8%b1%d9%88%d8%a7%d9%84-%d8%b1%d8%a7-%d9%88%db%8c%d8%b1%d8%a7%db%8c%d8%b4-%da%a9%d9%86%db%8c%d8%af\">Edit the firewall<\/h5>\n<p>To open the port <code>3306<\/code> Add a rule to the firewall<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>ufw allow from 10.1.0.0\/16 to any port 3306\r\n<\/code><\/pre>\n<\/div>\n<p><code>10.1.0.0\/16<\/code> Replace with the network IP range you created in step 1.<\/p>\n<p>If you are using SSH to connect to your server, you should also allow SSH connections before enabling the firewall.<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>ufw allow OpenSSH\r\nufw enable<\/code><\/pre>\n<\/div>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-4-%db%8c%da%a9-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1-mysql-%d8%ac%d8%af%db%8c%d8%af-%d8%a7%db%8c%d8%ac%d8%a7%d8%af-%da%a9%d9%86%db%8c%d8%af\">Step 4 \u2013 Create a new MySQL user<\/h2>\n<p>Enter the MySQL CLI as the root user:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>mysql -u root -p\r\n<\/code><\/pre>\n<\/div>\n<p>Create a new MySQL user that can be used by non-local instances.<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>CREATE USER '&lt;user&gt;'@'%' IDENTIFIED BY '&lt;password&gt;';\r\nGRANT ALL PRIVILEGES ON *.* TO '&lt;user&gt;'@'%' WITH GRANT OPTION;\r\nFLUSH PRIVILEGES;<\/code><\/pre>\n<\/div>\n<p>Also, don&#039;t forget that after manipulating the file <code>mysqld.cnf<\/code>Restart MySQL. To exit the MySQL CLI, type <code>CTRL<\/code>+<code>D<\/code> Use and run the following command:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>service mysql restart\r\n<\/code><\/pre>\n<\/div>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-5-%d8%af%d8%b3%d8%aa%d8%b1%d8%b3%db%8c-mysql-%d8%b1%d8%a7-%d8%af%d8%b1-%d8%b4%d8%a8%da%a9%d9%87-%d8%ae%d8%b5%d9%88%d8%b5%db%8c-%d8%a8%d8%b1%d8%b1%d8%b3%db%8c\">Step 5 \u2013 Check MySQL access on the private network<\/h2>\n<p>Create a new server from scratch and connect it to the same private network.<\/p>\n<p>Install the MySQL client. For example, you can have the MariaDB client.<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>apt update apt install mariadb-client -y<\/code><\/pre>\n<\/div>\n<p>Now you need the private IP of the first server. In the Cloud Console you can select your project and go to the server list. From there you can copy the private IP of this server.<\/p>\n<p>Use this command to connect to the MySQL host:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>mysql -h &lt;mysql-host-private-ip&gt; -u &lt;user-created-above&gt; -p<\/code><\/pre>\n<\/div>\n<p>Then just put in your password that was created for the user and voil\u00e0 \u2013 you\u2019re logged in.<\/p>\n<h2 id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\">Result<\/h2>\n<p>Here you saw just one example of how to access a database on a private network under Hetzner Cloud.<\/p>","protected":false},"excerpt":{"rendered":"Introduction This tutorial explains how to use Hetzner cloud networks to access a MySQL database\u2026","protected":false},"author":1,"featured_media":14767,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","_yoast_wpseo_canonical":"","_yoast_wpseo_opengraph-description":"","_yoast_wpseo_opengraph-image":"","_yoast_wpseo_twitter-description":"","_yoast_wpseo_twitter-image":"","_yoast_wpseo_focuskeywords":"","_yoast_wpseo_primary_category":"193","footnotes":""},"categories":[193,349],"tags":[391,392],"class_list":{"0":"post-14763","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tutorials","8":"category-database","9":"tag-mysql","10":"tag-392"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646 - \u0628\u0644\u0627\u06af ITPiran<\/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.itpiran.net\/blog\/en\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646 - \u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"og:description\" content=\"\u0645\u0642\u062f\u0645\u0647 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0634\u0628\u06a9\u0647\u200c\u0647\u0627\u06cc \u0627\u0628\u0631\u06cc Hetzner \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MySQL \u0631\u0627 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc\u200c\u062f\u0647\u062f&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.itpiran.net\/blog\/en\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-19T09:52:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.itpiran.net\/2024\/02\/19132127\/SQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1793\" \/>\n\t<meta property=\"og:image:height\" content=\"1110\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\"},\"headline\":\"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646\",\"datePublished\":\"2024-02-19T09:52:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/\"},\"wordCount\":55,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/02\\\/19132127\\\/SQL.jpg\",\"keywords\":[\"MySQL\",\"\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\"],\"articleSection\":[\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/\",\"name\":\"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646 - \u0628\u0644\u0627\u06af ITPiran\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/02\\\/19132127\\\/SQL.jpg\",\"datePublished\":\"2024-02-19T09:52:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/02\\\/19132127\\\/SQL.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/02\\\/19132127\\\/SQL.jpg\",\"width\":1793,\"height\":1110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-remote-mysql-server-with-pvt-net\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/category\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"name\":\"\u0628\u0644\u0627\u06af ITPiran\",\"description\":\"\u0627\u062e\u0628\u0627\u0631 \u0648 \u0645\u0642\u0627\u0644\u0627\u062a \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\",\"name\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"alternateName\":\"ITPIran Blog\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"width\":512,\"height\":512,\"caption\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\",\"name\":\"admin\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/en\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using a remote MySQL server on a Hetzner Cloud private network securely - ITPiran Blog","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.itpiran.net\/blog\/en\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/","og_locale":"en_US","og_type":"article","og_title":"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646 - \u0628\u0644\u0627\u06af ITPiran","og_description":"\u0645\u0642\u062f\u0645\u0647 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0634\u0628\u06a9\u0647\u200c\u0647\u0627\u06cc \u0627\u0628\u0631\u06cc Hetzner \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MySQL \u0631\u0627 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc\u200c\u062f\u0647\u062f&hellip;","og_url":"https:\/\/www.itpiran.net\/blog\/en\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/","og_site_name":"\u0628\u0644\u0627\u06af ITPiran","article_published_time":"2024-02-19T09:52:21+00:00","og_image":[{"width":1793,"height":1110,"url":"https:\/\/cdn.itpiran.net\/2024\/02\/19132127\/SQL.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#article","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/"},"author":{"name":"admin","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81"},"headline":"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646","datePublished":"2024-02-19T09:52:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/"},"wordCount":55,"commentCount":0,"publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/02\/19132127\/SQL.jpg","keywords":["MySQL","\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647"],"articleSection":["\u0622\u0645\u0648\u0632\u0634\u06cc","\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/","url":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/","name":"Using a remote MySQL server on a Hetzner Cloud private network securely - ITPiran Blog","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#primaryimage"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/02\/19132127\/SQL.jpg","datePublished":"2024-02-19T09:52:21+00:00","breadcrumb":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#primaryimage","url":"https:\/\/cdn.itpiran.net\/2024\/02\/19132127\/SQL.jpg","contentUrl":"https:\/\/cdn.itpiran.net\/2024\/02\/19132127\/SQL.jpg","width":1793,"height":1110},{"@type":"BreadcrumbList","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-remote-mysql-server-with-pvt-net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itpiran.net\/blog\/"},{"@type":"ListItem","position":2,"name":"\u0622\u0645\u0648\u0632\u0634\u06cc","item":"https:\/\/www.itpiran.net\/blog\/category\/tutorials\/"},{"@type":"ListItem","position":3,"name":"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 MySQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062f\u0631 \u0634\u0628\u06a9\u0647 \u062e\u0635\u0648\u0635\u06cc Hetzner Cloud \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646"}]},{"@type":"WebSite","@id":"https:\/\/www.itpiran.net\/blog\/#website","url":"https:\/\/www.itpiran.net\/blog\/","name":"ITPiran Blog","description":"Iranian Sustainable Trade News and Articles","publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itpiran.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.itpiran.net\/blog\/#organization","name":"Sustainable Iranian Business Blog","alternateName":"ITPIran Blog","url":"https:\/\/www.itpiran.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","contentUrl":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","width":512,"height":512,"caption":"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81","name":"admin","url":"https:\/\/www.itpiran.net\/blog\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/14763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/comments?post=14763"}],"version-history":[{"count":1,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/14763\/revisions"}],"predecessor-version":[{"id":14766,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/14763\/revisions\/14766"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/media\/14767"}],"wp:attachment":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/media?parent=14763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/categories?post=14763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/tags?post=14763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}