Skip to main content

Posts

Showing posts with the label Wordpress

Reset Wordpress Admin Via MySQL DB

Here are step by step to reset wordpress password if forgot the password. Make sure you have access to the databases.  mysql> use wordpress; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +-----------------------+ | Tables_in_wordpress   | +-----------------------+ | wp_commentmeta        | | wp_comments           | | wp_links              | | wp_options            | | wp_postmeta           | | wp_posts              | | wp_term_relationships | | wp_term_taxonomy      | | wp_termmeta           | | wp_terms              | | wp_usermeta           | | wp_users              | +-----------------------+ 12 rows in set (0.00 sec) mysql>  Generate a New Password Hash: WordPress uses a salted MD5 hash for passwords. You can generate a new password hash. Here is example python script import bcrypt def generate_wordpress_hash(password):     # Generate a random salt and h

Solusi lupa password wordpress admin

 berikut adalah catatan solusi jika lupa password admin wordpress cara ini melalui db mysql, pastikan dulu sudah bisa akses ke db mysql dengan db wordpress dan password username yg benar kemudian jalankan perintah berikut: mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | wordpress          | +--------------------+ 2 rows in set (0.00 sec) mysql> use wordpress; Database changed mysql> SELECT ID, user_login, user_pass FROM wp_users; +----+------------+------------------------------------+ | ID | user_login | user_pass                          | +----+------------+------------------------------------+ |  1 | nasohi     | $**********&&&&* | +----+------------+------------------------------------+ 1 row in set (0.00 sec) Contoh dibawah akan mengubah password menjadi  this1SPassw0rD mysql> UPDATE wp_users SET user_pass = MD5('this1SPassw0rD') WHERE ID=1 LIMIT 1; Query OK, 1 row affected (0