Hier werden die Unterschiede zwischen zwei Versionen gezeigt.
— |
wordpress-snippets-admin-password-reset [2015/02/13 10:54] (aktuell) admin angelegt |
||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | ====== wordpress-snippets-admin-password-reset ====== | ||
+ | Set Admin Password with MySQL (v5+) | ||
+ | <code> | ||
+ | UPDATE wp_users SET user_pass = MD5('"(NEWPASS)"') WHERE ID = (1); | ||
+ | </code> | ||
+ | |||
+ | Add admin user with MySQL (v5+) | ||
+ | <code> | ||
+ | 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', 'admin2', MD5('demo'), 'Martin Test', 'test@yourdomain.com', 'http://dummy.com', '2014-06-07 00:00:00', '', '0', 'Martin Test'); | ||
+ | |||
+ | |||
+ | INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '2', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}'); | ||
+ | |||
+ | |||
+ | INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '2', 'wp_user_level', '10'); | ||
+ | </code> |