Ad\u0131m 4 \u2014 Root Parolas\u0131n\u0131 De\u011fi\u015ftirme<\/strong>
\nMySQL’in modern s\u00fcr\u00fcmleri i\u00e7in root parolas\u0131n\u0131 de\u011fi\u015ftirmenin basit bir yolu, komutu kullanmakt\u0131r ALTER USER. Ancak, grant tablolar\u0131 y\u00fcklenmedi\u011fi i\u00e7in bu komut \u015fu anda \u00e7al\u0131\u015fmaz.<\/p>\nKomutu vererek veritaban\u0131 sunucusuna grant tablolar\u0131n\u0131 yeniden y\u00fcklemesini s\u00f6yleyelim FLUSH PRIVILEGES.<\/p>\n
FLUSH PRIVILEGES;
\nArt\u0131k root \u015fifresini ger\u00e7ekten de\u011fi\u015ftirebiliriz.<\/p>\n
MySQL 5.7.6 ve daha yenisi ile MariaDB 10.1.20 ve daha yenisi i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131n.<\/p>\n
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;<\/p>\n
MySQL 5.7.5 ve daha eski s\u00fcr\u00fcmlerin yan\u0131 s\u0131ra MariaDB 10.1.20 ve daha eski s\u00fcr\u00fcmler i\u00e7in \u015funlar\u0131 kullan\u0131n:<\/p>\n
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘new_password’);<\/p>\n
new_passwordSe\u00e7ti\u011finiz yeni \u015fifrenizle de\u011fi\u015ftirdi\u011finizden emin olun .<\/p>\n
Not : ALTER USER Komut \u00e7al\u0131\u015fmazsa, bu genellikle daha b\u00fcy\u00fck bir sorunun g\u00f6stergesidir. UPDATE … SETAncak, bunun yerine root parolas\u0131n\u0131 s\u0131f\u0131rlamay\u0131 deneyebilirsiniz .<\/p>\n
UPDATE mysql.user SET authentication_string = PASSWORD(‘new_password’) WHERE User = ‘root’ AND Host = ‘localhost’;<\/p>\n
Bundan sonra hibe tablolar\u0131n\u0131 yeniden y\u00fcklemeyi unutmay\u0131n.<\/p>\n
Her iki durumda da, komutun ba\u015far\u0131yla y\u00fcr\u00fct\u00fcld\u00fc\u011f\u00fcne dair onay g\u00f6rmelisiniz.<\/p>\n
Output
\nQuery OK, 0 rows affected (0.00 sec)
\nParola de\u011fi\u015ftirildi, b\u00f6ylece art\u0131k veritaban\u0131 sunucusunun manuel \u00f6rne\u011fini durdurabilir ve eskisi gibi yeniden ba\u015flatabilirsiniz.<\/p>\n
Ad\u0131m 5 \u2014 Veritaban\u0131 Sunucusunu Normal Olarak Yeniden Ba\u015flat\u0131n<\/strong><\/p>\n\u00d6ncelikle, Ad\u0131m 3’te manuel olarak ba\u015flatt\u0131\u011f\u0131n\u0131z veritaban\u0131 sunucusu \u00f6rne\u011fini durdurun. Bu komut, MySQL veya MariaDB i\u015fleminin PID’sini veya i\u015flem kimli\u011fini arar ve temizleme i\u015flemlerini ger\u00e7ekle\u015ftirdikten sonra sorunsuz bir \u015fekilde \u00e7\u0131kmas\u0131n\u0131 s\u00f6ylemek i\u00e7in g\u00f6nderir SIGTERM. Bu Linux s\u00fcre\u00e7 y\u00f6netimi e\u011fitiminde daha fazla bilgi edinebilirsiniz .<\/p>\n
MySQL i\u00e7in \u015funlar\u0131 kullan\u0131n:<\/p>\n
sudo kill `cat \/var\/run\/mysqld\/mysqld.pid`
\nMariaDB i\u00e7in \u015funlar\u0131 kullan\u0131n:<\/p>\n
sudo kill `\/var\/run\/mariadb\/mariadb.pid`
\nArd\u0131ndan, kullanarak hizmeti yeniden ba\u015flat\u0131n systemctl.<\/p>\n
MySQL i\u00e7in \u015funlar\u0131 kullan\u0131n:<\/p>\n
sudo systemctl start mysql
\nMariaDB i\u00e7in \u015funlar\u0131 kullan\u0131n:<\/p>\n
sudo systemctl start mariadb
\n\u015eimdi a\u015fa\u011f\u0131dakileri \u00e7al\u0131\u015ft\u0131rarak yeni parolan\u0131n do\u011fru \u015fekilde uyguland\u0131\u011f\u0131n\u0131 onaylayabilirsiniz:<\/p>\n
mysql -u root -p
\nKomut \u015fimdi yeni atanan parolay\u0131 sormal\u0131d\u0131r. Girin ve beklendi\u011fi gibi veritaban\u0131 istemine eri\u015fmelisiniz.<\/p>\n
\u00c7\u00f6z\u00fcm
\nArt\u0131k geri y\u00fcklenen MySQL veya MariaDB sunucusuna y\u00f6netici eri\u015fiminiz var. Se\u00e7ti\u011finiz yeni k\u00f6k parolan\u0131n g\u00fc\u00e7l\u00fc ve g\u00fcvenli oldu\u011fundan emin olun ve g\u00fcvenli bir yerde saklay\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"
Giri\u015f Parolalar\u0131 unutmak \u00e7o\u011fumuzun ba\u015f\u0131na gelir. MySQL veya MariaDB veritaban\u0131n\u0131z\u0131n k\u00f6k parolas\u0131n\u0131 unutursan\u0131z veya kaybederseniz, sunucuya eri\u015fiminiz ve sudoetkinle\u015ftirilmi\u015f bir kullan\u0131c\u0131 hesab\u0131n\u0131z varsa yine de eri\u015fim kazanabilir ve parolay\u0131 s\u0131f\u0131rlayabilirsiniz. Bu e\u011fitici, MySQL ve MariaDB’nin eski ve yeni s\u00fcr\u00fcmleri i\u00e7in k\u00f6k parolan\u0131n nas\u0131l s\u0131f\u0131rlanaca\u011f\u0131n\u0131 kapsayacakt\u0131r. \u00d6nko\u015fullar K\u00f6k MySQL\/MariaDB parolan\u0131z\u0131 kurtarmak i\u00e7in ihtiyac\u0131n\u0131z olacak: Bir sudo …<\/p>\n","protected":false},"author":1,"featured_media":4230,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-5377","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\/5377","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=5377"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/5377\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/4230"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=5377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=5377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=5377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}