数据库

mysql> select version();
+------------+
| version()  |
+------------+
| 5.7.26-log |
+------------+
1 row in set (0.00 sec)

修改用户密码

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> update wp_users set user_pass = md5('12345') where id = 1;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select  user_login,user_pass from wp_users where id = 1;
+------------+----------------------------------+
| user_login | user_pass                        |
+------------+----------------------------------+
| jhon       | 0b9128134db6d8269764511087d2c683 |
+------------+----------------------------------+
1 row in set (0.00 sec)