# 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;
```