les wordpress

Lister les users

SELECT ID, user_login, user_pass FROM (wp_users);

Changer un mot de passe

UPDATE (wp_users) SET user_pass=MD5('tonsupermotdepasse') WHERE ID = id_de_user;

Se mettre admin

INSERT INTO wp_usermeta (user_id, meta_key, meta_value)
VALUES (id_de_user, 'wp_user_level', '10');

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


# y a des doublon maintenant dans la table faut suppr les anciennes valeurs

SELECT umeta_id, meta_key, meta_value 
    -> FROM wp_usermeta 
    -> WHERE user_id = id_de_user;

DELETE FROM wp_usermeta WHERE umeta_id = 184;