{"id":1996,"date":"2021-03-22T13:57:45","date_gmt":"2021-03-22T10:57:45","guid":{"rendered":"https:\/\/www.domainhizmetleri.com\/blog\/?p=1996"},"modified":"2022-04-19T10:28:46","modified_gmt":"2022-04-19T07:28:46","slug":"cpanelde-mysql-veritabani-sihirbazi-ile-db-olusturma","status":"publish","type":"post","link":"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-mysql-veritabani-sihirbazi-ile-db-olusturma\/","title":{"rendered":"cPanel&#8217;de MySQL Veritaban\u0131 Sihirbaz\u0131 ile DB Olu\u015fturma"},"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-mysql-veritabani-sihirbazi-ile-db-olusturma\/#1_MySQL_Veritabani_Sihirbazina_Baslayin\" >1) MySQL Veritaban\u0131 Sihirbaz\u0131&#8217;na Ba\u015flay\u0131n<\/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-mysql-veritabani-sihirbazi-ile-db-olusturma\/#2_MySQL_Kullanicisi_Olusturun\" >2) MySQL Kullan\u0131c\u0131s\u0131 Olu\u015fturun<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-mysql-veritabani-sihirbazi-ile-db-olusturma\/#2_Kullaniciya_Yetki_Tanimlamayin\" >2) Kullan\u0131c\u0131ya Yetki Tan\u0131mlamay\u0131n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-mysql-veritabani-sihirbazi-ile-db-olusturma\/#Tebrikler\" >Tebrikler!<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-mysql-veritabani-sihirbazi-ile-db-olusturma\/#Ipucu_phpMyAdmin_ile_veritabaninizi_bu_bolumden_yonetebilirsiniz\" >\u0130pucu: phpMyAdmin ile veritaban\u0131n\u0131z\u0131 bu b\u00f6l\u00fcmden y\u00f6netebilirsiniz:<\/a><\/li><\/ul><\/nav><\/div>\n<div class=\"wpb-content-wrapper\"><p><strong>cPanel<\/strong> Kontrol Paneli \u00fczerinde &#8220;<strong>MySQL\u00ae Veritaban\u0131 Sihirbaz\u0131<\/strong>&#8220;na t\u0131klayarak Veritaban\u0131 (Database) olu\u015fturma s\u00fcrecine ba\u015flayabilirsiniz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3808 size-full\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql1.png\" alt=\"\" width=\"1060\" height=\"292\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql1.png 1060w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql1-300x83.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql1-1024x282.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql1-990x273.png 990w\" sizes=\"auto, (max-width: 1060px) 100vw, 1060px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"1_MySQL_Veritabani_Sihirbazina_Baslayin\"><\/span>1) MySQL Veritaban\u0131 Sihirbaz\u0131&#8217;na Ba\u015flay\u0131n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Ad\u0131m&#8217;da yer alan kutucu\u011fa veritaban\u0131 ad\u0131n\u0131 giriniz. Olu\u015fturulacak DB&#8217;nin tam ad\u0131, kutucu\u011fun \u00f6n\u00fcndeki isim ile birlikte ge\u00e7erli olacakt\u0131r.<br \/><strong>\u00d6rne\u011fin bu \u00f6rnekte: <span style=\"color: #ff0000;\">dhtest_<\/span>veritabani_adi<br \/><\/strong>cPanel kullan\u0131c\u0131 ad\u0131n\u0131z veritaban\u0131n\u0131z\u0131n hemen \u00f6n\u00fcnde otomatik yer alacakt\u0131r ve projenizde &#8220;\u00d6rn: Database Name&#8221; olarak ikisi b\u00fct\u00fcn halinde kullan\u0131lacakt\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3811 size-full\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql2.png\" alt=\"\" width=\"1010\" height=\"525\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql2.png 1010w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql2-300x156.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql2-990x515.png 990w\" sizes=\"auto, (max-width: 1010px) 100vw, 1010px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_MySQL_Kullanicisi_Olusturun\"><\/span>2) MySQL Kullan\u0131c\u0131s\u0131 Olu\u015fturun<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>2. Ad\u0131m&#8217;da yer alan Kullan\u0131c\u0131 Ad\u0131 b\u00f6l\u00fcm\u00fcne, diledi\u011finiz ad\u0131 girebilirsiniz. Hemen alt\u0131ndaki b\u00f6l\u00fcme de \u015fifre ekleyiniz. Yaln\u0131z basit \u015fifrelere sistem izin vermeyebilir. Karma\u015f\u0131k \u015fifre sizi daima potansiyel tehlikelerden koruyacakt\u0131r.<\/p>\n<p>cPanel kullan\u0131c\u0131 ad\u0131n\u0131z, MySQL kullan\u0131c\u0131 ad\u0131n\u0131n hemen \u00f6n\u00fcnde otomatik yer alacakt\u0131r ve projenizde &#8220;\u00d6rn: Database Username&#8221; olarak ikisi b\u00fct\u00fcn halinde kullan\u0131lacakt\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3815 size-full\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/kullanici.png\" alt=\"\" width=\"1029\" height=\"564\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/kullanici.png 1029w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/kullanici-300x164.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/kullanici-1024x561.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/kullanici-990x543.png 990w\" sizes=\"auto, (max-width: 1029px) 100vw, 1029px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Kullaniciya_Yetki_Tanimlamayin\"><\/span>2) Kullan\u0131c\u0131ya Yetki Tan\u0131mlamay\u0131n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bu kritik b\u00f6l\u00fcmde, iki ad\u0131m \u00f6nce olu\u015fturdu\u011funuz veritaban\u0131na, bir ad\u0131m \u00f6nce olu\u015fturdu\u011funuz kullan\u0131c\u0131n\u0131n eri\u015fim yetkilerini belirleyebilir ve s\u0131n\u0131rland\u0131rabilirsiniz. \u00d6rne\u011fin yaln\u0131zca SELECT yetkisi olu\u015fturarak, kullan\u0131c\u0131n\u0131n veritaban\u0131n\u0131zda bir i\u015flem yapmas\u0131n\u0131n da \u00f6n\u00fcne ge\u00e7ebilirsiniz. E\u011fer bu konuda detayl\u0131 bilgiye sahip de\u011filseniz, en \u00fcstte yer alan &#8220;T\u00fcm Ayr\u0131cal\u0131klar&#8221;\u0131 se\u00e7menizi \u00f6neririz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3812 size-full\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql4.png\" alt=\"\" width=\"1001\" height=\"877\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql4.png 1001w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql4-300x263.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql4-990x867.png 990w\" sizes=\"auto, (max-width: 1001px) 100vw, 1001px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tebrikler\"><\/span>Tebrikler!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Hem veritaban\u0131 hem de kullan\u0131c\u0131 olu\u015fturma i\u015fleminiz ba\u015far\u0131yla tamamland\u0131.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3813 \" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql5.png\" alt=\"\" width=\"1109\" height=\"418\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql5.png 1016w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql5-300x113.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql5-990x373.png 990w\" sizes=\"auto, (max-width: 1109px) 100vw, 1109px\" \/><\/p>\n<hr \/>\n<h2><span class=\"ez-toc-section\" id=\"Ipucu_phpMyAdmin_ile_veritabaninizi_bu_bolumden_yonetebilirsiniz\"><\/span><strong>\u0130pucu: <\/strong>phpMyAdmin ile veritaban\u0131n\u0131z\u0131 bu b\u00f6l\u00fcmden y\u00f6netebilirsiniz:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3814 size-full\" src=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql6.png\" alt=\"\" width=\"1072\" height=\"274\" srcset=\"https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql6.png 1072w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql6-300x77.png 300w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql6-1024x262.png 1024w, https:\/\/www.domainhizmetleri.com\/blog\/wp-content\/uploads\/mysql6-990x253.png 990w\" sizes=\"auto, (max-width: 1072px) 100vw, 1072px\" \/>Ba\u011flant\u0131l\u0131 Makaleler:<\/p>\n[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: #333333;\"><a style=\"color: #333333;\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/cpanelde-uzak-mysql-ozelligi-nasil-kullanilir\/\" target=\"_blank\" rel=\"noopener\">cPanel\u2019de \u2018Uzak MySQL\u2019 \u00d6zelli\u011fi Nas\u0131l Kullan\u0131l\u0131r?<\/a><\/span>[\/vc_message][\/vc_column][\/vc_row]\n[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: #333333;\"><a style=\"color: #333333;\" href=\"https:\/\/www.domainhizmetleri.com\/blog\/phpde-pdo-ile-mysql-veritabani-baglantisi\/\" target=\"_blank\" rel=\"noopener\">PHP\u2019de PDO ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131<\/a><\/span>[\/vc_message][\/vc_column][\/vc_row]\n\n\n<p>&nbsp;<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>cPanel Kontrol Paneli \u00fczerinde &#8220;MySQL\u00ae Veritaban\u0131 Sihirbaz\u0131&#8220;na t\u0131klayarak Veritaban\u0131 (Database) olu\u015fturma s\u00fcrecine ba\u015flayabilirsiniz. 1) MySQL Veritaban\u0131 Sihirbaz\u0131&#8217;na Ba\u015flay\u0131n 1. Ad\u0131m&#8217;da yer alan kutucu\u011fa veritaban\u0131 ad\u0131n\u0131 giriniz. Olu\u015fturulacak DB&#8217;nin tam ad\u0131, kutucu\u011fun \u00f6n\u00fcndeki isim ile birlikte ge\u00e7erli olacakt\u0131r.\u00d6rne\u011fin bu \u00f6rnekte: dhtest_veritabani_adicPanel kullan\u0131c\u0131 ad\u0131n\u0131z veritaban\u0131n\u0131z\u0131n hemen \u00f6n\u00fcnde otomatik yer alacakt\u0131r ve projenizde &#8220;\u00d6rn: Database Name&#8221; olarak ikisi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2185,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[143],"tags":[31,66],"class_list":["post-1996","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-domain-hosting","tag-cpanel","tag-mysql"],"views":1095,"_links":{"self":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/1996","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=1996"}],"version-history":[{"count":23,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/1996\/revisions"}],"predecessor-version":[{"id":3816,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/posts\/1996\/revisions\/3816"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/media\/2185"}],"wp:attachment":[{"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/media?parent=1996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/categories?post=1996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domainhizmetleri.com\/blog\/wp-json\/wp\/v2\/tags?post=1996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}