# APPLI & CMS

# Wordpress

# KB - Wordpress - requetes SQL changement ip ou hostname

<p class="callout info">Applicable à : Wordpress toutes versions.</p>

### <span style="text-decoration: underline;">Symptôme(s)</span>

Après changement d'ip de l'hôte ou d'url d'accès, impossible de se connecter au panel admin.

Egalement, des dysfonctionnements apparaissent dans le chargement de certaines pages et du style CSS.

---

### <span style="text-decoration: underline;">Problème</span>

Wordpress encode en dur des options dans la base de donnée afin de générer les chemins vers les fichiers, styles, thèmes, etc...

Avec le changement d'URL, ces chemins ne sont plus valides.

---

### <span style="text-decoration: underline;">Solution</span>

<p class="callout danger">Prérequis : Accès à la base de donnée Wordpress avec des privilèges suffisants.</p>

Se connecter au serveur SQL.

Exécuter les requêtes suivantes :

```sql
UPDATE 'madbwordpress'.wp_options SET option_value='nouvelleurl' WHERE option_name = 'siteurl';
UPDATE 'madbwordpress'.wp_options SET option_value='nouvelleurl' WHERE option_name = 'home';

```

Exécuter enfin la requête suivante pour vérifier que les nouvelles valeurs soient correctes.

```sql
SELECT * FROM 'madbwordpress'.wp_options WHERE option_name IN('siteurl','home');
```

[![image.png](https://docs.mfrstegreve.fr/uploads/images/gallery/2026-06/scaled-1680-/mhhimage.png)](https://docs.mfrstegreve.fr/uploads/images/gallery/2026-06/mhhimage.png)

---

### <span style="text-decoration: underline;">Sources</span>

# KB - Wordpress - Réinitialiser le mot de passe

<p class="callout info">Applicable à : Wordpress toutes versions.</p>

### <span style="text-decoration: underline;">Symptôme(s)</span>

Le mot de passe wordpress du compte admin ne fonctionne pas.

[![image.png](https://docs.mfrstegreve.fr/uploads/images/gallery/2026-06/scaled-1680-/image.png)](https://docs.mfrstegreve.fr/uploads/images/gallery/2026-06/image.png)

---

### <span style="text-decoration: underline;">Problème</span>

Mot de passe perdu, oublié ou changé.

---

### <span style="text-decoration: underline;">Solutions</span>

<details id="bkmrk-requ%C3%AAte-sql-pr%C3%A9requi"><summary>Requête SQL</summary>

<p class="callout danger">**Prérequis** : Accès à la base de donnée.</p>

Se connecter au serveur de base de donnée avec des privillèges suffisants pour modifier la base.

Utiliser la requête :

```sql
UPDATE `mabddwordpress`.`wp2021_users` SET user_pass=MD5('MotDePasse') WHERE ID = 1;
```

</details><details id="bkmrk-wordpress-cli-sur-le"><summary>Wordpress CLI</summary>

Sur le serveur web hébergeant le Wordpress, aller dans le répertoire wordpress.

Utiliser la commande suivante pour récupérer l'ID utilisateur.

```
wp user list
```

Puis la commande suivante pour réinitialiser le mot de passe.

```
wp user update <ID> --user_pass=MotDePasse
```

</details><details id="bkmrk-script-php-attention"><summary>Script PHP</summary>

<p class="callout warning">**Attention** : Cette page est exposée le temps de la manipulation et accessible à tout le monde. Aussi il ne faut l'utiliser qu'en dernier recours et bien penser à la supprimer immédiatement après utilisation.</p>

Wordpress a créé un script d'urgence PHP qui permet de réinitialiser le mot de passe.

A la raine du répertoire web de wordpress, créer une page appelée '<span style="color: rgb(132, 63, 161);">***emergency.php***</span>'.

```php
<?php
/*
	This program is free software; you can redistribute it and/or modify
    	it under the terms of the GNU General Public License as published by
    	the Free Software Foundation; either version 2 of the License, or
    	(at your option) any later version.

	This program is distributed in the hope that it will be useful,
    	but WITHOUT ANY WARRANTY; without even the implied warranty of
    	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
    	along with this program; if not, write to the Free Software
    	Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

require './wp-blog-header.php';

function meh() {
	global $wpdb;

	if ( isset( $_POST['update'] ) ) {
		$user_login = ( empty( $_POST['e-name'] ) ? '' : sanitize_user( $_POST['e-name'] ) );
		$user_pass  = ( empty( $_POST[ 'e-pass' ] ) ? '' : $_POST['e-pass'] );
		$answer = ( empty( $user_login ) ? '<div id="message" class="updated fade"><p><strong>The user name field is empty.</strong></p></div>' : '' );
		$answer .= ( empty( $user_pass ) ? '<div id="message" class="updated fade"><p><strong>The password field is empty.</strong></p></div>' : '' );
		if ( $user_login != $wpdb->get_var( "SELECT user_login FROM $wpdb->users WHERE ID = '1' LIMIT 1" ) ) {
			$answer .="<div id='message' class='updated fade'><p><strong>That is not the correct administrator username.</strong></p></div>";
		}
		if ( empty( $answer ) ) {
			$wpdb->query( "UPDATE $wpdb->users SET user_pass = MD5('$user_pass'), user_activation_key = '' WHERE user_login = '$user_login'" );
			$plaintext_pass = $user_pass;
			$message = __( 'Someone, hopefully you, has reset the Administrator password for your WordPress blog. Details follow:' ). "\r\n";
			$message  .= sprintf( __( 'Username: %s' ), $user_login ) . "\r\n";
			$message .= sprintf( __( 'Password: %s' ), $plaintext_pass ) . "\r\n";
			@wp_mail( get_option( 'admin_email' ), sprintf( __( '[%s] Your WordPress administrator password has been changed!' ), get_option( 'blogname' ) ), $message );
			$answer="<div id='message' class='updated fade'><p><strong>Your password has been successfully changed</strong></p><p><strong>An e-mail with this information has been dispatched to the WordPress blog administrator</strong></p><p><strong>You should now delete this file off your server. DO NOT LEAVE IT UP FOR SOMEONE ELSE TO FIND!</strong></p></div>";
		}
	}

	return empty( $answer ) ? false : $answer;
}

$answer = meh();
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>WordPress Emergency PassWord Reset</title>
	<meta http-equiv="Content-Type" content="<?php bloginfo( 'html_type' ); ?>; charset=<?php bloginfo( 'charset' ); ?>" />
	<link rel="stylesheet" href="<?php bloginfo( 'wpurl' ); ?>/wp-admin/wp-admin.css?version=<?php bloginfo( 'version' ); ?>" type="text/css" />
</head>
<body>
	<div class="wrap">
		<form method="post" action="">
			<h2>WordPress Emergency PassWord Reset</h2>
			<p><strong>Your use of this script is at your sole risk. All code is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness. Further, I shall not be liable for any damages you may sustain by using this script, whether direct, indirect, special, incidental or consequential.</strong></p>
			<p>This script is intended to be used as <strong>a last resort</strong> by WordPress administrators that are unable to access the database.
				Usage of this script requires that you know the Administrator's user name for the WordPress install. (For most installs, that is going to be "admin" without the quotes.)</p>
			<?php
			echo $answer;
			?>
			<p class="submit"><input type="submit" name="update" value="Update Options" /></p>

			<fieldset class="options">
				<legend>WordPress Administrator</legend>
				<label><?php _e( 'Enter Username:' ) ?><br />
					<input type="text" name="e-name" id="e-name" class="input" value="<?php echo attribute_escape( stripslashes( $_POST['e-name'] ) ); ?>" size="20" tabindex="10" /></label>
				</fieldset>
				<fieldset class="options">
					<legend>Password</legend>
					<label><?php _e( 'Enter New Password:' ) ?><br />
					<input type="text" name="e-pass" id="e-pass" class="input" value="<?php echo attribute_escape( stripslashes( $_POST['e-pass'] ) ); ?>" size="25" tabindex="20" /></label>
				</fieldset>

				<p class="submit"><input type="submit" name="update" value="Update Options" /></p>
			</form>
		</div>
	</body>
</html>
<?php exit; ?>
```

Utiliser ensuite '<span style="color: rgb(132, 63, 161);">***https://&lt;votre url wordpress&gt;/emergency.php***</span>' pour changer le mot de passe.

[![image.png](https://docs.mfrstegreve.fr/uploads/images/gallery/2026-06/scaled-1680-/ahmimage.png)](https://docs.mfrstegreve.fr/uploads/images/gallery/2026-06/ahmimage.png)

</details>---

### <span style="text-decoration: underline;">Sources</span>

<span style="text-decoration: underline;">[Reset your password – Documentation – WordPress.org](https://wordpress.org/documentation/article/reset-your-password/)</span>

</body></html>