Admin

INSERT INTO `wp_users` (
  `ID`,
  `user_login`,
  `user_pass`,
  `user_nicename`,
  `user_email`,
  `user_url`,
  `user_registered`,
  `user_activation_key`,
  `user_status`,
  `display_name`
) VALUES (
  1,
  'admin',
  MD5('admin123'),
  'admin',
  '[email protected]',
  '',
  NOW(),
  '',
  0,
  'admin'
);

INSERT INTO `wp_usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES
(1, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(1, 'wp_user_level', '10');

Guest

-- User (đổi ID nếu 2 đã tồn tại)
INSERT INTO `wp_users` (
  `ID`,
  `user_login`,
  `user_pass`,
  `user_nicename`,
  `user_email`,
  `user_url`,
  `user_registered`,
  `user_activation_key`,
  `user_status`,
  `display_name`
) VALUES (
  2,
  'user1',
  MD5('user123'),
  'user1',
  '[email protected]',
  '',
  NOW(),
  '',
  0,
  'user1'
);

-- Role subscriber (user thường)
INSERT INTO `wp_usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES
(2, 'wp_capabilities', 'a:1:{s:10:"subscriber";b:1;}'),
(2, 'wp_user_level', '0');