{"id":1111,"date":"2025-09-23T16:41:48","date_gmt":"2025-09-23T13:41:48","guid":{"rendered":"https:\/\/narhost.com\/destek\/?p=1111"},"modified":"2025-10-27T15:12:25","modified_gmt":"2025-10-27T12:12:25","slug":"mysql-sunucuya-nasil-baglanilir","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/mysql-sunucuya-nasil-baglanilir\/","title":{"rendered":"MySQL Sunucuya Nas\u0131l Ba\u011flan\u0131l\u0131r?"},"content":{"rendered":"<p data-start=\"39\" data-end=\"236\">MySQL sunucusuna ba\u011flanmak, veritabanlar\u0131n\u0131z\u0131 y\u00f6netmek, sorgular \u00e7al\u0131\u015ft\u0131rmak ve yedekleme i\u015flemleri yapmak i\u00e7in gereklidir. Ba\u011flant\u0131 hem terminal \u00fczerinden hem de grafiksel ara\u00e7larla yap\u0131labilir.<\/p>\n<hr data-start=\"238\" data-end=\"241\" \/>\n<h2 data-start=\"243\" data-end=\"263\">\u00c7\u00f6z\u00fcm Ad\u0131mlar\u0131<\/h2>\n<ol data-start=\"265\" data-end=\"2164\">\n<li data-start=\"265\" data-end=\"512\">\n<h3 data-start=\"268\" data-end=\"312\"><strong data-start=\"268\" data-end=\"310\">Sunucuya SSH veya Console ile Ba\u011flan\u0131n<\/strong><\/h3>\n<ul data-start=\"316\" data-end=\"512\">\n<li data-start=\"316\" data-end=\"415\">\n<p data-start=\"318\" data-end=\"371\">Narhost <a href=\"https:\/\/narhost.com\/vps-sunucu\" data-internallinksmanager029f6b8e52c=\"2\" title=\"vps\" target=\"_blank\" rel=\"noopener\">VPS<\/a>\/<a href=\"https:\/\/narhost.com\/vds-sunucu\" data-internallinksmanager029f6b8e52c=\"1\" title=\"vds\" target=\"_blank\" rel=\"noopener\">VDS<\/a> sunucunuza SSH ile eri\u015fim sa\u011flay\u0131n:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\"><span class=\"hljs-attribute\">ssh<\/span> root<span class=\"hljs-variable\">@sunucu_ip<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"419\" data-end=\"512\">\n<p data-start=\"421\" data-end=\"512\">SSH \u00e7al\u0131\u015fm\u0131yorsa Narhost panelindeki <strong data-start=\"458\" data-end=\"478\">Console \/ Konsol<\/strong> ba\u011flant\u0131s\u0131n\u0131 kullanabilirsiniz.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"514\" data-end=\"888\">\n<h3 data-start=\"517\" data-end=\"572\"><strong data-start=\"517\" data-end=\"570\">MySQL\/MariaDB Servisinin \u00c7al\u0131\u015ft\u0131\u011f\u0131n\u0131 Kontrol Edin<\/strong><\/h3>\n<ul data-start=\"576\" data-end=\"888\">\n<li data-start=\"576\" data-end=\"726\">\n<p data-start=\"578\" data-end=\"608\">Servis durumunu g\u00f6rmek i\u00e7in:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\"><span class=\"hljs-attribute\">systemctl<\/span> status mysql       <span class=\"hljs-comment\"># Ubuntu\/Debian<\/span><br \/>\nsystemctl status mariadb     <span class=\"hljs-comment\"># CentOS\/RHEL<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"730\" data-end=\"888\">\n<p data-start=\"732\" data-end=\"763\">Servis \u00e7al\u0131\u015fm\u0131yorsa ba\u015flat\u0131n:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">systemctl start mysql<br \/>\nsystemctl <span class=\"hljs-built_in\">enable<\/span> mysql       <span class=\"hljs-comment\"># Sunucu a\u00e7\u0131l\u0131\u015f\u0131nda otomatik ba\u015flatmak i\u00e7in<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"890\" data-end=\"1152\">\n<h3 data-start=\"893\" data-end=\"934\"><strong data-start=\"893\" data-end=\"932\">Terminal \u00dczerinden MySQL\u2019e Ba\u011flan\u0131n<\/strong><\/h3>\n<ul data-start=\"938\" data-end=\"1152\">\n<li data-start=\"938\" data-end=\"1026\">\n<p data-start=\"940\" data-end=\"984\">MySQL root kullan\u0131c\u0131s\u0131 ile ba\u011flanmak i\u00e7in:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">mysql -u root -<span class=\"hljs-selector-tag\">p<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"1030\" data-end=\"1152\">\n<p data-start=\"1032\" data-end=\"1152\">Komutu \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonra \u015fifre sorulacakt\u0131r; Narhost panelinden veya daha \u00f6nce belirledi\u011finiz root \u015fifresini girin.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"1154\" data-end=\"1346\">\n<h3 data-start=\"1157\" data-end=\"1196\"><strong data-start=\"1157\" data-end=\"1194\">Belirli Bir Veritaban\u0131na Ba\u011flanma<\/strong><\/h3>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">mysql -u kullanici_adi -<span class=\"hljs-selector-tag\">p<\/span> veritabani_adi<br \/>\n<\/code><\/div>\n<\/div>\n<ul data-start=\"1260\" data-end=\"1346\">\n<li data-start=\"1260\" data-end=\"1346\">\n<p data-start=\"1262\" data-end=\"1346\">Bu komutla hem kullan\u0131c\u0131 ad\u0131 hem de ba\u011flan\u0131lacak veritaban\u0131n\u0131 belirleyebilirsiniz.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"1348\" data-end=\"1858\">\n<h3 data-start=\"1351\" data-end=\"1385\"><strong data-start=\"1351\" data-end=\"1383\">Uzaktan Ba\u011flant\u0131 (Opsiyonel)<\/strong><\/h3>\n<ul data-start=\"1389\" data-end=\"1858\">\n<li data-start=\"1389\" data-end=\"1667\">\n<p data-start=\"1391\" data-end=\"1517\">E\u011fer MySQL\u2019e farkl\u0131 bir bilgisayardan ba\u011flanacaksan\u0131z, sunucunun g\u00fcvenlik duvar\u0131nda 3306 portunun a\u00e7\u0131k oldu\u011fundan emin olun:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">ufw allow 3306\/tcp     <span class=\"hljs-comment\"># Ubuntu<\/span><br \/>\nfirewall-cmd --add-port=3306\/tcp --permanent<br \/>\nfirewall-cmd --reload   <span class=\"hljs-comment\"># CentOS\/RHEL<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"1671\" data-end=\"1858\">\n<p data-start=\"1673\" data-end=\"1720\">Kullan\u0131c\u0131n\u0131n uzaktan ba\u011flanma izni olmal\u0131d\u0131r:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-sql\"><span class=\"hljs-keyword\">GRANT<\/span> <span class=\"hljs-keyword\">ALL<\/span> PRIVILEGES <span class=\"hljs-keyword\">ON<\/span> veritabani_adi.<span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">TO<\/span> <span class=\"hljs-string\">'kullanici_adi'<\/span>@<span class=\"hljs-string\">'%'<\/span> IDENTIFIED <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-string\">'sifre'<\/span>;<br \/>\nFLUSH PRIVILEGES;<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"1860\" data-end=\"1999\">\n<h3 data-start=\"1863\" data-end=\"1889\"><strong data-start=\"1863\" data-end=\"1887\">Ba\u011flant\u0131y\u0131 Test Edin<\/strong><\/h3>\n<ul data-start=\"1893\" data-end=\"1999\">\n<li data-start=\"1893\" data-end=\"1999\">\n<p data-start=\"1895\" data-end=\"1951\">MySQL prompt\u2019a eri\u015febiliyorsan\u0131z ba\u011flant\u0131 ba\u015far\u0131l\u0131d\u0131r:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\"><span class=\"hljs-meta prompt_\">mysql&gt; <\/span><span class=\"language-bash\">SHOW DATABASES;<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"2001\" data-end=\"2164\">\n<h3 data-start=\"2004\" data-end=\"2028\"><strong data-start=\"2004\" data-end=\"2026\">G\u00fcvenlik \u00d6nlemleri<\/strong><\/h3>\n<ul data-start=\"2032\" data-end=\"2164\">\n<li data-start=\"2032\" data-end=\"2106\">\n<p data-start=\"2034\" data-end=\"2106\">Root kullan\u0131c\u0131 ile uzaktan ba\u011flant\u0131 yaparken <a href=\"https:\/\/narhost.com\/ip-kiralama\" data-internallinksmanager029f6b8e52c=\"17\" title=\"ip kiralama\" target=\"_blank\" rel=\"noopener\">IP<\/a> k\u0131s\u0131tlamas\u0131 uygulay\u0131n.<\/p>\n<\/li>\n<li data-start=\"2110\" data-end=\"2164\">\n<p data-start=\"2112\" data-end=\"2164\">Parolalar\u0131 g\u00fc\u00e7l\u00fc belirleyin ve d\u00fczenli de\u011fi\u015ftirin.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p data-start=\"2171\" data-end=\"2187\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL sunucusuna ba\u011flanmak, veritabanlar\u0131n\u0131z\u0131 y\u00f6netmek, sorgular \u00e7al\u0131\u015ft\u0131rmak ve yedekleme i\u015flemleri yapmak i\u00e7in gereklidir. Ba\u011flant\u0131 hem terminal \u00fczerinden hem de grafiksel ara\u00e7larla yap\u0131labilir.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13],"tags":[75,83,87],"class_list":["post-1111","post","type-post","status-publish","format-standard","hentry","category-vds-server","category-vps-server","tag-vps","tag-mysql","tag-vds"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=1111"}],"version-history":[{"count":3,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1111\/revisions"}],"predecessor-version":[{"id":1221,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1111\/revisions\/1221"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}