{"id":1207,"date":"2022-09-19T14:37:15","date_gmt":"2022-09-19T14:37:15","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=1207"},"modified":"2022-10-10T19:08:27","modified_gmt":"2022-10-10T19:08:27","slug":"mysqli-ubuntu-20-04e-nasil-kurulur","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/mysqli-ubuntu-20-04e-nasil-kurulur\/","title":{"rendered":"MySQL&#8217;i Ubuntu 20.04&#8217;e Nas\u0131l Kurulur"},"content":{"rendered":"<p><a href=\"https:\/\/www.mysql.com\/\" rel=\"nofollow noopener\" target=\"_blank\">MySQL , yayg\u0131n olarak pop\u00fcler\u00a0<\/a><a href=\"https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-20-04\" rel=\"nofollow noopener\" target=\"_blank\">LAMP<\/a>\u00a0(Linux, Apache, MySQL, PHP\/Python\/Perl) y\u0131\u011f\u0131n\u0131n\u0131n\u00a0bir par\u00e7as\u0131 olarak kurulan a\u00e7\u0131k kaynakl\u0131 bir veritaban\u0131 y\u00f6netim sistemidir .\u00a0\u0130li\u015fkisel modeli uygular ve verilerini y\u00f6netmek i\u00e7in Structured Query Language (SQL olarak daha iyi bilinir) kullan\u0131r.<\/p>\n<p>Bu e\u011fitim, MySQL s\u00fcr\u00fcm 8.0&#8217;\u0131n bir Ubuntu 20.04 sunucusuna nas\u0131l kurulaca\u011f\u0131n\u0131 ele alacakt\u0131r.\u00a0Bunu tamamlayarak, bir sonraki web sitenizi veya uygulaman\u0131z\u0131 olu\u015fturmak i\u00e7in kullanabilece\u011finiz \u00e7al\u0131\u015fan bir ili\u015fkisel veritaban\u0131na sahip olacaks\u0131n\u0131z.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Makale \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: #999;color:#999\" 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: #999;color:#999\" 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:\/\/sunucucozumleri.com\/blog\/mysqli-ubuntu-20-04e-nasil-kurulur\/#Onkosullar\" >\u00d6nko\u015fullar<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysqli-ubuntu-20-04e-nasil-kurulur\/#Adim_1_%E2%80%94_MySQLi_Yukleme\" >Ad\u0131m 1 \u2014 MySQL&#8217;i Y\u00fckleme<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysqli-ubuntu-20-04e-nasil-kurulur\/#Adim_2_%E2%80%94_MySQLi_Yapilandirma\" >Ad\u0131m 2 \u2014 MySQL&#8217;i Yap\u0131land\u0131rma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysqli-ubuntu-20-04e-nasil-kurulur\/#Adim_3_%E2%80%94_Ozel_Bir_MySQL_Kullanicisi_Olusturma_ve_Ayricaliklar_Verme\" >Ad\u0131m 3 \u2014 \u00d6zel Bir MySQL Kullan\u0131c\u0131s\u0131 Olu\u015fturma ve Ayr\u0131cal\u0131klar Verme<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysqli-ubuntu-20-04e-nasil-kurulur\/#Adim_4_%E2%80%94_MySQLi_Test_Etme\" >Ad\u0131m 4 \u2014 MySQL&#8217;i Test Etme<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysqli-ubuntu-20-04e-nasil-kurulur\/#Cozum\" >\u00c7\u00f6z\u00fcm<\/a><\/li><\/ul><\/nav><\/div>\n<h2 id=\"prerequisites\"><span class=\"ez-toc-section\" id=\"Onkosullar\"><\/span>\u00d6nko\u015fullar<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bu \u00f6\u011freticiyi takip etmek i\u00e7in ihtiyac\u0131n\u0131z olacak:<\/p>\n<ul>\n<li>K\u00f6k olmayan bir y\u00f6netici kullan\u0131c\u0131ya ve UFW ile yap\u0131land\u0131r\u0131lm\u0131\u015f bir g\u00fcvenlik duvar\u0131na sahip bir Ubuntu 20.04 sunucusu.\u00a0Bunu ayarlamak\u00a0i\u00e7in Ubuntu 20.04 i\u00e7in ilk <a href=\"https:\/\/sunucucozumleri.com\/blog\/frontpage\/\">sunucu<\/a> kurulum k\u0131lavuzumuzu\u00a0izleyin .<\/li>\n<\/ul>\n<h2 id=\"step-1-installing-mysql\"><span class=\"ez-toc-section\" id=\"Adim_1_%E2%80%94_MySQLi_Yukleme\"><\/span>Ad\u0131m 1 \u2014 MySQL&#8217;i Y\u00fckleme<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ubuntu 20.04&#8217;te MySQL&#8217;i APT paket deposunu kullanarak kurabilirsiniz.\u00a0Bu yaz\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 s\u0131rada, varsay\u0131lan Ubuntu deposunda bulunan MySQL s\u00fcr\u00fcm\u00fc 8.0.27 s\u00fcr\u00fcm\u00fcd\u00fcr.<\/p>\n<p>Y\u00fcklemek i\u00e7in, yak\u0131n zamanda yapmad\u0131ysan\u0131z sunucunuzdaki paket dizinini g\u00fcncelleyin:<\/p>\n<p><code><br \/>\nsudo apt update<br \/>\n<\/code><\/p>\n<p>Ard\u0131ndan\u00a0<code>mysql-server<\/code>paketi kurun:<\/p>\n<p><code> sudo apt install mysql-server<\/code><\/p>\n<div class=\"code-toolbar\">\n<p>&nbsp;<\/p>\n<p><span class=\"token function\">sudo<\/span> systemctl start mysql.service<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<p>Bu komutlar MySQL&#8217;i kuracak ve ba\u015flatacak, ancak sizden bir <a href=\"https:\/\/sunucucozumleri.com\/blog\/parola-saklama-uygulamalari-ve-karsilastirmalari\/\">parola<\/a> belirlemenizi veya ba\u015fka herhangi bir yap\u0131land\u0131rma de\u011fi\u015fikli\u011fi yapman\u0131z\u0131 istemeyecektir.\u00a0Bu, MySQL kurulumunuzu g\u00fcvensiz b\u0131rakt\u0131\u011f\u0131ndan, bundan sonra buna de\u011finece\u011fiz.<\/p>\n<h2 id=\"step-2-configuring-mysql\"><span class=\"ez-toc-section\" id=\"Adim_2_%E2%80%94_MySQLi_Yapilandirma\"><\/span>Ad\u0131m 2 \u2014 MySQL&#8217;i Yap\u0131land\u0131rma<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>MySQL&#8217;in yeni kurulumlar\u0131 i\u00e7in, DBMS&#8217;nin i\u00e7erdi\u011fi g\u00fcvenlik komut dosyas\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmak isteyeceksiniz.\u00a0Bu komut dosyas\u0131, uzak k\u00f6k oturum a\u00e7malar\u0131 ve \u00f6rnek kullan\u0131c\u0131lar gibi \u015feyler i\u00e7in daha az g\u00fcvenli varsay\u0131lan se\u00e7eneklerden baz\u0131lar\u0131n\u0131 de\u011fi\u015ftirir.<\/p>\n<p>G\u00fcvenlik komut dosyas\u0131n\u0131 \u015fununla \u00e7al\u0131\u015ft\u0131r\u0131n\u00a0<code>sudo<\/code>:<\/p>\n<p><code>mysql_secure_installation<\/code><\/p>\n<p>Bu sizi MySQL kurulumunuzun g\u00fcvenlik se\u00e7eneklerinde baz\u0131 de\u011fi\u015fiklikler yapabilece\u011finiz bir dizi istemden ge\u00e7irecektir. \u0130lk istem, yeni MySQL kullan\u0131c\u0131lar\u0131n\u0131n ge\u00e7erli say\u0131lmadan \u00f6nce parola g\u00fcc\u00fcn\u00fc test etmek i\u00e7in kullan\u0131labilecek Parola Do\u011frulama Eklentisini kurmak isteyip istemedi\u011finizi soracakt\u0131r.<\/p>\n<p>Parola Do\u011frulama Eklentisini kurmay\u0131 se\u00e7erseniz, olu\u015fturdu\u011funuz ve parolayla kimlik do\u011frulamas\u0131 yapan herhangi bir MySQL kullan\u0131c\u0131s\u0131n\u0131n, se\u00e7ti\u011finiz politikay\u0131 kar\u015f\u0131layan bir parolaya sahip olmas\u0131 gerekir.\u00a0Girerek se\u00e7ebilece\u011finiz en g\u00fc\u00e7l\u00fc ilke d\u00fczeyi\u00a0<code>2<\/code>, parolalar\u0131n en az sekiz karakter uzunlu\u011funda olmas\u0131n\u0131 ve b\u00fcy\u00fck harf, k\u00fc\u00e7\u00fck harf, say\u0131sal ve \u00f6zel karakterlerin bir kar\u0131\u015f\u0131m\u0131n\u0131 i\u00e7ermesini gerektirir:<\/p>\n<pre><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre><code>Securing the MySQL server deployment.\r\n\r\nConnecting to MySQL using a blank password.\r\n\r\nVALIDATE PASSWORD COMPONENT can be used to test passwords\r\nand improve security. It checks the strength of password\r\nand allows the users to set only those passwords which are\r\nsecure enough. Would you like to setup VALIDATE PASSWORD component?\r\n\r\nPress y|Y for Yes, any other key for No: <mark>Y<\/mark>\r\n\r\nThere are three levels of password validation policy:\r\n\r\nLOW    Length &gt;= 8\r\nMEDIUM Length &gt;= 8, numeric, mixed case, and special characters\r\nSTRONG Length &gt;= 8, numeric, mixed case, special characters and dictionary                  file\r\n\r\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG:\r\n <mark>2<\/mark>\r\n<\/code><\/pre>\n<p>Validate Password Plugin&#8217;i kurmay\u0131 se\u00e7ip se\u00e7medi\u011finizden ba\u011f\u0131ms\u0131z olarak, sonraki istem MySQL\u00a0<strong>root<\/strong>\u00a0kullan\u0131c\u0131s\u0131 i\u00e7in bir \u015fifre belirlemek olacakt\u0131r.\u00a0Se\u00e7ti\u011finiz g\u00fcvenli bir \u015fifreyi girin ve onaylay\u0131n:<\/p>\n<pre><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre><code>Please set the password for root here.\r\n\r\n\r\nNew password:\r\n\r\nRe-enter new password:\r\n<\/code><\/pre>\n<p><strong>K\u00f6k<\/strong>\u00a0MySQL kullan\u0131c\u0131s\u0131 i\u00e7in bir parola ayarlam\u0131\u015f olsan\u0131z bile\u00a0, bu kullan\u0131c\u0131n\u0131n \u015fu anda MySQL kabu\u011funa ba\u011flan\u0131rken bir parola ile kimlik do\u011frulamas\u0131 yapacak \u015fekilde yap\u0131land\u0131r\u0131lmad\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/p>\n<p>Parola Do\u011frulama Eklentisini kulland\u0131ysan\u0131z, yeni parolan\u0131z\u0131n g\u00fcc\u00fc hakk\u0131nda geri bildirim al\u0131rs\u0131n\u0131z.\u00a0Ard\u0131ndan komut dosyas\u0131, yeni girdi\u011finiz \u015fifre ile devam etmek mi yoksa yeni bir \u015fifre girmek mi istedi\u011finizi soracakt\u0131r.\u00a0Az \u00f6nce girdi\u011finiz parolan\u0131n g\u00fcc\u00fcnden memnun oldu\u011funuzu varsayarak\u00a0<code>Y<\/code>, komut dosyas\u0131na devam etmek i\u00e7in girin:<\/p>\n<pre><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre><code>Estimated strength of the password: 100\r\nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : <mark>Y<\/mark>\r\n<\/code><\/pre>\n<p>Oradan\u00a0, sonraki t\u00fcm sorular i\u00e7in varsay\u0131lanlar\u0131 kabul etmek i\u00e7in\u00a0<code>Y<\/code>ve ard\u0131ndan tu\u015flar\u0131na basabilirsiniz.\u00a0<code>ENTER<\/code>Bu, baz\u0131 anonim kullan\u0131c\u0131lar\u0131 ve test veritaban\u0131n\u0131 kald\u0131racak, uzak k\u00f6k oturum a\u00e7malar\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakacak ve MySQL&#8217;in yapt\u0131\u011f\u0131n\u0131z de\u011fi\u015fikliklere hemen uymas\u0131 i\u00e7in bu yeni kurallar\u0131 y\u00fckleyecektir.<\/p>\n<p>Komut dosyas\u0131 tamamland\u0131\u011f\u0131nda, MySQL kurulumunuz g\u00fcvence alt\u0131na al\u0131nacakt\u0131r.\u00a0Art\u0131k MySQL istemcisi ile \u00f6zel bir veritaban\u0131 kullan\u0131c\u0131s\u0131 olu\u015fturmaya ge\u00e7ebilirsiniz.<\/p>\n<h2 id=\"step-3-creating-a-dedicated-mysql-user-and-granting-privileges\"><span class=\"ez-toc-section\" id=\"Adim_3_%E2%80%94_Ozel_Bir_MySQL_Kullanicisi_Olusturma_ve_Ayricaliklar_Verme\"><\/span>Ad\u0131m 3 \u2014 \u00d6zel Bir MySQL Kullan\u0131c\u0131s\u0131 Olu\u015fturma ve Ayr\u0131cal\u0131klar Verme<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kurulumun ard\u0131ndan MySQL,\u00a0veritaban\u0131n\u0131z\u0131 y\u00f6netmek i\u00e7in kullanabilece\u011finiz bir\u00a0<strong>k\u00f6k kullan\u0131c\u0131 hesab\u0131 olu\u015fturur.\u00a0<\/strong>Bu kullan\u0131c\u0131n\u0131n MySQL sunucusu \u00fczerinde tam ayr\u0131cal\u0131klar\u0131 vard\u0131r, yani her veritaban\u0131, tablo, kullan\u0131c\u0131 vb. \u00fczerinde tam kontrole sahiptir.\u00a0Bu nedenle, bu hesab\u0131 y\u00f6netim i\u015flevleri d\u0131\u015f\u0131nda kullanmaktan ka\u00e7\u0131nmak en iyisidir.\u00a0Bu ad\u0131m,\u00a0yeni bir kullan\u0131c\u0131 hesab\u0131 olu\u015fturmak ve ona ayr\u0131cal\u0131klar vermek i\u00e7in\u00a0<strong>k\u00f6k MySQL kullan\u0131c\u0131s\u0131n\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6zetlemektedir.<\/strong><\/p>\n<p><code>5.7<\/code>MySQL (ve sonraki s\u00fcr\u00fcmleri)\u00a0\u00e7al\u0131\u015ft\u0131ran Ubuntu sistemlerinde ,\u00a0<strong>k\u00f6k<\/strong><code>auth_socket<\/code>\u00a0MySQL kullan\u0131c\u0131s\u0131, bir parola yerine varsay\u0131lan\u00a0olarak eklentiyi kullanarak kimlik do\u011frulamas\u0131 yapacak \u015fekilde ayarlanm\u0131\u015ft\u0131r .\u00a0<strong>Bu eklenti, MySQL istemcisini \u00e7a\u011f\u0131ran i\u015fletim sistemi kullan\u0131c\u0131s\u0131n\u0131n ad\u0131n\u0131n, komutta belirtilen MySQL kullan\u0131c\u0131s\u0131n\u0131n ad\u0131yla e\u015fle\u015fmesini gerektirir, bu nedenle, k\u00f6k<\/strong>\u00a0MySQL kullan\u0131c\u0131s\u0131na\u00a0eri\u015fmek i\u00e7in ayr\u0131cal\u0131klarla\u00a0<code>mysql<\/code>\u00e7a\u011f\u0131rman\u0131z\u00a0gerekir :<code>sudo<\/code><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> mysql<\/li>\n<\/ol>\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<div class=\"callout note\">\n<p><strong>Not:<\/strong>\u00a0MySQL&#8217;i ba\u015fka bir \u00f6\u011fretici ile y\u00fcklediyseniz ve\u00a0<strong>root<\/strong>\u00a0i\u00e7in parola do\u011frulamas\u0131n\u0131 etkinle\u015ftirdiyseniz , MySQL kabu\u011funa eri\u015fmek i\u00e7in farkl\u0131 bir komut kullanman\u0131z gerekecektir.\u00a0A\u015fa\u011f\u0131dakiler MySQL istemcinizi normal kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131yla \u00e7al\u0131\u015ft\u0131racak ve yaln\u0131zca kimlik do\u011frulamas\u0131 yaparak veritaban\u0131 i\u00e7inde y\u00f6netici ayr\u0131cal\u0131klar\u0131 kazanacaks\u0131n\u0131z:<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\">mysql -u root -p<\/li>\n<\/ol>\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><code>CREATE USER<\/code>MySQL istemine eri\u015fti\u011finizde, bir ifadeyle\u00a0yeni bir kullan\u0131c\u0131 olu\u015fturabilirsiniz .\u00a0Bunlar \u015fu genel s\u00f6zdizimini takip eder:<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">CREATE <span class=\"token environment constant\">USER<\/span> <span class=\"token string\">&#8216;<mark>username<\/mark>&#8216;<\/span>@<span class=\"token string\">&#8216;<mark>host<\/mark>&#8216;<\/span> IDENTIFIED WITH <mark>authentication_plugin<\/mark> BY <span class=\"token string\">&#8216;<mark>password<\/mark>&#8216;<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>&#8216; den sonra\u00a0<code>CREATE USER<\/code>bir kullan\u0131c\u0131 ad\u0131 belirlersiniz.\u00a0Bunu hemen bir\u00a0<code>@<\/code>i\u015faret ve ard\u0131ndan bu kullan\u0131c\u0131n\u0131n ba\u011flanaca\u011f\u0131 ana <a href=\"https:\/\/sunucucozumleri.com\/blog\/bilgisayar-nasil-kullanilir\/\">bilgisayar<\/a> ad\u0131 izler.\u00a0Bu kullan\u0131c\u0131ya yaln\u0131zca yerel olarak Ubuntu sunucunuzdan eri\u015fmeyi planl\u0131yorsan\u0131z,\u00a0<code>localhost<\/code>.\u00a0Hem kullan\u0131c\u0131 ad\u0131n\u0131 hem de ana bilgisayar\u0131 tek t\u0131rnak i\u00e7ine almak her zaman gerekli de\u011fildir, ancak bunu yapmak hatalar\u0131 \u00f6nlemeye yard\u0131mc\u0131 olabilir.<\/p>\n<p>Kullan\u0131c\u0131n\u0131z\u0131n kimlik do\u011frulama eklentisini se\u00e7me konusunda birka\u00e7 se\u00e7ene\u011finiz vard\u0131r.\u00a0Daha\u00a0<code>auth_socket<\/code>\u00f6nce bahsedilen eklenti, ge\u00e7erli kullan\u0131c\u0131lar\u0131n veritaban\u0131na eri\u015fmek i\u00e7in bir parola girmesini gerektirmeden g\u00fc\u00e7l\u00fc g\u00fcvenlik sa\u011flad\u0131\u011f\u0131 i\u00e7in kullan\u0131\u015fl\u0131 olabilir.\u00a0Ancak, harici programlar\u0131n MySQL ile etkile\u015fime girmesi gerekti\u011finde i\u015fleri karma\u015f\u0131kla\u015ft\u0131rabilecek uzak ba\u011flant\u0131lar\u0131 da \u00f6nler.<\/p>\n<p>Alternatif olarak,\u00a0kullan\u0131c\u0131n\u0131n MySQL&#8217;in varsay\u0131lan eklentisi olan\u00a0.\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/upgrading-from-previous-series.html#upgrade-caching-sha2-password\" rel=\"nofollow noopener\" target=\"_blank\">MySQL belgeleri<\/a>\u00a0, g\u00fc\u00e7l\u00fc g\u00fcvenlik \u00f6zellikleri nedeniyle bir \u015fifre ile giri\u015f yapmak isteyen kullan\u0131c\u0131lar i\u00e7in bu eklentiyi \u00f6nerir.<code>WITH\u00a0<mark>authentication_plugin<\/mark><\/code><code>caching_sha2_password<\/code><\/p>\n<p>ile kimlik do\u011frulamas\u0131 yapan bir kullan\u0131c\u0131 olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n\u00a0<code>caching_sha2_password<\/code>.\u00a0<code><mark>sammy<\/mark><\/code>Tercih etti\u011finiz kullan\u0131c\u0131 ad\u0131 ve\u00a0<code><mark>password<\/mark><\/code>se\u00e7ti\u011finiz g\u00fc\u00e7l\u00fc bir \u015fifre\u00a0ile de\u011fi\u015ftirdi\u011finizden emin olun :<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">CREATE <span class=\"token environment constant\">USER<\/span> <span class=\"token string\">&#8216;<mark>sammy<\/mark>&#8216;<\/span>@<span class=\"token string\">&#8216;localhost&#8217;<\/span> IDENTIFIED BY <span class=\"token string\">&#8216;<mark>password<\/mark>&#8216;<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<div class=\"callout note\">\n<p><strong>Not<\/strong>\u00a0: PHP&#8217;nin baz\u0131 s\u00fcr\u00fcmlerinde sorunlara neden olan bilinen bir sorun vard\u0131r\u00a0<code>caching_sha2_password<\/code>.\u00a0<code>mysql_native_password<\/code>Bu veritaban\u0131n\u0131 bir PHP uygulamas\u0131yla (\u00f6rne\u011fin phpMyAdmin) kullanmay\u0131 planl\u0131yorsan\u0131z, bunun yerine eski, ancak yine de g\u00fcvenli eklentiyle\u00a0kimlik do\u011frulamas\u0131 yapacak bir kullan\u0131c\u0131 olu\u015fturmak isteyebilirsiniz :<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">CREATE <span class=\"token environment constant\">USER<\/span> <span class=\"token string\">&#8216;<mark>sammy<\/mark>&#8216;<\/span>@<span class=\"token string\">&#8216;localhost&#8217;<\/span> IDENTIFIED WITH mysql_native_password BY <span class=\"token string\">&#8216;<mark>password<\/mark>&#8216;<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>Emin de\u011filseniz, her zaman \u015fu komutla kimlik do\u011frulamas\u0131 yapan\u00a0<code>caching_sha2_plugin<\/code>ve daha\u00a0<code>ALTER<\/code>sonra bu komutla bir kullan\u0131c\u0131 olu\u015fturabilirsiniz:<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">ALTER <span class=\"token environment constant\">USER<\/span> <span class=\"token string\">&#8216;<mark>sammy<\/mark>&#8216;<\/span>@<span class=\"token string\">&#8216;localhost&#8217;<\/span> IDENTIFIED WITH mysql_native_password BY <span class=\"token string\">&#8216;<mark>password<\/mark>&#8216;<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Yeni kullan\u0131c\u0131n\u0131z\u0131 olu\u015fturduktan sonra onlara uygun ayr\u0131cal\u0131klar\u0131 verebilirsiniz.\u00a0Kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131 vermek i\u00e7in genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">GRANT <mark>PRIVILEGE<\/mark> ON <mark>database<\/mark>.<mark>table<\/mark> TO <span class=\"token string\">&#8216;<mark>username<\/mark>&#8216;<\/span>@<span class=\"token string\">&#8216;<mark>host<\/mark>&#8216;<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>Bu\u00a0<code><mark>PRIVILEGE<\/mark><\/code>\u00f6rnek s\u00f6zdizimindeki de\u011fer, kullan\u0131c\u0131n\u0131n belirtilen\u00a0<code><mark>database<\/mark><\/code>ve \u00fczerinde ger\u00e7ekle\u015ftirmesine izin verilen eylemleri tan\u0131mlar\u00a0<code><mark>table<\/mark><\/code>.\u00a0Her birini virg\u00fclle ay\u0131rarak ayn\u0131 kullan\u0131c\u0131ya tek komutta birden \u00e7ok ayr\u0131cal\u0131k verebilirsiniz.\u00a0<code>*<\/code>Ayr\u0131ca veritaban\u0131 ve tablo adlar\u0131 yerine\u00a0y\u0131ld\u0131z i\u015faretleri ( ) girerek bir kullan\u0131c\u0131ya global olarak ayr\u0131cal\u0131klar verebilirsiniz .\u00a0SQL&#8217;de y\u0131ld\u0131z i\u015faretleri, &#8220;t\u00fcm&#8221; veritabanlar\u0131n\u0131 veya tablolar\u0131 temsil etmek i\u00e7in kullan\u0131lan \u00f6zel karakterlerdir.<\/p>\n<p><code>CREATE<\/code>\u00d6rneklemek gerekirse, a\u015fa\u011f\u0131daki komut bir kullan\u0131c\u0131ya ,\u00a0<code>ALTER<\/code>, ve veritabanlar\u0131na, tablolara ve\u00a0kullan\u0131c\u0131lara genel ayr\u0131cal\u0131klar\u0131n\u00a0<code>DROP<\/code>yan\u0131 s\u0131ra\u00a0<code>INSERT<\/code>,\u00a0<code>UPDATE<\/code>, ve\u00a0<code>DELETE<\/code>sunucudaki herhangi bir tablodan gelen verilere g\u00fc\u00e7 verir.\u00a0Ayr\u0131ca kullan\u0131c\u0131ya ile veri sorgulama ,\u00a0anahtar kelime\u00a0<code>SELECT<\/code>ile yabanc\u0131 anahtarlar olu\u015fturma ve\u00a0ayr\u0131cal\u0131\u011f\u0131\u00a0ile i\u015flem yapma imkan\u0131 verir.\u00a0Ancak, kullan\u0131c\u0131lara yaln\u0131zca ihtiya\u00e7 duyduklar\u0131 izinleri vermelisiniz, bu nedenle kendi kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131n\u0131z\u0131 gerekti\u011fi gibi ayarlamaktan \u00e7ekinmeyin.<code>REFERENCES<\/code><code>FLUSH<\/code><code>RELOAD<\/code><\/p>\n<p>Kullan\u0131labilir ayr\u0131cal\u0131klar\u0131n tam listesini\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/privileges-provided.html#privileges-provided-summary\" rel=\"nofollow noopener\" target=\"_blank\">resmi MySQL belgelerinde<\/a>\u00a0bulabilirsiniz .<\/p>\n<p>Kullan\u0131c\u0131n\u0131za bu ayr\u0131cal\u0131klar\u0131 vermek i\u00e7in kendi MySQL kullan\u0131c\u0131 ad\u0131n\u0131zla\u00a0<code>GRANT<\/code>de\u011fi\u015ftirerek\u00a0bu ifadeyi \u00e7al\u0131\u015ft\u0131r\u0131n :<code><mark>sammy<\/mark><\/code><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO <span class=\"token string\">&#8216;<mark>sammy<\/mark>&#8216;<\/span>@<span class=\"token string\">&#8216;localhost&#8217;<\/span> WITH GRANT OPTION<span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>Bu ifadenin de i\u00e7erdi\u011fini unutmay\u0131n\u00a0<code>WITH GRANT OPTION<\/code>.\u00a0Bu, MySQL kullan\u0131c\u0131n\u0131z\u0131n sistemdeki di\u011fer kullan\u0131c\u0131lara sahip oldu\u011fu t\u00fcm izinleri vermesini sa\u011flar.<\/p>\n<div class=\"callout warning\">\n<p><strong>Uyar\u0131<\/strong>\u00a0: Baz\u0131 kullan\u0131c\u0131lar MySQL kullan\u0131c\u0131lar\u0131na ,\u00a0<strong>k\u00f6k<\/strong><code>ALL PRIVILEGES<\/code>\u00a0kullan\u0131c\u0131n\u0131n ayr\u0131cal\u0131klar\u0131na benzer geni\u015f s\u00fcper kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131 sa\u011flayacak olan ayr\u0131cal\u0131\u011f\u0131 vermek isteyebilir\u00a0, \u00f6rne\u011fin:<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">GRANT ALL PRIVILEGES ON *.* TO <span class=\"token string\">&#8216;<mark>sammy<\/mark>&#8216;<\/span>@<span class=\"token string\">&#8216;localhost&#8217;<\/span> WITH GRANT OPTION<span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>Bu MySQL kullan\u0131c\u0131s\u0131na eri\u015fimi olan herkes sunucudaki her veritaban\u0131 \u00fczerinde tam kontrole sahip olaca\u011f\u0131ndan, bu\u00a0t\u00fcr geni\u015f ayr\u0131cal\u0131klar\u00a0<strong>kolayca verilmemelidir .<\/strong><\/p>\n<\/div>\n<p><code>FLUSH PRIVILEGES<\/code>Bunu takiben, komutu\u00a0\u00e7al\u0131\u015ft\u0131rmak iyi bir uygulamad\u0131r .\u00a0<code>CREATE USER<\/code>Bu, \u00f6nceki ve\u00a0<code>GRANT<\/code>ifadelerin\u00a0bir sonucu olarak sunucunun \u00f6nbelle\u011fe ald\u0131\u011f\u0131 t\u00fcm belle\u011fi bo\u015faltacakt\u0131r :<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\">FLUSH PRIVILEGES<span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>Ard\u0131ndan MySQL istemcisinden \u00e7\u0131kabilirsiniz:<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<ol>\n<li style=\"box-sizing: border-box; margin: 0px; padding: 0px; white-space: pre;\" data-prefix=\"mysql&gt;\"><span class=\"token builtin class-name\">exit<\/span><\/li>\n<\/ol>\n<pre class=\"prefixed custom_prefix language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>Gelecekte, yeni MySQL kullan\u0131c\u0131n\u0131z olarak oturum a\u00e7mak i\u00e7in a\u015fa\u011f\u0131daki gibi bir komut kullan\u0131rs\u0131n\u0131z:<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\">mysql -u <mark>sammy<\/mark> -p<\/li>\n<\/ol>\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>Bayrak\u00a0<code>-p<\/code>, MySQL istemcisinin kimlik do\u011frulamas\u0131 i\u00e7in sizden MySQL kullan\u0131c\u0131n\u0131z\u0131n \u015fifresini istemesine neden olacakt\u0131r.<\/p>\n<p>Son olarak MySQL kurulumunu test edelim.<\/p>\n<h2 id=\"step-4-testing-mysql\"><span class=\"ez-toc-section\" id=\"Adim_4_%E2%80%94_MySQLi_Test_Etme\"><\/span>Ad\u0131m 4 \u2014 MySQL&#8217;i Test Etme<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nas\u0131l y\u00fckledi\u011finize bak\u0131lmaks\u0131z\u0131n, MySQL otomatik olarak \u00e7al\u0131\u015fmaya ba\u015flam\u0131\u015f olmal\u0131d\u0131r.\u00a0Bunu test etmek i\u00e7in durumunu kontrol edin.<\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\">systemctl status mysql.service<\/li>\n<\/ol>\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>A\u015fa\u011f\u0131dakine benzer bir \u00e7\u0131kt\u0131 g\u00f6receksiniz:<\/p>\n<pre><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre><code>\u25cf mysql.service - MySQL Community Server\r\n     Loaded: loaded (\/lib\/systemd\/system\/mysql.service; enabled; vendor preset: enabled)\r\n     Active: active (running) since Tue 2020-04-21 12:56:48 UTC; 6min ago\r\n   Main PID: 10382 (mysqld)\r\n     Status: \"Server is operational\"\r\n      Tasks: 39 (limit: 1137)\r\n     Memory: 370.0M\r\n     CGroup: \/system.slice\/mysql.service\r\n             \u2514\u250010382 \/usr\/sbin\/mysqld\r\n<\/code><\/pre>\n<p>MySQL \u00e7al\u0131\u015fm\u0131yorsa, ile ba\u015flatabilirsiniz\u00a0<code>sudo systemctl start mysql<\/code>.<\/p>\n<p><code>mysqladmin<\/code>Ek bir kontrol i\u00e7in, y\u00f6netim komutlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rman\u0131za izin veren bir istemci olan arac\u0131\u00a0kullanarak veritaban\u0131na ba\u011flanmay\u0131 deneyebilirsiniz .\u00a0\u00d6rne\u011fin, bu komut,\u00a0<strong>sammy<\/strong>\u00a0(\u00a0) adl\u0131 bir MySQL kullan\u0131c\u0131s\u0131 olarak ba\u011flanmay\u0131, bir parola sormay\u0131 ( )\u00a0ve s\u00fcr\u00fcm\u00fc d\u00f6nd\u00fcrmeyi s\u00f6yl\u00fcyor.\u00a0\u00d6zel MySQL kullan\u0131c\u0131n\u0131z\u0131n ad\u0131n\u0131 de\u011fi\u015ftirdi\u011finizden emin olun\u00a0ve istendi\u011finde o kullan\u0131c\u0131n\u0131n \u015fifresini girin:<code>-u\u00a0<mark>sammy<\/mark><\/code><code>-p<\/code><code><mark>sammy<\/mark><\/code><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> mysqladmin -p -u <mark>sammy<\/mark> version<\/li>\n<\/ol>\n<pre class=\"prefixed command language-bash\"><code><\/code><\/pre>\n<div class=\"toolbar\">\n<div class=\"toolbar-item\"><button>kopyala<\/button><\/div>\n<\/div>\n<\/div>\n<p>\u015euna benzer bir \u00e7\u0131kt\u0131 g\u00f6rmelisiniz:<\/p>\n<pre><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre><code>mysqladmin  Ver 8.0.19-0ubuntu5 for Linux on x86_64 ((Ubuntu))\r\nCopyright (c) 2000, 2020, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nServer version        8.0.19-0ubuntu5\r\nProtocol version    10\r\nConnection        Localhost via UNIX socket\r\nUNIX socket        \/var\/run\/mysqld\/mysqld.sock\r\n<a href=\"https:\/\/sunucucozumleri.com\/blog\/uptime-nedir\/\">Uptime<\/a>:            10 min 44 sec\r\n\r\nThreads: 2  Questions: 25  Slow queries: 0  Opens: 149  Flush tables: 3  Open tables: 69  Queries per second avg: 0.038\r\n<\/code><\/pre>\n<p>Bu, MySQL&#8217;in \u00e7al\u0131\u015f\u0131r durumda oldu\u011fu anlam\u0131na gelir.<\/p>\n<h2 id=\"conclusion\"><span class=\"ez-toc-section\" id=\"Cozum\"><\/span>\u00c7\u00f6z\u00fcm<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Art\u0131k sunucunuzda kurulu temel bir MySQL kurulumuna sahipsiniz.\u00a0\u0130\u015fte atabilece\u011finiz sonraki ad\u0131mlara birka\u00e7 \u00f6rnek:<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL , yayg\u0131n olarak pop\u00fcler\u00a0LAMP\u00a0(Linux, Apache, MySQL, PHP\/Python\/Perl) y\u0131\u011f\u0131n\u0131n\u0131n\u00a0bir par\u00e7as\u0131 olarak kurulan a\u00e7\u0131k kaynakl\u0131 bir veritaban\u0131 y\u00f6netim sistemidir .\u00a0\u0130li\u015fkisel modeli uygular ve verilerini y\u00f6netmek i\u00e7in Structured Query Language (SQL olarak daha iyi bilinir) kullan\u0131r. Bu e\u011fitim, MySQL s\u00fcr\u00fcm 8.0&#8217;\u0131n bir Ubuntu 20.04 sunucusuna nas\u0131l kurulaca\u011f\u0131n\u0131 ele alacakt\u0131r.\u00a0Bunu tamamlayarak, bir sonraki web sitenizi veya uygulaman\u0131z\u0131 olu\u015fturmak &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1456,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1207","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=1207"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1207\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1456"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=1207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=1207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=1207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}