Desactiver un plugin wordpress depuis la base de donnée

Se connecter à mysql avec l’utilisateur admin de wordpress

:$ mysql -u username -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 172408
Server version: 10.1.25-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MariaDB [(none)]>

Selectionner la base de donnée de wordpress

MariaDB [(none)]> USE wordpress;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Afficher la liste des extensions activées

MariaDB [wordpress]> SELECT * FROM wp_options WHERE option_name = 'active_plugins';
+-----------+----------------+-------------------------------------------------------------------------------------------------+----------+
| option_id | option_name    | option_value                                                                                    | autoload |
+-----------+----------------+-------------------------------------------------------------------------------------------------+----------+
|        33 | active_plugins | a:1:{i:0;s:77:"ldap-login-password-and-role-manager/ldap_login_password_and_role_manager.php";} | yes      |
+-----------+----------------+-------------------------------------------------------------------------------------------------+----------+
1 row in set (0.00 sec)

Modifier le tableau pour désactiver toutes les extensions actives

MariaDB [wordpress]> UPDATE wp_options SET option_value = 'a:1:{}' WHERE option_name = 'active_plugins';
Query OK, 1 row affected (0.08 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [wordpress]> SELECT * FROM wp_options WHERE option_name = 'active_plugins';
+-----------+----------------+--------------+----------+
| option_id | option_name    | option_value | autoload |
+-----------+----------------+--------------+----------+
|        33 | active_plugins | a:1:{}       | yes      |
+-----------+----------------+--------------+----------+
1 row in set (0.00 sec)

Liens

Perishable Press

Laisser un commentaire