{"id":15822,"date":"2024-07-03T18:53:40","date_gmt":"2024-07-03T15:23:40","guid":{"rendered":"https:\/\/www.itpiran.net\/blog\/?p=15822"},"modified":"2024-07-03T18:53:40","modified_gmt":"2024-07-03T15:23:40","slug":"how-to-allow-remote-access-to-mysql","status":"publish","type":"post","link":"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/how-to-allow-remote-access-to-mysql\/","title":{"rendered":"MySQL&#039;e uzaktan eri\u015fime nas\u0131l izin verilir"},"content":{"rendered":"<h2 id=\"%d9%85%d9%82%d8%af%d9%85%d9%87\">girii\u015f<\/h2>\n<p>Bir\u00e7ok web sitesi ve uygulama, web sunucusu ve destekleyici veritaban\u0131n\u0131n tek bir makinede bar\u0131nd\u0131r\u0131lmas\u0131yla ba\u015flar. Ancak zamanla, b\u00f6yle bir kurulum zahmetli ve \u00f6l\u00e7eklenmesi zor hale gelebilir. Yayg\u0131n bir \u00e7\u00f6z\u00fcm, uzak bir veritaban\u0131 \u00e7al\u0131\u015ft\u0131rarak ve sunucu ile veritaban\u0131n\u0131n kendi makinelerinde kendi h\u0131zlar\u0131nda b\u00fcy\u00fcmesine izin vererek bu i\u015flevleri ay\u0131rmakt\u0131r.<\/p>\n<p>Kullan\u0131c\u0131lar\u0131n uzaktan MySQL veritaban\u0131 kurmaya \u00e7al\u0131\u015f\u0131rken kar\u015f\u0131la\u015ft\u0131klar\u0131 en yayg\u0131n sorunlardan biri, MySQL \u00f6rneklerinin yaln\u0131zca yerel ba\u011flant\u0131lar\u0131 dinleyecek \u015fekilde yap\u0131land\u0131r\u0131lm\u0131\u015f olmas\u0131d\u0131r. Bu, varsay\u0131lan MySQL ayar\u0131d\u0131r, ancak MySQL&#039;in sunucuya eri\u015filebilen harici bir IP adresini dinleyebilmesi gerekti\u011finden, uzak bir veritaban\u0131 kurmak i\u00e7in i\u015fe yaramaz. Bunu etkinle\u015ftirmek i\u00e7in mysqld.cnf dosyan\u0131z\u0131 a\u00e7\u0131n:<\/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>sudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code><\/pre>\n<\/div>\n<p>bind-address komutuyla ba\u015flayan sat\u0131ra gidin. \u015e\u00f6yle g\u00f6r\u00fcnecektir:<\/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>. . .\r\nlc-messages-dir = \/usr\/share\/mysql\r\nskip-external-locking\r\n#\r\n# Instead of skip-networking the default is now to listen only on\r\n# localhost which is more compatible and is not less secure.\r\nbind-address = 127.0.0.1\r\n. . .<\/code><\/pre>\n<\/div>\n<p>Varsay\u0131lan olarak bu de\u011fer 127.0.0.1 olarak ayarlanm\u0131\u015ft\u0131r; bu, sunucunun yaln\u0131zca yerel ba\u011flant\u0131lar\u0131 dinleyece\u011fi anlam\u0131na gelir. Harici bir IP adresine ba\u015fvurmak i\u00e7in bu y\u00f6nergeyi de\u011fi\u015ftirmeniz gerekir. Sorun giderme amac\u0131yla, bu y\u00f6nergeyi *, :: veya 0.0.0.0 gibi bir joker karakterli IP adresine ayarlayabilirsiniz:<\/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>. . .\r\nlc-messages-dir = \/usr\/share\/mysql\r\nskip-external-locking\r\n#\r\n# Instead of skip-networking the default is now to listen only on\r\n# localhost which is more compatible and is not less secure.\r\nbind-address = 0.0.0.0\r\n. . .<\/code><\/pre>\n<\/div>\n<p>Bu sat\u0131r\u0131 de\u011fi\u015ftirdikten sonra dosyay\u0131 kaydedip kapat\u0131n (CTRL + X, Y, nano ile d\u00fczenlediyseniz ENTER).<\/p>\n<p>Daha sonra mysqld.cnf dosyas\u0131nda yapt\u0131\u011f\u0131n\u0131z de\u011fi\u015fiklikleri uygulamak i\u00e7in MySQL servisini yeniden ba\u015flat\u0131n:<\/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>sudo systemctl restart mysql<\/code><\/pre>\n<\/div>\n<p>Uzak ana bilgisayar\u0131n\u0131zdan veritaban\u0131na ba\u011flanmay\u0131 planlad\u0131\u011f\u0131n\u0131z bir MySQL kullan\u0131c\u0131 hesab\u0131n\u0131z varsa, bu hesab\u0131 yerel ana bilgisayar yerine uzak sunucudan ba\u011flanacak \u015fekilde yeniden yap\u0131land\u0131rman\u0131z gerekir. Bunu yapmak i\u00e7in MySQL istemcisini MySQL k\u00f6k kullan\u0131c\u0131s\u0131 olarak veya ba\u015fka bir ayr\u0131cal\u0131kl\u0131 hesapla a\u00e7\u0131n:<\/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>sudo mysql<\/code><\/pre>\n<\/div>\n<p>E\u011fer root i\u00e7in parola do\u011frulamas\u0131 etkinle\u015ftirilmi\u015fse, MySQL kabu\u011funa eri\u015fmek i\u00e7in a\u015fa\u011f\u0131daki komutu kullanmal\u0131s\u0131n\u0131z:<\/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<\/code><\/pre>\n<\/div>\n<p>Kullan\u0131c\u0131 ana bilgisayar\u0131n\u0131 de\u011fi\u015ftirmek i\u00e7in RENAME USER MySQL komutunu kullanabilirsiniz. A\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n ve sammy yerine MySQL kullan\u0131c\u0131 hesap ad\u0131n\u0131z\u0131 ve remote_server_ip yerine uzak sunucunuzun IP adresini yazd\u0131\u011f\u0131n\u0131zdan emin olun:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>RENAME USER 'sammy'@'localhost' TO 'sammy'@'remote_server_ip';<\/code><\/pre>\n<\/div>\n<\/div>\n<p>Alternatif olarak, a\u015fa\u011f\u0131daki komutla yaln\u0131zca uzak ana bilgisayardan ba\u011flanacak yeni bir kullan\u0131c\u0131 hesab\u0131 olu\u015fturabilirsiniz:<\/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 'sammy'@'remote_server_ip' IDENTIFIED BY 'password';<\/code><\/pre>\n<\/div>\n<p>Ard\u0131ndan, yeni kullan\u0131c\u0131ya \u00f6zel ihtiya\u00e7lar\u0131n\u0131za uygun ayr\u0131cal\u0131klar\u0131 verin. A\u015fa\u011f\u0131daki \u00f6rnek, kullan\u0131c\u0131ya veritabanlar\u0131, tablolar ve kullan\u0131c\u0131lar olu\u015fturma, de\u011fi\u015ftirme ve silme konusunda genel ayr\u0131cal\u0131klar\u0131n yan\u0131 s\u0131ra sunucudaki herhangi bir tabloya veri ekleme, g\u00fcncelleme ve silme yetkisi verir. Ayr\u0131ca, kullan\u0131c\u0131n\u0131n SELECT ile veri sorgulamas\u0131na, REFERENCES anahtar s\u00f6zc\u00fc\u011f\u00fcyle yabanc\u0131 anahtarlar olu\u015fturmas\u0131na ve RELOAD ayr\u0131cal\u0131\u011f\u0131yla FLUSH i\u015flemleri ger\u00e7ekle\u015ftirmesine olanak tan\u0131r. Ancak, kullan\u0131c\u0131lara yaln\u0131zca ihtiya\u00e7 duyduklar\u0131 izinleri vermelisiniz, b\u00f6ylece kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131n\u0131z\u0131 gerekti\u011fi gibi ayarlayabilirsiniz.<\/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>GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'sammy'@'remote_server_ip' WITH GRANT OPTION;<\/code><\/pre>\n<\/div>\n<p>Bundan sonra, FLUSH PRIVILEGES komutunu \u00e7al\u0131\u015ft\u0131rmak iyi bir uygulamad\u0131r. Bu, sunucunun \u00f6nceki CREATE USER ve GRANT komutlar\u0131 sonucunda ay\u0131rd\u0131\u011f\u0131 belle\u011fi serbest b\u0131rakacakt\u0131r:<\/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>FLUSH PRIVILEGES;<\/code><\/pre>\n<\/div>\n<p>Daha sonra MySQL istemcisinden \u00e7\u0131kabilirsiniz:<\/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>exit<\/code><\/pre>\n<\/div>\n<p>Son olarak, veritaban\u0131 sunucunuzda bir g\u00fcvenlik duvar\u0131 yap\u0131land\u0131rd\u0131\u011f\u0131n\u0131z\u0131 varsayarsak, MySQL trafi\u011fine izin vermek i\u00e7in varsay\u0131lan MySQL portu olan 3306 portunu da a\u00e7man\u0131z gerekecektir.<\/p>\n<p>Veritaban\u0131 sunucusuna yaln\u0131zca belirli bir makineden eri\u015fmek istiyorsan\u0131z, a\u015fa\u011f\u0131daki komutla s\u00f6z konusu makineye uzak veritaban\u0131na ba\u011flanmak i\u00e7in \u00f6zel izin verebilirsiniz. remote_IP_address ifadesini, ba\u011flanmak istedi\u011finiz makinenin ger\u00e7ek IP adresiyle de\u011fi\u015ftirdi\u011finizden emin olun:<\/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>sudo ufw allow from remote_IP_address to any port 3306<\/code><\/pre>\n<\/div>\n<p>Gelecekte veritaban\u0131na ba\u015fka bilgisayarlardan eri\u015fmeniz gerekirse, bu komutu kullanarak ge\u00e7ici olarak eri\u015fim izni verebilirsiniz. Sadece ilgili IP adresinizi eklemeyi unutmay\u0131n.<\/p>\n<p>Alternatif olarak, a\u015fa\u011f\u0131daki komutla MySQL veritaban\u0131n\u0131za herhangi bir IP adresinden ba\u011flant\u0131lara izin verebilirsiniz:<\/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>sudo ufw allow 3306<\/code><\/pre>\n<\/div>\n<p>Bunun ard\u0131ndan veritaban\u0131n\u0131za ba\u015fka bir cihazdan uzaktan eri\u015fmeyi deneyin:<\/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 user -h database_server_ip -p<\/code><\/pre>\n<\/div>\n<p>Veritaban\u0131n\u0131za eri\u015febiliyorsan\u0131z, sorunun yap\u0131land\u0131rma dosyan\u0131zdaki bind-address y\u00f6nergesinden kaynakland\u0131\u011f\u0131 do\u011frulan\u0131r. L\u00fctfen bind-address y\u00f6nergesini 0.0.0.0 olarak ayarlaman\u0131n g\u00fcvenli olmad\u0131\u011f\u0131n\u0131 unutmay\u0131n; \u00e7\u00fcnk\u00fc bu, sunucunuza herhangi bir IP adresinden ba\u011flant\u0131 kurulmas\u0131na izin verir. \u00d6te yandan, veritaban\u0131na uzaktan hala eri\u015femiyorsan\u0131z, soruna neden olan ba\u015fka bir sorun olabilir.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"Giri\u015f Bir\u00e7ok web sitesi ve uygulaman\u0131n kendi web sunucusu ve veritaban\u0131 vard\u0131r\u2026","protected":false},"author":1,"featured_media":15823,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 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":[403,391,368],"class_list":{"0":"post-15822","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tutorials","8":"category-database","9":"tag-data-base","10":"tag-mysql","11":"tag-ubuntu"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL - \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\/tr\/tutorials\/how-to-allow-remote-access-to-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL - \u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"og:description\" content=\"\u0645\u0642\u062f\u0645\u0647 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0647\u0627 \u0648 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0628\u0627 \u0648\u0628 \u0633\u0631\u0648\u0631 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u062e\u0648\u062f&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/how-to-allow-remote-access-to-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-03T15:23:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.itpiran.net\/2024\/07\/03183615\/Mysql.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=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\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-allow-remote-access-to-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\"},\"headline\":\"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL\",\"datePublished\":\"2024-07-03T15:23:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/\"},\"wordCount\":59,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/03183615\\\/Mysql.jpg\",\"keywords\":[\"data base\",\"MySQL\",\"Ubuntu\"],\"articleSection\":[\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/\",\"name\":\"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL - \u0628\u0644\u0627\u06af ITPiran\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/03183615\\\/Mysql.jpg\",\"datePublished\":\"2024-07-03T15:23:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/03183615\\\/Mysql.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/03183615\\\/Mysql.jpg\",\"width\":1793,\"height\":1110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-allow-remote-access-to-mysql\\\/#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\":\"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL\"}]},{\"@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\":\"tr\"},{\"@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\":\"tr\",\"@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\\\/tr\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL&#039;e Uzaktan Eri\u015fim Nas\u0131l \u0130zin Verilir - 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\/tr\/tutorials\/how-to-allow-remote-access-to-mysql\/","og_locale":"tr_TR","og_type":"article","og_title":"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL - \u0628\u0644\u0627\u06af ITPiran","og_description":"\u0645\u0642\u062f\u0645\u0647 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0647\u0627 \u0648 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0628\u0627 \u0648\u0628 \u0633\u0631\u0648\u0631 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u062e\u0648\u062f&hellip;","og_url":"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/how-to-allow-remote-access-to-mysql\/","og_site_name":"\u0628\u0644\u0627\u06af ITPiran","article_published_time":"2024-07-03T15:23:40+00:00","og_image":[{"width":1793,"height":1110,"url":"https:\/\/cdn.itpiran.net\/2024\/07\/03183615\/Mysql.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"admin","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#article","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/"},"author":{"name":"admin","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81"},"headline":"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL","datePublished":"2024-07-03T15:23:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/"},"wordCount":59,"commentCount":0,"publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/03183615\/Mysql.jpg","keywords":["data base","MySQL","Ubuntu"],"articleSection":["\u0622\u0645\u0648\u0632\u0634\u06cc","\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/","url":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/","name":"MySQL&#039;e Uzaktan Eri\u015fim Nas\u0131l \u0130zin Verilir - ITPiran Blog","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/03183615\/Mysql.jpg","datePublished":"2024-07-03T15:23:40+00:00","breadcrumb":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#primaryimage","url":"https:\/\/cdn.itpiran.net\/2024\/07\/03183615\/Mysql.jpg","contentUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/03183615\/Mysql.jpg","width":1793,"height":1110},{"@type":"BreadcrumbList","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-allow-remote-access-to-mysql\/#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":"\u0646\u062d\u0648\u0647 \u0627\u062c\u0627\u0632\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.itpiran.net\/blog\/#website","url":"https:\/\/www.itpiran.net\/blog\/","name":"ITPiran Blog","description":"\u0130ran S\u00fcrd\u00fcr\u00fclebilir Ticaret Haberleri ve Makaleleri","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":"tr"},{"@type":"Organization","@id":"https:\/\/www.itpiran.net\/blog\/#organization","name":"S\u00fcrd\u00fcr\u00fclebilir \u0130ran \u0130\u015fletmeleri Blogu","alternateName":"ITPIran Blog","url":"https:\/\/www.itpiran.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"tr","@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":"y\u00f6netici","url":"https:\/\/www.itpiran.net\/blog\/tr\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/15822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/comments?post=15822"}],"version-history":[{"count":2,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/15822\/revisions"}],"predecessor-version":[{"id":15825,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/15822\/revisions\/15825"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/media\/15823"}],"wp:attachment":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/media?parent=15822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/categories?post=15822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/tags?post=15822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}