{"id":1123,"date":"2018-12-18T18:18:06","date_gmt":"2018-12-18T15:18:06","guid":{"rendered":"http:\/\/www.domainhizmetleri.com\/blog\/?p=1123"},"modified":"2022-04-19T10:32:35","modified_gmt":"2022-04-19T07:32:35","slug":"cpanelde-uzak-mysql-ozelligi-nasil-kullanilir","status":"publish","type":"post","link":"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-uzak-mysql-ozelligi-nasil-kullanilir\/","title":{"rendered":"cPanel&#8217;de &#8216;Uzak MySQL&#8217; \u00d6zelli\u011fi Nas\u0131l Kullan\u0131l\u0131r?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Yaz\u0131 \u0130\u00e7eri\u011fi<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u0130\u00e7indekiler Tablosunu A\u00e7\/Kapat\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0a0a0a;color:#0a0a0a\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0a0a0a;color:#0a0a0a\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-uzak-mysql-ozelligi-nasil-kullanilir\/#Uzak_MySQL_Yetkisi_Tanimlama\" >Uzak MySQL Yetkisi Tan\u0131mlama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-uzak-mysql-ozelligi-nasil-kullanilir\/#Ornek_Uzak_MySQL_Baglanti_Testi_HeidiSQL_ile\" >\u00d6rnek Uzak MySQL Ba\u011flant\u0131 Testi (HeidiSQL ile)<\/a><\/li><\/ul><\/nav><\/div>\n<div class=\"wpb-content-wrapper\">[vc_row][vc_column][vc_message message_box_style=&#8221;3d&#8221; message_box_color=&#8221;success&#8221; icon_fontawesome=&#8221;far fa-smile-wink&#8221;]<span style=\"color: #000000;\"><strong><a style=\"color: #000000;\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-mysql-veritabani-sihirbazi-ile-db-olusturma\/\" target=\"_blank\" rel=\"noopener\">cPanel&#8217;de MySQL Veritaban\u0131 Sihirbaz\u0131 ile DB Nas\u0131l Olu\u015fturulur? Detayl\u0131 a\u00e7\u0131klama i\u00e7in buraya t\u0131klay\u0131n.<\/a><\/strong><\/span>[\/vc_message][\/vc_column][\/vc_row]\n<p><strong>cPanel<\/strong> Kontrol Paneli \u00fczerinde &#8220;<strong>Uzak MySQL\u00ae \/\u00a0Remote MySQL\u00ae<\/strong>&#8220;e t\u0131klayarak yetki y\u00f6netim sayfas\u0131na ge\u00e7iniz :<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Uzak_MySQL_Yetkisi_Tanimlama\"><\/span>Uzak MySQL Yetkisi Tan\u0131mlama<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3821 size-full\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql1-1.png\" alt=\"\" width=\"1116\" height=\"558\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql1-1.png 1116w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql1-1-300x150.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql1-1-1024x512.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql1-1-990x495.png 990w\" sizes=\"auto, (max-width: 1116px) 100vw, 1116px\" \/><\/p>\n<p>Kar\u015f\u0131n\u0131za gelen sayfada, sahip oldu\u011funuz cPanel&#8217;e ait t\u00fcm veritabanlar\u0131n\u0131n eri\u015fim izinlerini y\u00f6netebilirsiniz.<\/p>\n<p>Varsay\u0131lan olarak, hostinginizin bulundu\u011fu sunucunun IP adresi ekli olabilir. Bu durum normaldir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3824 size-full\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql2.png\" alt=\"\" width=\"1111\" height=\"615\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql2.png 1111w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql2-300x166.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql2-1024x567.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql2-215x120.png 215w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/uzakmysql2-990x548.png 990w\" sizes=\"auto, (max-width: 1111px) 100vw, 1111px\" \/><\/p>\n<div class=\"mks_pullquote mks_pullquote_\" style=\"width:300px; font-size: 16px; color: #000; background-color:;\">Uzak eri\u015fimlerde MySQL Kullan\u0131c\u0131 Ad\u0131 ve Kullan\u0131c\u0131 \u015eifresi kullan\u0131m\u0131 zorunludur. Burada verece\u011finiz yetkiyi, kullan\u0131c\u0131 do\u011frulamas\u0131ndan bir \u00f6nceki koruma kap\u0131s\u0131 olarak d\u00fc\u015f\u00fcnebilirsiniz.<\/div>\n<h5><strong>1. \u0130\u015faret: Ana Bilgisayar<\/strong><\/h5>\n<p><span style=\"color: #2e2e2e;\"><strong>Bu b\u00f6l\u00fcm, uzak eri\u015fim i\u00e7in yetkili olacak IP veya hostname adresini girdi\u011finiz kutucuktur.<\/strong> \u00d6rne\u011fin evinizdeki internet \u00e7\u0131k\u0131\u015f IP&#8217;niz veya sanal sunucu IP&#8217;niz olabilir. 3 farkl\u0131 y\u00f6ntemle eri\u015fecek IP&#8217;nin izinlerini verebilirsiniz. Evinizden veya ofisinizden ba\u011flanmak i\u00e7in IP adresinizi bilmiyorsan\u0131z, \u00f6ncelikle <a href=\"https:\/\/ip.domainhizmetleri.com\" target=\"_blank\" rel=\"noopener noreferrer\">buraya t\u0131klayarak IP adresinizi \u00f6\u011frenebilir<\/a>siniz. E\u011fer statik IP&#8217;ye sahip de\u011filseniz, modeminiz yeniden ba\u015flad\u0131ktan sonra IP&#8217;niz de\u011fi\u015fece\u011fi i\u00e7in her seferinde \u00f6nceki IP&#8217;yi silerek yeni IP&#8217;nizi girmeniz gerekecektir.<\/span><\/p>\n<ul>\n<li><span style=\"color: #2e2e2e;\"><strong>Tam bir hostname ad\u0131 (FQDN)<\/strong><\/span><br \/>\n<span style=\"color: #2e2e2e;\">D\u0131\u015far\u0131dan ba\u011flant\u0131 kuraca\u011f\u0131n\u0131z IP&#8217;nin rDNS (PTR) kayd\u0131n\u0131 girebilirsiniz. IP&#8217;nizin rDNS kayd\u0131n\u0131 <a href=\"https:\/\/mxtoolbox.com\/ReverseLookup.aspx\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">buradan<\/a>\u00a0sorgulayabilirsiniz.<\/span><br \/>\n<span style=\"color: #2e2e2e;\">\u00d6rn: vds.example.com<\/span><\/li>\n<li><span style=\"color: #2e2e2e;\"><strong>Tekil IP adresi veya Subnet<\/strong><\/span><br \/>\n<span style=\"color: #2e2e2e;\"><span style=\"color: #2e2e2e;\">\u00d6rn: 192.168.1.10 veya 192.168.1.% veya 192.168.%<\/span><\/span><\/li>\n<li><span style=\"color: #2e2e2e;\"><strong>Joker (Wildcard) Sembol\u00fc Kullanabilirsiniz:\u00a0 <span style=\"color: #ff0000;\">%<\/span><\/strong><\/span><br \/>\n<strong>%<\/strong><span style=\"color: #2e2e2e;\"> sembol\u00fc &#8220;her yer&#8221; anlam\u0131 ta\u015f\u0131r. Bununla t\u00fcm IP&#8217;lere eri\u015fim izni verebilirsiniz. Yaln\u0131z, bu durum g\u00fcvenlik riskine sahip olaca\u011f\u0131 i\u00e7in \u00f6ncelikle tavsiye etmiyoruz. MySQL \u015fifrenizin e\u011fer yeterince kar\u0131\u015f\u0131k ve tahmini zor oldu\u011funa eminseniz,\u00a0 <\/span><strong>%<\/strong><span style=\"color: #2e2e2e;\"> i\u015fareti ile Joker yetki girerek t\u00fcm IP&#8217;lerden \u015fifre do\u011frulamas\u0131yla giri\u015f yapabilmesine imkan verebilirsiniz.<\/span><\/li>\n<\/ul>\n<h5><strong>2. \u0130\u015faret: Comment (Yorum)<\/strong><\/h5>\n<p>Girdi\u011finiz IP&#8217;nin nereye ait oldu\u011funu hat\u0131rlamak i\u00e7in bir metin yazabilirsiniz. Zorunlu de\u011fildir.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ornek_Uzak_MySQL_Baglanti_Testi_HeidiSQL_ile\"><\/span>\u00d6rnek Uzak MySQL Ba\u011flant\u0131 Testi (HeidiSQL ile)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bilgisayar\u0131n\u0131zda HeidiSQL yoksa, kullanmak i\u00e7in <a href=\"https:\/\/www.heidisql.com\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">buradan<\/a> indirebilirsiniz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1845\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/k0b1.png\" alt=\"\" width=\"794\" height=\"547\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/k0b1.png 794w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/k0b1-300x207.png 300w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/p>\n<p><strong>1. \u0130\u015faret:<\/strong>\u00a0Yeni ba\u011flant\u0131 kayd\u0131 olu\u015fturun<br \/>\n<strong>2. \u0130\u015faret:<\/strong>\u00a0Ba\u011flant\u0131n\u0131za bir isim verin<br \/>\n<strong>3. \u0130\u015faret:<\/strong>\u00a0Bu b\u00f6l\u00fcm MySQL sunucu adresidir. Web hostinginizin \u00e7al\u0131\u015ft\u0131\u011f\u0131 <strong>hostname<\/strong> adresini veya <strong>IP adresi<\/strong>ni girebilirsiniz. Domainhizmetleri kullan\u0131c\u0131s\u0131 iseniz, web sitenizin ba\u011fl\u0131 oldu\u011fu sunucu hostname adresini yazman\u0131z yeterlidir.<br \/>\n<strong>4. \u0130\u015faret:<\/strong>\u00a0MySQL kullan\u0131c\u0131 ad\u0131<br \/>\n<strong>5. \u0130\u015faret:<\/strong>\u00a0MySQL kullan\u0131c\u0131 \u015fifresi<\/p>\n<p>Art\u0131k veritaban\u0131n\u0131z kar\u015f\u0131n\u0131zda!<\/p>\n<p>\u0130yi g\u00fcnlerde kullanman\u0131z dile\u011fiyle&#8230;<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][vc_message message_box_style=&#8221;3d&#8221; message_box_color=&#8221;success&#8221; icon_fontawesome=&#8221;far fa-smile-wink&#8221;]cPanel&#8217;de MySQL Veritaban\u0131 Sihirbaz\u0131 ile DB Nas\u0131l Olu\u015fturulur? Detayl\u0131 a\u00e7\u0131klama i\u00e7in buraya t\u0131klay\u0131n.[\/vc_message][\/vc_column][\/vc_row] cPanel Kontrol Paneli \u00fczerinde &#8220;Uzak MySQL\u00ae \/\u00a0Remote MySQL\u00ae&#8220;e t\u0131klayarak yetki y\u00f6netim sayfas\u0131na ge\u00e7iniz : Uzak MySQL Yetkisi Tan\u0131mlama Kar\u015f\u0131n\u0131za gelen sayfada, sahip oldu\u011funuz cPanel&#8217;e ait t\u00fcm veritabanlar\u0131n\u0131n eri\u015fim izinlerini y\u00f6netebilirsiniz. Varsay\u0131lan olarak, hostinginizin bulundu\u011fu sunucunun IP adresi ekli [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":171,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[143],"tags":[31,24,66,98,97],"class_list":["post-1123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-domain-hosting","tag-cpanel","tag-linux","tag-mysql","tag-remote-mysql","tag-uzak-mysql"],"views":4910,"_links":{"self":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/1123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/comments?post=1123"}],"version-history":[{"count":18,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/1123\/revisions"}],"predecessor-version":[{"id":3825,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/1123\/revisions\/3825"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/media\/171"}],"wp:attachment":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/media?parent=1123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/categories?post=1123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/tags?post=1123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}