{"id":406,"date":"2022-07-27T10:55:22","date_gmt":"2022-07-27T07:55:22","guid":{"rendered":"https:\/\/www.aakifb.com\/?p=406"},"modified":"2022-07-27T10:57:29","modified_gmt":"2022-07-27T07:57:29","slug":"mysql-secure-installation","status":"publish","type":"post","link":"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/","title":{"rendered":"Mysql Secure Installation"},"content":{"rendered":"\n<!-- Speed Sense for AdSense WordPress Plugin: https:\/\/wordpress.org\/plugins\/speed-sense\/ -->\n<div id=\"ssp0\" style=\"float:left;margin:10px 10px 10px 0;max-width:970px;width:100%;\">\n<ins class=\"adsbygoogle\" id=\"adsgoogle0\" style=\"display: inline-block; width: 100%; height: 250px\"  data-ad-client=\"ca-pub-7093922171215546\" data-ad-slot=\"3130185915\"><\/ins><script>(adsbygoogle = window.adsbygoogle || []).push({});<\/script>\n<\/div>\n\n<p><strong>Failed! <\/strong>Error: SET PASSWORD has no significance for user &#8216;root&#8217;@&#8217;localhost&#8217; as the authentication method used doesn&#8217;t store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Ubuntu \u00fczerinde mysql_secure_installation ile kurulum yapmak istedi\u011finizde defalarca \u015fifreyi girmenize ra\u011fmen yukar\u0131daki hatay\u0131 al\u0131yorsan\u0131z takip edin \ud83d\ude42<\/p>\n\n\n\n<p><code>sudo mysql<br>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'password';<\/code><\/p>\n\n\n\n<p>\u015eeklinde tan\u0131mlama yap\u0131n\u0131z. Tabi password alan\u0131na kendi \u015fifrenizi yaz\u0131n\u0131z. Daha sonra &#8216;exit&#8217; yaz\u0131p mysql den \u00e7\u0131k\u0131n. \u015eimdi kald\u0131\u011f\u0131n\u0131z yerden devam edebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Failed! Error: SET PASSWORD has no significance for user &#8216;root&#8217;@&#8217;localhost&#8217; as the authentication method used doesn&#8217;t store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mysql Secure Installation - aakifb<\/title>\n<meta name=\"description\" content=\"mysql_secure_installation ile \u015fifre tan\u0131mlamas\u0131 yaparken ald\u0131\u011f\u0131n\u0131z hatay\u0131 d\u00fczeltmek i\u00e7in &#039;sudo mysql&#039; ve sonras\u0131nda mysql de root kullan\u0131c\u0131s\u0131na elle \u015fifre tan\u0131mlay\u0131p devam edebilirsiniz.\" \/>\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.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mysql Secure Installation - aakifb\" \/>\n<meta property=\"og:description\" content=\"mysql_secure_installation ile \u015fifre tan\u0131mlamas\u0131 yaparken ald\u0131\u011f\u0131n\u0131z hatay\u0131 d\u00fczeltmek i\u00e7in &#039;sudo mysql&#039; ve sonras\u0131nda mysql de root kullan\u0131c\u0131s\u0131na elle \u015fifre tan\u0131mlay\u0131p devam edebilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"aakifb\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-27T07:55:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-27T07:57:29+00:00\" \/>\n<meta name=\"author\" content=\"aakifb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"aakifb\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/\",\"url\":\"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/\",\"name\":\"Mysql Secure Installation - aakifb\",\"isPartOf\":{\"@id\":\"https:\/\/www.aakifb.com\/#website\"},\"datePublished\":\"2022-07-27T07:55:22+00:00\",\"dateModified\":\"2022-07-27T07:57:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7\"},\"description\":\"mysql_secure_installation ile \u015fifre tan\u0131mlamas\u0131 yaparken ald\u0131\u011f\u0131n\u0131z hatay\u0131 d\u00fczeltmek i\u00e7in 'sudo mysql' ve sonras\u0131nda mysql de root kullan\u0131c\u0131s\u0131na elle \u015fifre tan\u0131mlay\u0131p devam edebilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.aakifb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mysql Secure Installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.aakifb.com\/#website\",\"url\":\"https:\/\/www.aakifb.com\/\",\"name\":\"aakifb\",\"description\":\"Ki\u015fisel Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.aakifb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7\",\"name\":\"aakifb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.aakifb.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g\",\"caption\":\"aakifb\"},\"url\":\"https:\/\/www.aakifb.com\/index.php\/author\/aakifb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mysql Secure Installation - aakifb","description":"mysql_secure_installation ile \u015fifre tan\u0131mlamas\u0131 yaparken ald\u0131\u011f\u0131n\u0131z hatay\u0131 d\u00fczeltmek i\u00e7in 'sudo mysql' ve sonras\u0131nda mysql de root kullan\u0131c\u0131s\u0131na elle \u015fifre tan\u0131mlay\u0131p devam edebilirsiniz.","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.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/","og_locale":"tr_TR","og_type":"article","og_title":"Mysql Secure Installation - aakifb","og_description":"mysql_secure_installation ile \u015fifre tan\u0131mlamas\u0131 yaparken ald\u0131\u011f\u0131n\u0131z hatay\u0131 d\u00fczeltmek i\u00e7in 'sudo mysql' ve sonras\u0131nda mysql de root kullan\u0131c\u0131s\u0131na elle \u015fifre tan\u0131mlay\u0131p devam edebilirsiniz.","og_url":"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/","og_site_name":"aakifb","article_published_time":"2022-07-27T07:55:22+00:00","article_modified_time":"2022-07-27T07:57:29+00:00","author":"aakifb","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"aakifb","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/","url":"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/","name":"Mysql Secure Installation - aakifb","isPartOf":{"@id":"https:\/\/www.aakifb.com\/#website"},"datePublished":"2022-07-27T07:55:22+00:00","dateModified":"2022-07-27T07:57:29+00:00","author":{"@id":"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7"},"description":"mysql_secure_installation ile \u015fifre tan\u0131mlamas\u0131 yaparken ald\u0131\u011f\u0131n\u0131z hatay\u0131 d\u00fczeltmek i\u00e7in 'sudo mysql' ve sonras\u0131nda mysql de root kullan\u0131c\u0131s\u0131na elle \u015fifre tan\u0131mlay\u0131p devam edebilirsiniz.","breadcrumb":{"@id":"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.aakifb.com\/index.php\/2022\/07\/27\/mysql-secure-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.aakifb.com\/"},{"@type":"ListItem","position":2,"name":"Mysql Secure Installation"}]},{"@type":"WebSite","@id":"https:\/\/www.aakifb.com\/#website","url":"https:\/\/www.aakifb.com\/","name":"aakifb","description":"Ki\u015fisel Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.aakifb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7","name":"aakifb","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.aakifb.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g","caption":"aakifb"},"url":"https:\/\/www.aakifb.com\/index.php\/author\/aakifb\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pbvmez-6y","_links":{"self":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts\/406"}],"collection":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/comments?post=406"}],"version-history":[{"count":3,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts\/406\/revisions"}],"predecessor-version":[{"id":409,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts\/406\/revisions\/409"}],"wp:attachment":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/media?parent=406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/categories?post=406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/tags?post=406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}