Yadda ake Sake saita kalmar wucewa ta Admin WordPress ta hanyar umarni na MySQL

Wani lokaci, mai amfani da WordPress, tare da ɗaya daga cikin iyawa masu zuwa, kamar mai gudanarwa, edita, marubuci, mai ba da gudummawa, ko mai biyan kuɗi, yana manta da bayanan shigansa, musamman ma kalmar sirri.

Ana iya canza kalmar sirri ta WordPress cikin sauƙi ta hanyar Lost Password a cikin hanyar shiga WordPress. Duk da haka, idan asusun WordPress ba shi da hanyar shiga adireshin imel ɗinsa, canza kalmar sirri ta amfani da wannan tsarin na iya zama ba zai yiwu ba. Kalmar sirrin asusun WordPress ne kawai mai gudanar da tsarin ke iya sarrafa shi tare da cikakken gata zuwa MySQL database daemon.

A cikin wannan jagorar, za mu nuna muku yadda ake sake saita kalmar sirri ta asusun WordPress ta layin umarni MySQL a cikin Linux.

Kafin shiga cikin sabis na bayanan MySQL/MariaDB, da farko ƙirƙirar sigar MD5 Hash na sabuwar kalmar sirri da za a sanya wa asusu, ta hanyar ba da umarnin da ke ƙasa.

Maye gurbin newpass kirtani da aka yi amfani da shi a cikin wannan misali tare da kalmar sirri mai ƙarfi. Kwafi kalmar sirri MD5 hash zuwa fayil domin daga baya liƙa hash zuwa filin kalmar sirri na mai amfani MySQL.

# echo -n "newpass" | md5sum

Bayan kun ƙirƙiri sabon kalmar sirri MD5 hash, shiga cikin bayanan MySQL tare da tushen gata kuma ba da umarnin da ke ƙasa don ganowa da zaɓi bayanan bayanan WordPress. A wannan yanayin ana kiran ma'aunin bayanan WordPress suna \wordpress.

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

Na gaba, aiwatar da umarnin da ke ƙasa don gano teburin da ke da alhakin adana asusun mai amfani da WordPress. Yawancin lokaci teburin da ke adana duk bayanan mai amfani shine wp_users.

Tambayi wp_users tebur don dawo da duk masu amfani ID, login sunan da kalmar sirri da gano filin ID na sunan mai amfani na asusun da ke buƙatar canza kalmar sirri.

Za a yi amfani da ƙimar ID na sunan mai amfani don ƙara sabunta kalmar wucewa.

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

Bayan kun gano daidai ID na mai amfani da ke buƙatar canza kalmar sirri, ba da umarnin da ke ƙasa don sabunta kalmar wucewa. Sauya mai amfani ID da kalmar sirri MD5 Hash daidai da haka.

A wannan yanayin ID ɗin mai amfani shine 1 kuma sabon hash ɗin kalmar sirri shine: e6053eb8d35e02ae40beeeacef203c1a.

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

Idan ba ku da kalmar sirrin hashed ta MD5, za ku iya aiwatar da umarni na MySQL UPDATE tare da kalmar wucewa da aka rubuta a cikin rubutu bayyananne, kamar yadda aka nuna a cikin misalin da ke ƙasa.

A wannan yanayin za mu yi amfani da MySQL MD5() aiki don ƙididdige hash na MD5 na kalmar sirri.

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

Bayan an sabunta kalmar wucewa, tambaya wp_users tebur tare da ID na mai amfani cewa kun canza kalmar sirri don dawo da wannan bayanan bayanan mai amfani.

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

Shi ke nan! Yanzu, sanar da mai amfani cewa an sabunta kalmar sirrinsa kuma ya kamata ya sami damar shiga WordPress tare da sabon kalmar sirri.