Otu esi tọgharịa paswọọdụ Admin WordPress site na MySQL Command ozugbo

Mgbe ụfọdụ, onye ọrụ WordPress, nke nwere otu ikike ndị a, dị ka onye nchịkwa, onye nchịkọta akụkọ, onye ode akwụkwọ, onye ntinye aka, ma ọ bụ onye debanyere aha, na-echefu nzere nbanye ya, ọkachasị paswọọdụ.

Enwere ike ịgbanwe paswọọdụ WordPress n'ụzọ dị mfe site na ụdị nbanye WordPress Password Lost Otú ọ dị, ọ bụrụ na akaụntụ WordPress enweghị ụzọ isi nweta adreesị email ya, ịgbanwe paswọọdụ site na iji usoro a nwere ike ọ gaghị ekwe omume. N'ọnọdụ ndị dị otú ahụ, ọrụ nke imelite a Enwere ike ijikwa paswọọdụ akaụntụ WordPress naanị site na onye nchịkwa sistemụ nwere ohere zuru oke na MySQL nchekwa data daemon.

N'ime ntuziaka a, anyị ga-egosi gị otu esi tọgharịa paswọọdụ akaụntụ WordPress site na ahịrị iwu MySQL na Linux.

Tupu ịbanye na MySQL/MariaDB nchekwa data ọrụ, buru ụzọ mepụta ụdị MD5 Hash nke paswọọdụ ọhụrụ nke a ga-ekenye na akaụntụ ahụ, site na ịnye iwu dị n'okpuru.

Jiri okwuntughe siri ike nke gị dochie eriri “Newpass” ejiri na ihe atụ a. Detuo paswọọdụ MD5 hash na faịlụ ka ị mechaa mado hash na mpaghara paswọọdụ onye ọrụ MySQL.

# echo -n "newpass" | md5sum

Mgbe ịmechara paswọọdụ ọhụrụ MD5 hash, banye na MySQL nchekwa data nwere ikike mgbọrọgwụ wee nye iwu dị n'okpuru iji chọpụta na họrọ nchekwa data WordPress. N'okwu a, a na-akpọ nchekwa data WordPress \wordpress.

# mysql -u root -p
MariaDB [(none)]> show databases;
MariaDB [(none)]> use wordpress;

Na-esote, mebie iwu dị n'okpuru iji chọpụta tebụl maka ịchekwa akaụntụ onye ọrụ WordPress. Ọtụtụ mgbe, tebụl na-echekwa ozi onye ọrụ niile bụ wp_users.

Ajụjụ wp_users table iji weghachite ndị ọrụ niile ID, aha nbanye na paswọọdụ wee chọpụta ebe njirimara aha njirimara nke akaụntụ ahụ chọrọ ịgbanwe paswọọdụ.

A ga-eji uru NJ aha njirimara iji kwalite okwuntughe ọzọ.

MariaDB [(none)]> show tables;
MariaDB [(none)]> SELECT ID, user_login, user_pass FROM wp_users;

Mgbe ị chọpụtachara nke ọma ID nke onye ọrụ chọrọ mgbanwe paswọọdụ, nye iwu dị n'okpuru ka imelite paswọọdụ ya. Dochie onye ọrụ ID na paswọọdụ MD5 Hash otu a.

N'okwu a, NJ onye ọrụ bụ 1 yana hash paswọọdụ ọhụrụ bụ: e6053eb8d35e02ae40beeeacef203c1a.

MariaDB [(none)]> UPDATE wp_users SET user_pass= "e6053eb8d35e02ae40beeeacef203c1a" WHERE ID = 1;

Ọ bụrụ na ị nwebeghị paswọọdụ hashed MD5, ị nwere ike iji okwuntughe e dere na ederede doro anya mee MySQL UPDATE iwu, dị ka egosiri na ihe atụ n'okpuru.

N'okwu a, anyị ga-eji MySQL MD5() ọrụ iji gbakọọ MD5 hash nke eriri okwuntughe.

MariaDB [(none)]> UPDATE wp_users SET user_pass = MD5('the_new_password') WHERE ID=1;

Mgbe emelitere paswọọdụ, jụọ wp_users table na ID nke onye ọrụ na ị gbanweela paswọọdụ iji weghachite ozi nchekwa data onye ọrụ a.

MariaDB [(none)]> SELECT ID, user_login, user_pass FROM wp_users WHERE ID = 1;

Ọ gwụla! Ugbu a, gwa onye ọrụ na emelitela paswọọdụ ya na ọ ga-enwe ike iji paswọọdụ ọhụrụ wee banye na WordPress.