{"id":1988,"date":"2026-09-12T17:49:57","date_gmt":"2026-09-12T14:49:57","guid":{"rendered":"https:\/\/narhost.com\/destek\/windows-sunucuda-mysql-root-sifresi-sifirlama\/"},"modified":"2026-09-12T17:49:57","modified_gmt":"2026-09-12T14:49:57","slug":"windows-sunucuda-mysql-root-sifresi-sifirlama","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/windows-sunucuda-mysql-root-sifresi-sifirlama\/","title":{"rendered":"Windows Sunucuda MySQL Root \u015eifresi S\u0131f\u0131rlama"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son g\u00f6zden ge\u00e7irme: Eyl\u00fcl 2026 \u00b7 MySQL 8.4 Reference Manual (dev.mysql.com) resmi dok\u00fcman\u0131na g\u00f6re<\/p>\n<div id=\"hizli-cozum\" class=\"ai-box ai-box--cozum\">\n<p class=\"ai-box-title\">H\u0131zl\u0131 \u00e7\u00f6z\u00fcm<\/p>\n<p><strong>Windows sunucuda MySQL root \u015fifresi s\u0131f\u0131rlama<\/strong> i\u015flemi MySQL servisini durdurup ALTER USER komutu i\u00e7eren bir init dosyas\u0131yla mysqld&#8217;yi ba\u015flatmaktan ibarettir; sunucunuzda y\u00f6netici olarak Komut \u0130stemi&#8217;nde uygulay\u0131n.<\/p>\n<ol>\n<li>MySQL servisini durdurun: <code>net stop MySQL84<\/code> (servis ad\u0131n\u0131z farkl\u0131ysa <code>Get-Service *MySQL*<\/code> ile bulun).<\/li>\n<li><code>C:\\mysql-init.txt<\/code> dosyas\u0131na <code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'YeniSifreniz';<\/code> sat\u0131r\u0131n\u0131 yaz\u0131n.<\/li>\n<li><code>mysqld --init-file=C:\\mysql-init.txt<\/code> komutunu \u00e7al\u0131\u015ft\u0131r\u0131p sunucunun ba\u015flamas\u0131n\u0131 bekleyin.<\/li>\n<li>Init dosyas\u0131n\u0131 silin, MySQL servisini normal \u015fekilde yeniden ba\u015flat\u0131n ve yeni \u015fifreyle ba\u011flan\u0131n.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>Yok \u2014 MySQL Server Windows&#8217;ta ba\u011f\u0131ms\u0131z bir servis olarak \u00e7al\u0131\u015f\u0131r<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Windows Server 2019, Windows Server 2022 + MySQL Server 8.0\/8.4<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>Sunucuda y\u00f6netici (Administrator) hesab\u0131<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/vds-sunucu\" title=\"Narhost VDS Sunucu \u2014 Windows Server se\u00e7enekleri\">VDS Sunucu<\/a><\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Sunucunuzda y\u00f6netici yetkili bir hesapla oturum a\u00e7abildi\u011finizi do\u011frulay\u0131n.<\/li>\n<li>MySQL servisinizin tam ad\u0131n\u0131 bilin (<code>MySQL80<\/code>, <code>MySQL84<\/code> gibi s\u00fcr\u00fcme g\u00f6re de\u011fi\u015fir); <code>Get-Service *MySQL*<\/code> ile listeleyebilirsiniz.<\/li>\n<li>Root \u015fifresine ba\u011f\u0131ml\u0131 \u00e7al\u0131\u015fan uygulamalar\u0131n\u0131z varsa (site, betik, zamanlanm\u0131\u015f g\u00f6rev) \u015fifreyi de\u011fi\u015ftirdikten sonra onlar\u0131 da g\u00fcncelleyece\u011finizi unutmay\u0131n.<\/li>\n<li>\u0130\u015flem \u00f6ncesi veritabanlar\u0131n\u0131z\u0131n g\u00fcncel bir yede\u011finin oldu\u011fundan emin olun.<\/li>\n<\/ul>\n<\/div>\n<h2>Windows Sunucuda MySQL Root \u015eifresi S\u0131f\u0131rlama Neden Gerekir<\/h2>\n<p>Root \u015fifresi unutuldu\u011funda ya da bir g\u00fcvenlik ihlali sonras\u0131 zorunlu de\u011fi\u015fiklik gerekti\u011finde normal <code>ALTER USER<\/code> ya da <code>SET PASSWORD<\/code> komutlar\u0131 \u00e7al\u0131\u015fmaz; \u00e7\u00fcnk\u00fc bu komutlar\u0131n ikisi de root olarak oturum a\u00e7may\u0131 gerektirir. Bu y\u00f6ntem bu d\u00f6ng\u00fcy\u00fc <code>--init-file<\/code> se\u00e7ene\u011fiyle k\u0131rar: sunucu ba\u015flarken kimlik do\u011frulamas\u0131 istemeden \u00e7al\u0131\u015ft\u0131raca\u011f\u0131 komutlar\u0131 bu dosyadan okur.<\/p>\n<div class=\"highlight-box\">\n<p class=\"label\">Bilgi<\/p>\n<p>Linux sunucularda ayn\u0131 i\u015flem <code>--skip-grant-tables<\/code> ile yap\u0131l\u0131r; Windows&#8217;ta MySQL&#8217;in resmi dok\u00fcman\u0131 <code>--init-file<\/code> y\u00f6ntemini \u00f6nerir, iki y\u00f6ntem de sunucuyu ge\u00e7ici olarak kimlik do\u011frulamas\u0131z a\u00e7\u0131\u011fa \u00e7\u0131kar\u0131r.<\/p>\n<\/div>\n<figure class=\"nh-sema\"><img src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/windows-sunucuda-mysql-root-sifresi-sifirlama-sema-narhost.webp\" alt=\"Windows sunucuda mysql root \u015fifresi s\u0131f\u0131rlama ak\u0131\u015f \u015femas\u0131 \u2014 servisi durdurma, init dosyas\u0131, mysqld ba\u015flatma ve do\u011frulama ad\u0131mlar\u0131\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>D\u00f6rt ad\u0131m: servisi durdurun, init dosyas\u0131n\u0131 yaz\u0131n, g\u00fcvenli kipte ba\u015flat\u0131n, sonucu do\u011frulay\u0131n.<\/figcaption><\/figure>\n<h2>Ad\u0131m Ad\u0131m MySQL Root \u015eifresi S\u0131f\u0131rlama<\/h2>\n<h3>Y\u00f6ntem 1 \u2014 &#8211;init-file ile (resm\u00ee y\u00f6ntem)<\/h3>\n<ol class=\"kb-adimlar\">\n<li><strong>Y\u00f6netici olarak Komut \u0130stemi a\u00e7\u0131n<\/strong> ve MySQL servisini durdurun.\n<pre><code class=\"language-powershell\">net stop MySQL84<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>MySQL84 hizmeti durduruluyor. MySQL84 hizmeti ba\u015far\u0131yla durduruldu.<\/code><\/p>\n<\/li>\n<li><strong>Metin d\u00fczenleyicide<\/strong> (Not Defteri gibi) <code>C:\\mysql-init.txt<\/code> dosyas\u0131n\u0131 olu\u015fturun ve \u015fu sat\u0131r\u0131 yaz\u0131n; <code>YeniSifreniz<\/code> yerine kendi \u015fifrenizi kullan\u0131n.\n<pre><code class=\"language-sql\">ALTER USER 'root'@'localhost' IDENTIFIED BY 'YeniSifreniz';<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: dosya d\u00fcz metin olarak kaydedilir, uzant\u0131 <code>.txt<\/code> kal\u0131r.<\/p>\n<\/li>\n<li><strong>MySQL&#8217;in kurulu oldu\u011fu <code>bin<\/code> klas\u00f6r\u00fcne ge\u00e7ip mysqld&#8217;yi init dosyas\u0131yla ba\u015flat\u0131n.<\/strong>\n<pre><code class=\"language-powershell\">cd \"C:\\Program Files\\MySQL\\MySQL Server 8.4\\bin\"mysqld --init-file=C:\\mysql-init.txt --console<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: konsolda ba\u015flang\u0131\u00e7 g\u00fcnl\u00fckleri akar, init dosyas\u0131ndaki komut sessizce \u00e7al\u0131\u015f\u0131r; hata yoksa sunucu normal a\u00e7\u0131l\u0131\u015f mesajlar\u0131n\u0131 yazmaya devam eder.<\/p>\n<\/li>\n<li><strong>Sunucuyu durdurun (Ctrl+C), init dosyas\u0131n\u0131 silin ve servisi normal ba\u015flat\u0131n.<\/strong>\n<pre><code class=\"language-powershell\">del C:\\mysql-init.txtnet start MySQL84<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>MySQL84 hizmeti ba\u015flat\u0131l\u0131yor. MySQL84 hizmeti ba\u015far\u0131yla ba\u015flat\u0131ld\u0131.<\/code><\/p>\n<\/li>\n<\/ol>\n<h3>Servisi Genel Komutlarla Kontrol Etme<\/h3>\n<p>MySQL servisinin sunucuda kurulu ve \u00e7al\u0131\u015f\u0131r durumda olup olmad\u0131\u011f\u0131n\u0131 genel Windows komutuyla kontrol edebilirsiniz. Test sunucumuzda MySQL kurulu olmad\u0131\u011f\u0131 i\u00e7in a\u015fa\u011f\u0131daki \u00e7\u0131kt\u0131 servisin bulunmad\u0131\u011f\u0131n\u0131 g\u00f6steriyor; kurulu bir sunucuda ayn\u0131 komut servis ad\u0131n\u0131 ve <code>Running<\/code> durumunu listeler.<\/p>\n<pre><code class=\"language-powershell\">Get-Service -Name '*MySQL*'<\/code><\/pre>\n<p class=\"kb-cikti\">Test sunucumuzdaki ger\u00e7ek \u00e7\u0131kt\u0131: servis bulunamad\u0131 (MySQL kurulu de\u011fil). Kurulu bir sunucuda beklenen \u00e7\u0131kt\u0131: <code>Status Running, Name MySQL84<\/code>.<\/p>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Servis normal ba\u015flad\u0131ktan sonra <code>mysql -u root -p<\/code> ile ba\u011flan\u0131p yeni \u015fifrenizi girin; oturum a\u00e7\u0131l\u0131yorsa i\u015flem tamamlanm\u0131\u015ft\u0131r. <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/resetting-permissions.html\" title=\"MySQL k\u00f6k parolas\u0131n\u0131 s\u0131f\u0131rlama \u2014 MySQL 8.4 Reference Manual resmi dok\u00fcman\u0131\" target=\"_blank\" rel=\"noopener\">MySQL&#8217;in resmi dok\u00fcman\u0131na g\u00f6re<\/a> eski \u015fifre art\u0131k ge\u00e7ersizdir.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00c7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>mysqld ba\u015flarken &#8220;access denied&#8221; ya da benzer bir hata veriyor.<\/strong> Init dosyas\u0131n\u0131n yolu ya da i\u00e7eri\u011fi hatal\u0131 olabilir; dosyan\u0131n d\u00fcz metin oldu\u011funu ve tek sat\u0131r <code>ALTER USER<\/code> komutu i\u00e7erdi\u011fini kontrol edin.<\/li>\n<li><strong>Servis ad\u0131n\u0131 bulam\u0131yorsunuz.<\/strong><code>Get-Service *MySQL*<\/code> ile tam ad\u0131 g\u00f6r\u00fcn; MySQL Installer ile kurulduysa <code>mysqld<\/code> komutuna <code>--defaults-file<\/code> parametresini de eklemeniz gerekebilir.<\/li>\n<li><strong>Yeni \u015fifreyle h\u00e2l\u00e2 ba\u011flanam\u0131yorsunuz.<\/strong> Init dosyas\u0131n\u0131 sildi\u011finizden ve servisi normal modda yeniden ba\u015flatt\u0131\u011f\u0131n\u0131zdan emin olun; sunucu h\u00e2l\u00e2 init modundaysa yeni ba\u011flant\u0131lar\u0131 normal kabul etmez.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Talebe \u015funlar\u0131 ekleyin: sunucu ad\u0131, MySQL s\u00fcr\u00fcm\u00fc ve servis ad\u0131, denedi\u011finiz ad\u0131m, ald\u0131\u011f\u0131n\u0131z hata mesaj\u0131 birebir.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi olu\u015ftur\">Destek talebi a\u00e7<\/a><\/div>\n<div class=\"kb-ilgili\">\n<p class=\"label\">Sonraki ad\u0131mlar<\/p>\n<ul>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucu-rdp-yonetimi-rehberi\/\" title=\"Windows sunucu y\u00f6netimi rehberi \u2014 Narhost Destek\">Windows sunucu y\u00f6netimi kartlar\u0131n\u0131n tamam\u0131<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucuda-mssql-sql-server-kurulumu\/\" title=\"Windows sunucuda MSSQL SQL Server kurulumu \u2014 Narhost Destek\">Ayn\u0131 sunucuda MSSQL kurulumu<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/mssql-veritabani-olusturma-kullanici-yetkilendirme\/\" title=\"MSSQL veritaban\u0131 olu\u015fturma ve kullan\u0131c\u0131 yetkilendirme \u2014 Narhost Destek\">MSSQL veritaban\u0131 olu\u015fturma ve kullan\u0131c\u0131 yetkilendirme<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/windows-sunucuda-mssql-veri-yolu-degistirme\/\" title=\"Windows sunucuda MSSQL veri yolu de\u011fi\u015ftirme \u2014 Narhost Destek\">MSSQL veri yolu de\u011fi\u015ftirme<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a Sorulan Sorular<\/h2>\n<h3>Bu i\u015flem Linux sunucudakinden farkl\u0131 m\u0131?<\/h3>\n<p>Evet. Linux&#8217;ta <code>--skip-grant-tables<\/code> ile t\u00fcm yetki kontrol\u00fc kapat\u0131l\u0131r; Windows&#8217;ta MySQL&#8217;in resmi dok\u00fcman\u0131 <code>--init-file<\/code> y\u00f6ntemini \u00f6nerir ve komut sat\u0131r\u0131 yollar\u0131 (<code>bin<\/code> klas\u00f6r\u00fc, dosya yollar\u0131) Windows bi\u00e7imindedir.<\/p>\n<h3>MySQL Installer ile kurduysam bir fark var m\u0131?<\/h3>\n<p>Olabilir; bu durumda <code>mysqld<\/code> komutuna ek olarak <code>--defaults-file=\"C:\\ProgramData\\MySQL\\MySQL Server 8.4\\my.ini\"<\/code> parametresini de eklemeniz gerekir, yoksa sunucu do\u011fru yap\u0131land\u0131rma dosyas\u0131n\u0131 bulamaz.<\/p>\n<h3>Bu i\u015flem payla\u015f\u0131ml\u0131 Windows hostingde yap\u0131labilir mi?<\/h3>\n<p>Hay\u0131r. Bu ad\u0131mlar yaln\u0131zca kendi Windows Server&#8217;\u0131n\u0131z\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131 VPS veya VDS \u00fcr\u00fcnlerinde, kendi kurdu\u011funuz MySQL sunucusunda uygulan\u0131r; Narhost&#8217;un VPS\/VDS hatlar\u0131 y\u00f6netimsizdir.<\/p>\n<h3>\u0130nit dosyas\u0131n\u0131 silmeden servisi normal ba\u015flat\u0131rsam ne olur?<\/h3>\n<p>Sunucu her ba\u015flang\u0131\u00e7ta ayn\u0131 <code>ALTER USER<\/code> komutunu tekrar \u00e7al\u0131\u015ft\u0131rmaya kalkar; hatas\u0131z \u00e7al\u0131\u015fsa da gereksizdir, dosyay\u0131 silmek en temiz yoldur.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Windows sunucuda MySQL root \u015fifresi s\u0131f\u0131rlama: servisi durdurun, ALTER USER komutu i\u00e7eren bir init dosyas\u0131 olu\u015fturun, mysqld&#8217;yi bu dosyayla ba\u015flat\u0131n, dosyay\u0131 silip servisi normal ba\u015flat\u0131n.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,12],"tags":[],"class_list":["post-1988","post","type-post","status-publish","format-standard","hentry","category-windows-hosting","category-vds-server"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1988","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=1988"}],"version-history":[{"count":0,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1988\/revisions"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=1988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=1988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=1988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}