{"id":10593,"date":"2024-09-16T13:15:01","date_gmt":"2024-09-16T10:15:01","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=10593"},"modified":"2024-09-16T13:15:01","modified_gmt":"2024-09-16T10:15:01","slug":"mysql-root-sifresi-sifirlama-islemi-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-root-sifresi-sifirlama-islemi-nasil-yapilir\/","title":{"rendered":"MySQL Root \u015eifresi S\u0131f\u0131rlama \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"<p>MySQL root \u015fifresi ile sunucuzudaki b\u00fct\u00fcn veritabanlar\u0131na tam eri\u015fim sa\u011flars\u0131n\u0131z bu \u015fifreyi unuttu\u011funuzda muhtemelen biraz terleyeceksiniz fakat dert etmeyin a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edip \u015fifrenizi kolayca s\u0131f\u0131rlayabilirsiniz.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10605\" src=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/09\/mysql-300x145.jpg\" alt=\"MySQL Root \u015eifresi S\u0131f\u0131rlama\" width=\"780\" height=\"377\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/09\/mysql-300x145.jpg 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/09\/mysql-768x371.jpg 768w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/09\/mysql.jpg 1024w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><\/p>\n<h2>MySQL Root \u015eifresi S\u0131f\u0131rlama \u0130\u015flemi<\/h2>\n<h3>MySQL Servisini Durdurun<\/h3>\n<p style=\"text-align: center;\"><code>service mysqld stop<\/code><\/p>\n<h3>MySQL\u2019i G\u00fcvenli Modda Ba\u015flat\u0131n<\/h3>\n<p style=\"text-align: center;\"><code>mysqld_safe <span class=\"hljs-attr\">--skip-grant-tables<\/span> &amp;<\/code><\/p>\n<p style=\"text-align: center;\">(Bu komut MySQL\u2019e \u015fifresiz eri\u015fim sa\u011flaman\u0131z\u0131 m\u00fcmk\u00fcn k\u0131lar.)<\/p>\n<h3>MySQL\u2019e Root Kullan\u0131c\u0131s\u0131 Olarak Ba\u011flan\u0131n<\/h3>\n<p style=\"text-align: center;\"><code>mysql -u root<\/code><\/p>\n<h3>Kullan\u0131c\u0131 Tablosunu G\u00fcncelleyin<\/h3>\n<div class=\"dark bg-gray-950 contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: center;\"><code class=\"!whitespace-pre hljs language-perl\"><span class=\"hljs-keyword\">use<\/span> mysql;<\/code><\/div>\n<\/div>\n<div class=\"dark bg-gray-950 contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: center;\"><code class=\"!whitespace-pre hljs language-sql\"><span class=\"hljs-keyword\">update<\/span> <span class=\"hljs-keyword\">user<\/span> <span class=\"hljs-keyword\">set<\/span> password<span class=\"hljs-operator\">=<\/span>PASSWORD(<span class=\"hljs-string\">'yenisifreniziyazin'<\/span>) <span class=\"hljs-keyword\">where<\/span> <span class=\"hljs-keyword\">User<\/span><span class=\"hljs-operator\">=<\/span><span class=\"hljs-string\">'root'<\/span>;<\/code><\/div>\n<\/div>\n<h3>Yetki Tablolar\u0131n\u0131 Yenileyin<\/h3>\n<div class=\"dark bg-gray-950 contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: center;\"><code class=\"!whitespace-pre hljs language-arduino\">flush privileges;<br \/>\n<\/code><\/div>\n<\/div>\n<h3>MySQL\u2019den \u00c7\u0131k\u0131\u015f Yap\u0131n<\/h3>\n<div class=\"dark bg-gray-950 contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: center;\"><code class=\"!whitespace-pre hljs language-bash\"><span class=\"hljs-built_in\">exit<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<h3>MySQL Servisini Yeniden Ba\u015flat\u0131n<\/h3>\n<div class=\"dark bg-gray-950 contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: center;\"><code class=\"!whitespace-pre hljs\">service mysqld restart<\/code><\/div>\n<\/div>\n<p>MySQL root \u015fifresi de\u011fi\u015ftirme i\u015flemi tamamlanm\u0131\u015ft\u0131r yeni \u015fifreniz ile eri\u015fiminizi tekrardan inceleyebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL root \u015fifresi ile sunucuzudaki b\u00fct\u00fcn veritabanlar\u0131na tam eri\u015fim sa\u011flars\u0131n\u0131z bu \u015fifreyi unuttu\u011funuzda muhtemelen biraz terleyeceksiniz fakat dert etmeyin a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edip \u015fifrenizi kolayca s\u0131f\u0131rlayabilirsiniz. MySQL Root \u015eifresi S\u0131f\u0131rlama \u0130\u015flemi MySQL Servisini Durdurun service&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":10610,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-10593","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlserver"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=10593"}],"version-history":[{"count":17,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10593\/revisions"}],"predecessor-version":[{"id":10612,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10593\/revisions\/10612"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/10610"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=10593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=10593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=10593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}