Sebagai manusia kita pasti akan pernah lupa dan hal ini sudah wajar karena manusia tidak ada yang sempurna. Jika Anda mempunyai WordPress yang diinstall menggunakan mariadb server dan Anda lupa akan password login ke WP Admin WordPress Anda, janganlah khawatir karena password WP dapat Anda reset ulang melalui phpMyAdmin ataupun CLI MariaDB.
Disini kami akan memberikan cara reset password WP Admin WordPress Anda menggunakan CLI database MariaDB.
Langkah pertama yang harus dilakukan yaitu membuat password baru dengan enkripsi MD5
1
2
3
4
[root@tutorial ~]#
[root@tutorial ~]# echo -n "passwordbaruwpbelajarlinux" | md5sum
41f144634609e72b28d5c53582e801f9 -
[root@tutorial ~]#
Noted: Simpan MD5 dan passwordbaru Anda
Selanjutnya login ke mariadb Anda dan masuk ke database WordPress Anda menggunakan use [Nama DB]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
[root@tutorial ~]#
[root@tutorial ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 191
Server version: 10.3.17-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| belajarlinuxdb |
| chamilo |
| ci_db |
| drupal |
| information_schema |
| joomla |
| joomladb |
| laravel |
| moodle |
| mysql |
| performance_schema |
| prestashop |
| typo3 |
| wordpress |
+--------------------+
14 rows in set (0.170 sec)
MariaDB [(none)]> 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
MariaDB [wordpress]>
Melihat tabel WordPress
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
MariaDB [wordpress]> 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.000 sec)
Pada tabel tersebut ada wp_users dimana list user login ke WP Admin ada disitu
Untuk mengetahuinya user dan password nya jalankan perintah berikut
1
2
3
4
5
6
7
MariaDB [wordpress]> SELECT ID, user_login, user_pass FROM wp_users;
+----+---------------------+------------------------------------+
| ID | user_login | user_pass |
+----+---------------------+------------------------------------+
| 1 | adminbelajarlinuxid | $P$BmLezSVhiKAQcX3wiz7inzC9YScbcy0 |
+----+---------------------+------------------------------------+
1 row in set (0.000 sec)
Anda dapat reset password atau memperbaharui password Anda seperti berikut
1
2
3
4
5
6
7
MariaDB [wordpress]>
MariaDB [wordpress]> UPDATE wp_users SET user_pass= "41f144634609e72b28d5c53582e801f9" WHERE ID = 1;
Query OK, 1 row affected (0.004 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [wordpress]>
Noted: user_pass = Isikan MD5 yang didapatkan pada saat membuat password baru
Jika di select user wp kembali saat ini password sudah berubah
1
2
3
4
5
6
7
8
9
10
11
MariaDB [wordpress]>
MariaDB [wordpress]> SELECT ID, user_login, user_pass FROM wp_users;
+----+---------------------+----------------------------------+
| ID | user_login | user_pass |
+----+---------------------+----------------------------------+
| 1 | adminbelajarlinuxid | 41f144634609e72b28d5c53582e801f9 |
+----+---------------------+----------------------------------+
1 row in set (0.001 sec)
MariaDB [wordpress]>
Langkah terakhir flush privileges database Anda
1
2
3
4
5
6
7
MariaDB [wordpress]>
MariaDB [wordpress]> flush privileges;
Query OK, 0 rows affected (0.034 sec)
MariaDB [wordpress]> exit
Bye
[root@tutorial ~]#
Sekarang mencoba login menggunakan username dan password baru ke WP Admin
Pastikan sudah sesuai, jika berhasil maka Anda akan diarahkan ke Dashboard WP Admin WordPress
Selamat mencoba 😁