3) wp_users

zapmap.com/wp-admin/profile.php

  1. mysql -u [username] -p -D [database_name]
  2. desc [table_name];
  3. UPDATE wp_users SET user_pass = MD5( ‘[new_password]’ ) WHERE user_login = ‘[username]’;
  4. UPDATE wp_users SET user_login = ‘[new_username]’ WHERE user_login = ‘[old_username]’;

mysql -u root -p -D wp480
desc wp_users;

UPDATE wp_users SET user_login = ‘Francisco’ WHERE user_login = ‘Frank’;

UPDATE wp_users SET user_pass = MD5( ‘def456’ ) WHERE user_login = ‘Francisco’;