{"id":1626,"date":"2024-05-13T18:59:39","date_gmt":"2024-05-13T15:59:39","guid":{"rendered":"https:\/\/www.fibacloud.com\/community\/tutorials\/?p=1626"},"modified":"2026-09-20T21:55:54","modified_gmt":"2026-09-20T18:55:54","slug":"ubuntuda-mysql-veya-mariadb-root-kok-parolanizi-sifirlama","status":"publish","type":"post","link":"https:\/\/www.fibacloud.com\/community\/tutorials\/ubuntuda-mysql-veya-mariadb-root-kok-parolanizi-sifirlama\/","title":{"rendered":"Ubuntu\u2019da MySQL 8.4 ve MariaDB 10.11 root Parolas\u0131 S\u0131f\u0131rlama"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1626\" class=\"elementor elementor-1626\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d4a374d e-flex e-con-boxed e-con e-parent\" data-id=\"d4a374d\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fa8744e elementor-widget elementor-widget-text-editor\" data-id=\"fa8744e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 08-05-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Bu rehber Oracle MySQL 8.4 LTS ile MariaDB 10.11 LTS yollar\u0131n\u0131 ay\u0131r\u0131r. \u0130ki \u00fcr\u00fcn de yerel socket kimlik do\u011frulamas\u0131 kullanabildi\u011finden i\u015fletim sistemi y\u00f6neticisinin veritaban\u0131na parola olmadan eri\u015fimi zaten bulunabilir. Servisi durdurmadan \u00f6nce bunu kontrol edin. MySQL\u2019in acil kurtarma yolu resm\u00ee init-file y\u00f6ntemini kullan\u0131r; MariaDB\u2019nin acil yolu yaln\u0131z socket eri\u015fimi kald\u0131r\u0131lm\u0131\u015f, parola kullanan hesap i\u00e7indir. [S1, S4]<\/p>\n<p><strong>Do\u011frulama \u2014 20 Eyl\u00fcl 2026:<\/strong> Ubuntu 24.04 \u00fczerinde MySQL 8.4.11 ve MariaDB 10.11.14 ile kurtarma ak\u0131\u015flar\u0131 izole ortamda denendi. Ba\u015far\u0131l\u0131\/ba\u015far\u0131s\u0131z s\u0131f\u0131rlama, eski parolan\u0131n reddi, uygulama hesab\u0131\/verisinin korunmas\u0131, kurtarmada TCP dinleyicilerinin kapanmas\u0131 ve normal \u00e7al\u0131\u015fma kipine d\u00f6n\u00fc\u015f kontrol edildi. Boot, <code>systemctl<\/code> entegrasyonu ve etkin AppArmor politikas\u0131 s\u0131nanmad\u0131; \u00fcretimde kurtarma \u00f6ncesinde ayn\u0131 \u00f6zelliklerdeki test sunucusunda bunlar\u0131 do\u011frulay\u0131n.<\/p>\n<h2>Kapsam ve haz\u0131rl\u0131k<\/h2>\n<p>Komutlar Ubuntu 24.04 \u00fczerinde paketle y\u00f6netilen, standart <code>\/var\/lib\/mysql<\/code>, <code>\/run\/mysqld\/mysqld.sock<\/code> ve <code>\/usr\/sbin\/mysqld<\/code> veya <code>\/usr\/sbin\/mariadbd<\/code> yollar\u0131n\u0131 kullanan tek sunucuyu hedefler. Veritaban\u0131 s\u00fcr\u00fcm\u00fcn\u00fc y\u00fckseltmez. MySQL 8.4 ayr\u0131 bir \u00fcr\u00fcn\/s\u00fcr\u00fcm se\u00e7imidir; Ubuntu\u2019nun varsay\u0131lan MySQL paketinin 8.4 oldu\u011funu varsaymay\u0131n. Komutlar\u0131 container, y\u00f6netilen veritaban\u0131, \u00f6zel veri dizini, \u00e7oklu instance, replikasyon veya Galera k\u00fcmesine de\u011fi\u015ftirmeden uygulamay\u0131n.<\/p>\n<p>Ba\u015flamadan \u00f6nce:<\/p>\n<ul>\n<li>Sudo yetkili mevcut SSH hesab\u0131n\u0131z\u0131 kullan\u0131n; ikinci y\u00f6netici terminali veya sa\u011flay\u0131c\u0131 konsolu a\u00e7\u0131k kals\u0131n. Linux root ile veritaban\u0131 root farkl\u0131 hesaplard\u0131r.<\/li>\n<li>Acil kurtarma gerekiyorsa uygulama i\u00e7in bak\u0131m kesintisi planlay\u0131n. Do\u011frulanm\u0131\u015f yedek veya uygulama tutarl\u0131 snapshot ve geri y\u00fckleme yordam\u0131n\u0131z bulunsun.<\/li>\n<li>Sunucu program\u0131n\u0131, s\u00fcr\u00fcm\u00fc, servis yap\u0131land\u0131rmas\u0131n\u0131 ve mevcut veri dizinini do\u011frulay\u0131n. Parola s\u0131f\u0131rlamak i\u00e7in <code>--initialize<\/code>, <code>mariadb-install-db<\/code> \u00e7al\u0131\u015ft\u0131rmay\u0131n; veri dizinini silmeyin veya ba\u015fka veritaban\u0131 s\u00fcr\u00fcm\u00fc kurmay\u0131n.<\/li>\n<li>Parola y\u00f6neticisinden uzun, benzersiz yeni parola \u00fcretin. B\u00fct\u00fcn parola yer tutucular\u0131n\u0131 de\u011fi\u015ftirin. \u00d6rnekler \u00fcretilen parolada tek t\u0131rnak veya ters e\u011fik \u00e7izgi bulunmad\u0131\u011f\u0131n\u0131 varsayar; bunlar varsa sunucunun belgelenmi\u015f SQL ka\u00e7\u0131\u015f kurallar\u0131n\u0131 uygulay\u0131n. Parolay\u0131 kabukta <code>-p<\/code> arg\u00fcman\u0131n\u0131n sonuna, ekran g\u00f6r\u00fcnt\u00fcs\u00fcne veya destek kayd\u0131na yazmay\u0131n.<\/li>\n<li>G\u00fcvenilmeyen yerel kullan\u0131c\u0131 veya i\u015f y\u00fckleri sunucuya eri\u015febiliyorsa MariaDB yetki denetimini atlayan kurtarma yolu uygun de\u011fildir; izole bak\u0131m ortam\u0131 kullan\u0131n. TCP\u2019yi kapatmak yerel Unix socket\u2019i tek ba\u015f\u0131na korumaz.<\/li>\n<\/ul>\n<p>Yaln\u0131z kurulu \u00fcr\u00fcn\u00fc kontrol edin:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c21a1f elementor-widget elementor-widget-text-editor\" data-id=\"2c21a1f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\"># Oracle MySQL\nmysqld --version\nsudo systemctl cat mysql\n\n# MariaDB\nmariadbd --version\nsudo systemctl cat mariadb<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55a4d96 elementor-widget elementor-widget-text-editor\" data-id=\"55a4d96\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Servis a\u015fa\u011f\u0131daki elle ba\u015flat\u0131lan kurtarma s\u00fcreciyle ayn\u0131 varsay\u0131lan yap\u0131land\u0131rmay\u0131 ve mevcut veri dizinini kullanmal\u0131d\u0131r. ExecStart \u00f6zel defaults dosyas\u0131 veya instance ayarlar\u0131 i\u00e7eriyorsa durun ve yordam\u0131 y\u00f6neticinizle uyarlay\u0131n. MySQL\u2019in systemd paketleri mysqld_safe program\u0131n\u0131 i\u00e7ermek zorunda de\u011fildir; bu rehber sunucu program\u0131n\u0131 do\u011frudan ba\u015flat\u0131r. [S2]<\/p>\n\n<figure class=\"fc-editorial-figure\" data-fc-visual=\"20260920\" aria-labelledby=\"fc-editorial-caption-1626\"><a href=\"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-content\/uploads\/community-editorial-20260920\/fc-recovery-tr-inline-20260920.webp\" target=\"_blank\" rel=\"noopener\" aria-label=\"G\u00f6rseli tam boyutta a\u00e7\"><picture><source media=\"(max-width: 600px)\" srcset=\"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-content\/uploads\/community-editorial-20260920\/fc-recovery-tr-mobile-20260920.webp\" width=\"720\" height=\"1140\"><img loading=\"lazy\" src=\"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-content\/uploads\/community-editorial-20260920\/fc-recovery-tr-inline-20260920.webp\" srcset=\"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-content\/uploads\/community-editorial-20260920\/fc-recovery-tr-inline-20260920.webp 1440w, https:\/\/www.fibacloud.com\/community\/tutorials\/wp-content\/uploads\/community-editorial-20260920\/fc-recovery-tr-inline-20260920-300x242.webp 300w, https:\/\/www.fibacloud.com\/community\/tutorials\/wp-content\/uploads\/community-editorial-20260920\/fc-recovery-tr-inline-20260920-1024x825.webp 1024w, https:\/\/www.fibacloud.com\/community\/tutorials\/wp-content\/uploads\/community-editorial-20260920\/fc-recovery-tr-inline-20260920-768x619.webp 768w\" sizes=\"auto, (max-width: 900px) 100vw, 820px\" width=\"1440\" height=\"1160\" alt=\"Eri\u015fim kurtarmada karar s\u0131ras\u0131\" class=\"wp-image-2527\"  decoding=\"async\"><\/picture><\/a><figcaption id=\"fc-editorial-caption-1626\"><strong>Eri\u015fim kurtarmada karar s\u0131ras\u0131<\/strong> \u00d6nce mevcut yetkili eri\u015fim denenir. Acil kurtarma gerekiyorsa bak\u0131m penceresi ve yedek haz\u0131rlan\u0131r; normal kimlik do\u011frulamas\u0131 geri a\u00e7\u0131lmadan i\u015flem tamamlanm\u0131\u015f say\u0131lmaz.<details><summary>G\u00f6rselin ad\u0131m ad\u0131m a\u00e7\u0131klamas\u0131<\/summary><ol><li>Kontrol et: Mevcut yetkili eri\u015fimi dene.<\/li><li>Haz\u0131rla: Yedek ve bak\u0131m penceresi olu\u015ftur.<\/li><li>Kurtar: \u00dcr\u00fcn ve s\u00fcr\u00fcme uygun prosed\u00fcr\u00fc uygula.<\/li><li>Do\u011frula: Normal kimlik do\u011frulamas\u0131n\u0131 geri a\u00e7.<\/li><\/ol><\/details><\/figcaption><\/figure>\n<h2>1. \u00d6nce mevcut yerel y\u00f6netici eri\u015fimini deneyin<\/h2>\n<p>MySQL i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-557f575 elementor-widget elementor-widget-text-editor\" data-id=\"557f575\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo env MYSQL_HISTFILE=\/dev\/null mysql --no-defaults --protocol=socket --socket=\/run\/mysqld\/mysqld.sock --user=root<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c95c6a0 elementor-widget elementor-widget-text-editor\" data-id=\"c95c6a0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MariaDB i\u00e7in:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-26379d8 elementor-widget elementor-widget-text-editor\" data-id=\"26379d8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo env MYSQL_HISTFILE=\/dev\/null mariadb --no-defaults --protocol=socket --socket=\/run\/mysqld\/mysqld.sock --user=root<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3033dcc elementor-widget elementor-widget-text-editor\" data-id=\"3033dcc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Ba\u011flant\u0131 kurulursa hesab\u0131 yerel olarak inceleyin. SHOW CREATE USER parola \u00f6zeti i\u00e7erebilir; \u00e7\u0131kt\u0131s\u0131n\u0131 payla\u015fmay\u0131n.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4dd8c3f elementor-widget elementor-widget-text-editor\" data-id=\"4dd8c3f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">SELECT VERSION(), CURRENT_USER();\nSHOW CREATE USER 'root'@'localhost';<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-26480a7 elementor-widget elementor-widget-text-editor\" data-id=\"26480a7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><code>CURRENT_USER()<\/code> sonucunun <code>root@localhost<\/code> oldu\u011funu do\u011frulay\u0131n; tahminle ba\u015fka hesab\u0131 de\u011fi\u015ftirmeyin.<\/p>\n<ul>\n<li><strong>MySQL auth_socket:<\/strong> sudo ile ba\u015far\u0131l\u0131 eri\u015fim ama\u00e7lanan kimlik do\u011frulama y\u00f6ntemidir; kurtar\u0131lacak veritaban\u0131 parolas\u0131 bulunmayabilir. Bilin\u00e7li hesap politikas\u0131 de\u011fi\u015fikli\u011fi gerekmedik\u00e7e socket y\u00f6ntemini koruyun; bu de\u011fi\u015fiklik kurtarma yordam\u0131n\u0131n kapsam\u0131 d\u0131\u015f\u0131ndad\u0131r.<\/li>\n<li><strong>MySQL parola eklentisi ve zaten yetkili oturum:<\/strong> a\u015fa\u011f\u0131daki <code>ALTER USER<\/code> komutunu kullan\u0131n, yeni parolay\u0131 ayr\u0131 terminalde do\u011frulay\u0131n. Acil yeniden ba\u015flatma gerekmez.<\/li>\n<li><strong>MariaDB yaln\u0131z unix_socket:<\/strong> sudo kullanmaya devam edin; socket-only hesaba parola atamak parola s\u0131f\u0131rlama de\u011fildir ve reddedilebilir\/yok say\u0131labilir.<\/li>\n<li><strong>MariaDB unix_socket OR mysql_native_password:<\/strong> a\u015fa\u011f\u0131daki SET PASSWORD, socket eri\u015fimini korurken parola alternatifini etkinle\u015ftirir veya de\u011fi\u015ftirir. Modern kurulumlarda bu yap\u0131 yayg\u0131nd\u0131r; yine de hesap tan\u0131m\u0131n\u0131 do\u011frulay\u0131n. [S4, S5]<\/li>\n<\/ul>\n<p>Yaln\u0131z MySQL:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-13fb4ec elementor-widget elementor-widget-text-editor\" data-id=\"13fb4ec\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">ALTER USER 'root'@'localhost' IDENTIFIED BY 'REPLACE_WITH_A_LONG_UNIQUE_PASSWORD';<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8858cc elementor-widget elementor-widget-text-editor\" data-id=\"a8858cc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Yaln\u0131z MariaDB; hesap parola destekleyen kimlik do\u011frulama y\u00f6ntemi i\u00e7eriyorsa:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-503f340 elementor-widget elementor-widget-text-editor\" data-id=\"503f340\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">SET PASSWORD FOR 'root'@'localhost' = PASSWORD('REPLACE_WITH_A_LONG_UNIQUE_PASSWORD');<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d84abe elementor-widget elementor-widget-text-editor\" data-id=\"8d84abe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><code>PASSWORD()<\/code> bu MariaDB ifadesinde ge\u00e7erlidir; MySQL 8.0\u2019da kald\u0131r\u0131lm\u0131\u015ft\u0131r. Bu MariaDB komutunu MySQL\u2019de \u00e7al\u0131\u015ft\u0131rmay\u0131n. \u0130ki \u00fcr\u00fcnde de mysql.user tablosuna do\u011frudan UPDATE gerekmez. [S3, S5]<\/p>\n<p>Yetkili bir veritaban\u0131 oturumu yoksa a\u015fa\u011f\u0131daki acil kollardan yaln\u0131z birini se\u00e7in.<\/p>\n<h2>2. MySQL 8.4: init dosyas\u0131yla kurtarma<\/h2>\n<p>Bu y\u00f6ntem normal yetki denetimi a\u00e7\u0131kken ba\u015flang\u0131\u00e7ta tek hesap y\u00f6netimi komutu \u00e7al\u0131\u015ft\u0131r\u0131r. Bak\u0131m ba\u015flang\u0131c\u0131nda a\u011f dinleyicileri kapat\u0131l\u0131r. Yetki denetimini t\u00fcm\u00fcyle kapatmaktan daha uygun yoldur. [S1]<\/p>\n<p>Normal servisi durdurun. <code>is-active<\/code>, <code>inactive<\/code> yazmal\u0131d\u0131r; bu durumda s\u0131f\u0131rdan farkl\u0131 \u00e7\u0131k\u0131\u015f kodu normaldir. Tek instance kapsam\u0131ndaki <code>pgrep<\/code> ba\u015fka mysqld s\u00fcreci bulmamal\u0131d\u0131r. Ayn\u0131 veri dizininde ikinci sunucu ba\u015flatmay\u0131n.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bcc66df elementor-widget elementor-widget-text-editor\" data-id=\"bcc66df\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo systemctl stop mysql\nsudo systemctl is-active mysql\npgrep -a -x mysqld<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24b1253 elementor-widget elementor-widget-text-editor\" data-id=\"24b1253\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Mysql i\u015fletim sistemi kullan\u0131c\u0131s\u0131n\u0131n okuyabilece\u011fi k\u0131s\u0131tl\u0131 dosyay\u0131 haz\u0131rlay\u0131n. Kabuk noclobber ile 600 izinli yeni dosya olu\u015fturur; bu ad zaten varsa i\u015flem ba\u015far\u0131s\u0131z olur ve d\u00fczenleyici a\u00e7\u0131lmaz. \u00dczerine yazmaya \u00e7al\u0131\u015fmadan durup inceleyin. Mysql-files dizini Ubuntu paketi i\u00e7in ama\u00e7lanan aday yoldur; kurulu AppArmor politikas\u0131n\u0131n okumaya izin verdi\u011fini do\u011frulay\u0131n. Kurtarmay\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in AppArmor\u2019u kapatmay\u0131n.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d605d9 elementor-widget elementor-widget-text-editor\" data-id=\"3d605d9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo install -d -o mysql -g mysql -m 750 \/var\/lib\/mysql-files\nsudo -u mysql sh -c 'set -C; umask 077; : &gt; \/var\/lib\/mysql-files\/fc-root-reset.sql' &amp;&amp; sudoedit \/var\/lib\/mysql-files\/fc-root-reset.sql<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b3ef069 elementor-widget elementor-widget-text-editor\" data-id=\"b3ef069\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Dosyaya yeni parolan\u0131zla yaln\u0131z \u015fu ifadeyi koyun. Host b\u00f6l\u00fcm\u00fc dahil tam hesab\u0131 hedefler. Ge\u00e7ici \u00e7\u00f6z\u00fcm olarak kimlik do\u011frulama eklentisini mysql_native_password yapmay\u0131n.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b579eb2 elementor-widget elementor-widget-text-editor\" data-id=\"b579eb2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">ALTER USER 'root'@'localhost' IDENTIFIED BY 'REPLACE_WITH_A_LONG_UNIQUE_PASSWORD';<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3e2977 elementor-widget elementor-widget-text-editor\" data-id=\"d3e2977\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A terminalinde ayn\u0131 mevcut veritaban\u0131n\u0131 \u00f6n planda ba\u015flat\u0131n; terminal a\u00e7\u0131k kals\u0131n. Program normal se\u00e7enek dosyalar\u0131n\u0131 okur; a\u015fa\u011f\u0131daki a\u00e7\u0131k se\u00e7enekler bu bak\u0131m ba\u015flang\u0131c\u0131n\u0131 k\u0131s\u0131tlar. Ba\u015flatma sonlan\u0131r veya hata yazarsa ikinci s\u00fcre\u00e7 ba\u015flatmak yerine hata\/temizleme b\u00f6l\u00fcm\u00fcne ge\u00e7in.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03ee702 elementor-widget elementor-widget-text-editor\" data-id=\"03ee702\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo install -d -o mysql -g mysql -m 755 \/run\/mysqld\nsudo \/usr\/sbin\/mysqld --user=mysql --datadir=\/var\/lib\/mysql --socket=\/run\/mysqld\/mysqld.sock --pid-file=\/run\/mysqld\/mysqld.pid --init-file=\/var\/lib\/mysql-files\/fc-root-reset.sql --skip-networking --mysqlx=OFF<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0889d99 elementor-widget elementor-widget-text-editor\" data-id=\"0889d99\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>B terminalinde istem geldi\u011finde yeni parolay\u0131 girin. Sunucunun \u201cready\u201d olmas\u0131 init komutunun ba\u015far\u0131l\u0131 oldu\u011funu kan\u0131tlamaz; zay\u0131f parola veya yanl\u0131\u015f hesap ALTER USER hatas\u0131 do\u011furabilir. Yeni parolayla ba\u015far\u0131l\u0131 kimlik do\u011frulama zorunludur.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-22a0e51 elementor-widget elementor-widget-text-editor\" data-id=\"22a0e51\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">env MYSQL_HISTFILE=\/dev\/null mysql --no-defaults --protocol=socket --socket=\/run\/mysqld\/mysqld.sock --user=root --password<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86c83ff elementor-widget elementor-widget-text-editor\" data-id=\"86c83ff\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Hesab\u0131, s\u00fcr\u00fcm\u00fc ve TCP a\u011f\u0131n\u0131n kapal\u0131 oldu\u011funu do\u011frulay\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-156a131 elementor-widget elementor-widget-text-editor\" data-id=\"156a131\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">SELECT CURRENT_USER(), VERSION(), @@skip_networking;<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a5258f elementor-widget elementor-widget-text-editor\" data-id=\"2a5258f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Root@localhost, MySQL 8.4 ve skip_networking = 1 beklenir. <code>sudo ss -ltnp<\/code> \u00e7\u0131kt\u0131s\u0131n\u0131 da inceleyin: kurtarma veritaban\u0131 s\u00fcreci, y\u00f6netim veya X Plugin dinleyicisi d\u00e2hil hi\u00e7bir TCP portunu dinlememelidir. Dinleyici varsa s\u00fcreci kapat\u0131p yap\u0131land\u0131rmay\u0131 d\u00fczeltmeden ilerlemeyin. Yetkili eri\u015fimi do\u011frulay\u0131n. B terminalinde SQL istemcisinden <code>exit<\/code> ile \u00e7\u0131k\u0131n; sunucu \u00e7al\u0131\u015fmaya devam eder. Yeni parola do\u011frulan\u0131r do\u011frulanmaz kabuktan a\u00e7\u0131k parolal\u0131 init dosyas\u0131n\u0131 silin; ard\u0131ndan yeni parolayla kurtarma sunucusunu kapat\u0131n. Bu shutdown i\u015flemi, istemciden \u00e7\u0131kman\u0131n aksine sunucu s\u00fcrecini durdurur.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f55386e elementor-widget elementor-widget-text-editor\" data-id=\"f55386e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo rm -- \/var\/lib\/mysql-files\/fc-root-reset.sql\nmysqladmin --no-defaults --protocol=socket --socket=\/run\/mysqld\/mysqld.sock --user=root --password shutdown<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12ec224 elementor-widget elementor-widget-text-editor\" data-id=\"12ec224\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A terminali komut istemine d\u00f6nmelidir. Normal servisi ba\u015flatmadan \u00f6nce kurtarma s\u00fcrecinin kalmad\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d7c1ae elementor-widget elementor-widget-text-editor\" data-id=\"8d7c1ae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">pgrep -a -x mysqld\nsudo systemctl start mysql\nsudo systemctl is-active mysql<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-044f4b6 elementor-widget elementor-widget-text-editor\" data-id=\"044f4b6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2>3. MariaDB 10.11: yaln\u0131z socket eri\u015fimi yoksa acil kurtarma<\/h2>\n<p>Sudo\/socket eri\u015fimi \u00e7al\u0131\u015f\u0131yorsa 1. b\u00f6l\u00fcm\u00fc kullan\u0131n. Bu kol root@localhost hesab\u0131n\u0131n parola destekleyen y\u00f6ntem kulland\u0131\u011f\u0131n\u0131 ve yetkili oturum kalmad\u0131\u011f\u0131n\u0131 varsayar. Hesap denetimini ge\u00e7ici kapat\u0131r; yaln\u0131z g\u00fcvenilir yerel bak\u0131m eri\u015fimi gerekir. [S4]<\/p>\n<p>Servisi durdurup eski sunucunun kalmad\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n. Ard\u0131ndan A terminalinde mevcut veritaban\u0131n\u0131 TCP a\u011f\u0131 kapal\u0131 ba\u015flat\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14a12ff elementor-widget elementor-widget-text-editor\" data-id=\"14a12ff\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo systemctl stop mariadb\nsudo systemctl is-active mariadb\npgrep -a -x mariadbd\npgrep -a -x mysqld\nsudo install -d -o mysql -g mysql -m 755 \/run\/mysqld\nsudo \/usr\/sbin\/mariadbd --user=mysql --datadir=\/var\/lib\/mysql --socket=\/run\/mysqld\/mysqld.sock --pid-file=\/run\/mysqld\/mysqld.pid --skip-grant-tables --skip-networking<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d0b454 elementor-widget elementor-widget-text-editor\" data-id=\"3d0b454\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A terminali a\u00e7\u0131k kals\u0131n. B terminalinden veritaban\u0131 parolas\u0131 olmadan ba\u011flan\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f00fa5b elementor-widget elementor-widget-text-editor\" data-id=\"f00fa5b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">sudo env MYSQL_HISTFILE=\/dev\/null mariadb --no-defaults --protocol=socket --socket=\/run\/mysqld\/mysqld.sock --user=root<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-331c996 elementor-widget elementor-widget-text-editor\" data-id=\"331c996\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Sunucuyu ve tam root hesab\u0131n\u0131 kontrol edin. Beklenen s\u00fcr\u00fcm 10.11 ile ba\u015flar; skip_networking 1\u2019dir. <code>sudo ss -ltnp<\/code> \u00e7\u0131kt\u0131s\u0131nda kurtarma veritaban\u0131 s\u00fcrecinin hi\u00e7bir TCP portunu dinlemedi\u011fini do\u011frulay\u0131n; dinleyici varsa kurtarmay\u0131 durdurun. Ard\u0131ndan SET PASSWORD komutundan <strong>\u00f6nce<\/strong> yetkileri yeniden y\u00fckleyin. Bu MariaDB kurtarma yolunda s\u0131ra \u00f6nemlidir; eski \u201cFLUSH en sonda\u201d re\u00e7etesi ge\u00e7erli de\u011fildir. [S4]<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4f2423 elementor-widget elementor-widget-text-editor\" data-id=\"d4f2423\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">SELECT VERSION(), @@skip_networking;\nSELECT User, Host FROM mysql.user WHERE User = 'root';\nFLUSH PRIVILEGES;\nSHOW CREATE USER 'root'@'localhost';<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86109de elementor-widget elementor-widget-text-editor\" data-id=\"86109de\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Mevcut parola destekleyen kimlik do\u011frulama y\u00f6ntemini do\u011frulay\u0131n; var olan socket y\u00f6ntemini kald\u0131rmay\u0131n veya de\u011fi\u015ftirmeyin. Kapsamdaki mysql_native_password hesab\u0131 i\u00e7in \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5aedc11 elementor-widget elementor-widget-text-editor\" data-id=\"5aedc11\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">SET PASSWORD FOR 'root'@'localhost' = PASSWORD('REPLACE_WITH_A_LONG_UNIQUE_PASSWORD');<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c21fd32 elementor-widget elementor-widget-text-editor\" data-id=\"c21fd32\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Hesap socket-only veya harici\/\u00f6zel eklenti kulland\u0131\u011f\u0131 i\u00e7in SET PASSWORD reddedilirse durun; mysql.user veya mysql.global_priv tablosunu do\u011frudan g\u00fcncellemeyin. \u0130lgili eklentinin y\u00f6netim yordam\u0131n\u0131 izleyin.<\/p>\n<p>H\u00e2l\u00e2 yetkili olan SQL oturumundan kurtarma sunucusunu kapat\u0131n. Yaln\u0131z EXIT yap\u0131p systemd ba\u015flatmay\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03344ad elementor-widget elementor-widget-text-editor\" data-id=\"03344ad\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">SHUTDOWN;<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-768ff20 elementor-widget elementor-widget-text-editor\" data-id=\"768ff20\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A terminali d\u00f6nd\u00fc\u011f\u00fcnde ve kurtarma s\u00fcreci kalmad\u0131\u011f\u0131nda normal ba\u015flat\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a18b430 elementor-widget elementor-widget-text-editor\" data-id=\"a18b430\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\">pgrep -a -x mariadbd\npgrep -a -x mysqld\nsudo systemctl start mariadb\nsudo systemctl is-active mariadb<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41c1a78 elementor-widget elementor-widget-text-editor\" data-id=\"41c1a78\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2>4. Normal \u00e7al\u0131\u015fmay\u0131 do\u011frulay\u0131n<\/h2>\n<p>Parola destekleyen hesaba root olmayan i\u015fletim sistemi hesab\u0131ndan ba\u011flan\u0131p istemde yeni parolay\u0131 girin. MariaDB \u00e7ift kimlik do\u011frulamas\u0131nda bu \u00f6nemlidir: sudo ba\u011flant\u0131s\u0131, parola yanl\u0131\u015f olsa bile unix_socket \u00fczerinden ba\u015far\u0131l\u0131 olabilir. Eski parolay\u0131 ayr\u0131 deneyin ve reddedilmesini bekleyin. Socket-only hesaplar i\u00e7in belgelenmi\u015f sudo eri\u015fimi korunmal\u0131d\u0131r; bu hesaplara yapay parola testi uygulamay\u0131n.<\/p>\n<p>Kurulu \u00fcr\u00fcn\u00fcn istemcisini kullan\u0131n:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-625888a elementor-widget elementor-widget-text-editor\" data-id=\"625888a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-bash\"># Oracle MySQL\nenv MYSQL_HISTFILE=\/dev\/null mysql --no-defaults --protocol=socket --socket=\/run\/mysqld\/mysqld.sock --user=root --password\n\n# MariaDB\nenv MYSQL_HISTFILE=\/dev\/null mariadb --no-defaults --protocol=socket --socket=\/run\/mysqld\/mysqld.sock --user=root --password<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a5facf9 elementor-widget elementor-widget-text-editor\" data-id=\"a5facf9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Kurtarma se\u00e7eneklerini kontrol edin; a\u011f\u0131 bak\u0131m \u00f6ncesi belgelenmi\u015f yap\u0131land\u0131rmayla kar\u015f\u0131la\u015ft\u0131r\u0131n. Bilin\u00e7li socket-only kurulum normalde skip_networking ON kullanabilir; \u00f6rne\u011fe uymak i\u00e7in TCP a\u00e7may\u0131n.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7865ae5 elementor-widget elementor-widget-text-editor\" data-id=\"7865ae5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre><code class=\"language-sql\">SELECT CURRENT_USER(), VERSION();\nSHOW VARIABLES WHERE Variable_name IN ('skip_grant_tables', 'skip_networking', 'init_file');<\/code><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae6b31a elementor-widget elementor-widget-text-editor\" data-id=\"ae6b31a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul>\n<li>Yetki denetimini atlama kapal\u0131 olmal\u0131d\u0131r. MySQL init-file kolunda init_file bo\u015f, kurtarma SQL dosyas\u0131 silinmi\u015f olmal\u0131d\u0131r.<\/li>\n<li>Uygulama kendi mevcut veritaban\u0131 hesab\u0131yla ba\u011flanmal\u0131d\u0131r; zarars\u0131z bir okuma ve normal sa\u011fl\u0131k kontrol\u00fcn\u00fc do\u011frulay\u0131n. Verileri ve yetkileri de\u011fi\u015fmemi\u015f olmal\u0131d\u0131r. Uygulama ba\u011flant\u0131s\u0131n\u0131 root yapmay\u0131n.<\/li>\n<li>MariaDB ba\u015flang\u0131\u00e7ta socket kimlik do\u011frulamas\u0131 kullan\u0131yorsa sudo eri\u015fimini ve hesap tan\u0131m\u0131n\u0131n korundu\u011funu do\u011frulay\u0131n.<\/li>\n<li>Bak\u0131m penceresinde kontroll\u00fc servis yeniden ba\u015flatmas\u0131 yap\u0131p kimlik do\u011frulama ve uygulama kontrollerini tekrarlay\u0131n.<\/li>\n<\/ul>\n<h2>Bir ad\u0131m ba\u015far\u0131s\u0131z olursa<\/h2>\n<p>Uygulama trafi\u011fini duraklat\u0131lm\u0131\u015f tutun. Yerel sunucu hata kayd\u0131n\u0131 inceleyin; parola, parola \u00f6zeti veya init dosyas\u0131 payla\u015fmay\u0131n. Kurtarma s\u00fcreci \u00e7al\u0131\u015f\u0131yor ve normal yetkili shutdown m\u00fcmk\u00fcn de\u011filse yap\u0131land\u0131r\u0131lm\u0131\u015f pid dosyas\u0131ndan tam kurtarma PID\u2019sini al\u0131n, komutunu ve sahibini do\u011frulay\u0131n ve yaln\u0131z bu s\u00fcrece SIGTERM g\u00f6nderin. Geni\u015f pkill komutlar\u0131 veya SIGKILL kullanmay\u0131n. Eski servisi ba\u015flatmadan s\u00fcrecin durmas\u0131n\u0131 bekleyin.<\/p>\n<p>MySQL\u2019de ALTER USER ba\u015far\u0131s\u0131z olsa da ge\u00e7ici init dosyas\u0131n\u0131 kald\u0131r\u0131n ve kurtarma se\u00e7enekleri olmadan ba\u015flat\u0131n. ALTER USER ba\u015far\u0131s\u0131z oldu\u011funda eski parola h\u00e2l\u00e2 ge\u00e7erli olabilir; s\u0131f\u0131rland\u0131\u011f\u0131n\u0131 varsaymadan do\u011frulay\u0131n. MariaDB\u2019de SET PASSWORD ba\u015far\u0131s\u0131z olsa da yetki denetimsiz s\u00fcreci kapat\u0131p normal yap\u0131land\u0131rmayla ba\u015flat\u0131n. Korumas\u0131z kurtarma s\u00fcrecini \u00e7al\u0131\u015f\u0131r b\u0131rakmay\u0131n. Veri dizinini geli\u015fig\u00fczel geri y\u00fcklemeyin; veri kurtarma gerekiyorsa \u00f6nceden do\u011frulanm\u0131\u015f yordam\u0131 kullan\u0131n.<\/p>\n<h2>Resm\u00ee kaynaklar<\/h2>\n<ul>\n<li>[S1] <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/resetting-permissions.html\" rel=\"nofollow noopener\" target=\"_blank\">MySQL 8.4 \u2014 Resetting the Root Password<\/a><\/li>\n<li>[S2] <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/using-systemd.html\" rel=\"nofollow noopener\" target=\"_blank\">MySQL 8.4 \u2014 Managing MySQL Server with systemd<\/a><\/li>\n<li>[S3] <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/mysql-nutshell.html\" rel=\"nofollow noopener\" target=\"_blank\">MySQL 8.0 \u2014 Removed Features: PASSWORD()<\/a><\/li>\n<li>[S4] <a href=\"https:\/\/mariadb.com\/docs\/server\/security\/user-account-management\/authentication-from-mariadb-10-4\" rel=\"nofollow noopener\" target=\"_blank\">MariaDB \u2014 Authentication from MariaDB 10.4<\/a><\/li>\n<li>[S5] <a href=\"https:\/\/mariadb.com\/docs\/server\/reference\/sql-statements\/account-management-sql-statements\/set-password\" rel=\"nofollow noopener\" target=\"_blank\">MariaDB \u2014 SET PASSWORD<\/a><\/li>\n<li>[S6] <a href=\"https:\/\/mariadb.org\/about\/#maintenance-policy\" rel=\"nofollow noopener\" target=\"_blank\">MariaDB Foundation \u2014 Maintenance policy<\/a><\/li>\n<li>[S7] <a href=\"https:\/\/mariadb.com\/docs\/server\/server-management\/starting-and-stopping-mariadb\/mariadbd-options\" rel=\"nofollow noopener\" target=\"_blank\">MariaDB \u2014 mariadbd options<\/a><\/li>\n<\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>MySQL 8.4 ve MariaDB 10.11 i\u00e7in ayr\u0131 kurtarma ad\u0131mlar\u0131: socket eri\u015fimi, ge\u00e7ici dosya, g\u00fcvenli kapatma ve parola do\u011frulamas\u0131.<\/p>\n","protected":false},"author":1,"featured_media":2526,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1626","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"lang":"tr","translations":{"tr":1626,"en":2324},"pll_sync_post":[],"_links":{"self":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts\/1626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/comments?post=1626"}],"version-history":[{"count":89,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts\/1626\/revisions"}],"predecessor-version":[{"id":1716,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/posts\/1626\/revisions\/1716"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/media\/2526"}],"wp:attachment":[{"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/media?parent=1626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/categories?post=1626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fibacloud.com\/community\/tutorials\/wp-json\/wp\/v2\/tags?post=1626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}