Wordpress: Easily Reset Your Account Password Using MySQL and PHP Wordpress: Lako Reset Your account password Using MySQL i PHP

Posted on 08. Posted na 08. Jun, 2009 by Dragos in Coding , MySQL , PHP Jun, 2009 by Dragos u kodiranju, MySQL, PHP

I've just forgot my admin password on my local testing blog, and what is worse – my local machine is not configured to send external email. Ive 'pravedan je zaboravio moj admin lozinka na moj blog lokalnoj testiranja, a što je još gore - moj lokalni stroj nije konfiguriran za vanjski poslati e-mail. Oh yeah, got to reinstall wordpress again, what a pity. Oh yeah, got to reinstalirati wordpress opet, kakva šteta. No way! No way! There are two ways of resetting your password using two easy methods. Postoje dva načina promjene lozinke koristeći dva jednostavna metoda. You'll need basic knowledge of PHP or CPanel+PHPMyAdmin. Morat ćete osnovno znanje o PHP-u ili cPanel + phpmyadmin.

I Method: CPanel+PHPMyAdmin Ja Method: cPanel + phpMyAdmin

For this method, it is necessary that your host have CPanel and PHPMyAdmin installed. Za ovu metodu, potrebno je da vaš domaćin imaju CPanel i phpmyadmin Installer. If your host doesn't have these pieces of software, but something similar to these, you can follow this tutorial and apply these steps to your situation. Ako vaš domaćin nema tih komada softvera, ali nešto slično tim, možete slijediti ovaj udžbenik i primjenjivati ove korake na Vašu situaciju.

First we'll need to open the PHPMyAdmin page. Prvo ćemo morati otvoriti phpMyAdmin stranicu. From the CPanel root page, launch PHPMyAdmin. Od stranicu cPanel korijen, pokrenite phpMyAdmin. The icon of PHPMyAdmin should look similar to the one emphasized in the screenshot below. Ikona phpMyAdmin treba izgledati slično onome naglasio u slici ispod.

PHPMyAdmin PhpMyAdmin

Once on the main page of PHPMyAdmin you should remember what database did you use when installing wordpress. Nakon što se na glavnoj stranici phpMyAdmin morate zapamtiti što si bazu podataka koristiti prilikom Instaliranje WordPress. If you don't remember, don't get angry. Ako se ne sjećate, ne naljute. Go to your root folder where wordpress is installed and download & open the file wp-config.php with a simple text editor like Notepad/GEdit. Go to root folder gdje je instaliran WordPress i download i otvorite datoteku wp-config.php sa jednostavan tekst editor kao Notepad / gedit. You'll need to find this line: Morat ćete naći ovu liniju:

 define('DB_NAME', 'ABCD'); define ( 'db_name', 'ABCD');

Note that ABCD (without the single quotes around it) is the name of the database that wordpress is installed in. Imajte na umu da ABCD (sa jednostrukim navodnicima oko njega) je naziv baze podataka koji je instaliran in WordPress

Back on the PHPMyAdmin page, click on the link of your database name. Natrag na phpmyadmin stranici, kliknite na link vašeg naziv baze podataka. In my case it was _iwebdevel . U mom slučaju to je bio _iwebdevel.

Select your database Odaberite svoju bazu podataka

Now you'll see another PHPMyAdmin page, but this time you'll be presented all your tables contained in the ABCD database. Sada ćete vidjeti drugi phpMyAdmin stranicu, ali ovaj put ćete biti prisutan sve svoje tablice koji se nalazi u bazi podataka ABCD. We need to select the table users . Moramo odabrati stol korisnicima. You won't see the exact name users of this table, but a name in this format xx_users , where xx_ is the prefix of your wordpress table names. Nećete vidjeti željenih članaka korisnici ove tablice, ali je ime u ovom obliku xx_users, gdje xx_ je prefiks od tvoj WordPress nazive tablica. Click on the link of your users table ( xx_users ). Kliknite na link korisnici tablice (xx_users). In my case, as in most cases it's wp_users : U mom slučaju, kao iu većini slučajeva to je wp_users:

Select the users table Odaberite tablice korisnika

Now click on browse to see the rows contained in table xx_users . Sada kliknite na Browse da biste vidjeli recima koji se nalazi u tablici xx_users.

Click on browse Kliknite na browse

Now look for the username you want to reset the password. Sada tražiti korisničko ime koje želite to nanovo naoštriti lozinka. In my case I want to reset password for admin. Now click on the edit button. U mom slučaju želim to nanovo naoštriti lozinka za admin. Sada kliknite na gumb uredi.

Edit user's details Edit user's details

Now you'll need to generate an MD5 hash of the new password you would like to set. Sada ćete morati roditi MD5 mljeveno meso za novu lozinku želite postaviti. Go to http://seoanalytic.com/tools/md5_encryptor/ and enter your preferred password. Idi na http://seoanalytic.com/tools/md5_encryptor/ i unesite željenu lozinku. After you enter your new password, click on the Encrypt! button. Nakon što unesete novu lozinku, kliknite na Šifriranje! Gumb.

Encrypt your password Encrypt your password

After you've encrypted your password, select and copy the newly MD5 generated hash code. Nakon što ste kodiran zaporku, a zatim odaberite copy novo MD5 mljeveno meso generirani kod.

Select and copy the MD5 hash Odaberite i kopirati MD5 mljeveno meso

Now return to your PHPMyAdmin page and paste your MD5 hash from the clipboard to the input field as shown in the image below: Zatim vratiti na svoju stranicu phpmyadmin i zalijepiti svoje MD5 mljeveno meso iz međuspremnika na polje unosa kao što je prikazano na slici ispod:

Paste MD5 hash in the specified input field Zalijepite MD5 mljeveno meso u određenom polju za unos

Finally click on Go button to save your new password. Na kraju kliknite na Ići gumb to spasiti svoju novu lozinku.

Save new password Spremi novu lozinku

II Method: PHP II Method: PHP

In my opinion the second method is much faster and simpler. Po mom mišljenju drugu Metodije je velik dio brže i jednostavnije. In this method you'll just have to upload a PHP file to your host and access it with a browser. Na ovaj način ćete samo morati upload PHP varalica na svoj host i pristup s pretraživača. But we'll talk about it a little bit later. Ali mi ćemo govoriti o tome malo kasnije.

So here's the piece of PHP code I've came up with to help you reset your wordpress account password. Na taj način krivovjerje 'komad od PHP koda sam došao gore sa kako bi vam pomoglo vratiti tvoj WordPress račun lozinka.

  $newPassword='NEW_PASSWORD_GOES_HERE'; //put your new password between the single quotes $ Newpassword = 'NEW_PASSWORD_GOES_HERE'; / / stavi novu lozinku između jednostruke navodnike
	$username='admin'; //put the login username you'd like to change the password to $ username = 'Admin'; / / stavi prijava korisničko ime koje želite promijeniti lozinku za
	@include_once('./wp-config.php'); //get some details from your wordpress installation @ include_once ( '. / wp-config.php'); / / dobiti neke detalje iz svog WordPress instalacija
	global $table_prefix; global $ table_prefix;
	$conxb=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD); //establish connection to your database $ conxb = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD); / / uspostaviti vezu na svoju bazu podataka
	mysql_select_db(DB_NAME,$conxb); mysql_select_db (db_name, $ conxb);
	$query='update `'.$table_prefix.'users` set `user_pass`=\''.mysql_real_escape_string(md5($newPassword)).'\' where `user_login`=\''.mysql_real_escape_string($username).'\' limit 1'; $ query = 'ažurirati `'. $ table_prefix. '` korisnici `skup user_pass` = \''. mysql_real_escape_string (md5 ($ Newpassword)).' \ ', gdje `user_login` = \''. mysql_real_escape_string ($ username). '\' limit 1 ';
	$mQuery=mysql_query($query,$conxb); //set new password $ mQuery = mysql_query ($ upit, $ conxb); / / set novu lozinku
	echo $mQuery?'Successfully set new password. echo $ mQuery? 'Uspješno postavljanje nove lozinke. New password: '.$newPassword:'There was an error. Nova lozinka: ". $ Newpassword: 'Došlo je do pogreške. Error: '.mysql_error(); //if result is unsuccessful you'll see the mysql error message Greška: '. Mysql_error (); / / ako je rezultat je neuspješni vidjet ćete poruku o pogrešci mysql
	mysql_close($conxb); mysql_close ($ conxb);

For your convenience you can download the file reset.php from here . Radi Vaše udobnosti možete preuzimanje datoteka from reset.php ovdje.

Now extract the zip archive you've just downloaded and edit the necessary parameters to suit your needs (explanation comments are present in the PHP code above). Sada ekstrakt određeni član zujanje arhiv ste upravo preuzeli i urediti parametre potrebne da odgovaraju vašim potrebama (objašnjenje komentari su prisutni u PHP kod iznad). Then upload the file reset.php to your wordpress root installation folder. Onda upload datoateka u vaš WordPress reset.php korijen uvođenje u službu savijač. To make sure that this is the right directory, look for a file named wp-config.php , Kako biste bili sigurni da je ovo pravo imenik, potražite datoteku pod nazivom wp-config.php, if it's there you're on the right way, else look for the directory where wp-config.php is present and upload the file reset.php there. ako je tamo ste na pravi put, drugi traže direktorij gdje wp-config.php je prisutan i upload datoteka reset.php tamo.

Finally you'll want to go to http://yourDomainName.TLD/ reset.php . Konačno ćete želite ići na http://yourDomainName.TLD/ reset.php. You'll see the appropriate message depending on how the script worked. Vidjet ćete odgovarajuću poruku ovisno o tome koliko original radio. If there is an error, post it here and I'll try to help you, else you did everything perfectly and you can now log in with your new password. Ako postoji greška, pošta Internet ovdje i ja ću pokušati da vam pomogne, još vam je sve savršeno i sada možete prijaviti s novom lozinkom.