Sep 212018

Remove All In One WP Security Database Tables shows you how to search for the plugins tables in the corresponding database for your site.

Last Updated: March 13, 2021

Latest News: Updated the documentation.

These instructions shows you how to remove all tables and database entries with the name aiowps and or aio using phpMyAdmin.

These steps are important if you are having issues with our plugin and or you can’t log into your site anymore. These steps will totally remove aionwps entries from your sites database. This will allow you to reinstall a fresh new copy of the plugin and allow you to start all over setting up the plugin.

What you need:

Remove All In One WP Security Database Tables

Important: Before you begin, create a database backup of your site. Just in case something goes wrong.

Step 1 ) These steps assume you have already deactivated and deleted the plugin from your site and removed all entries include the following tags from your .htaccess file. And now you want to make sure all tables are removed from your database.

# BEGIN All In One WP Security
# END All In One WP Security

However, if you can’t log into your site to deactivate and delete the plugin, you will need to access to your site via FTP or cPanel file manager.

(Note: You can use this plugin wp-file-manager, if you don’t have access to your server and can log into your site. You can also use an FTP software like filezilla.)

Log Into Your Server

Step 2 ) Log into your server and run phpMyAdmin. Located the database for the site in question as illustrated below. In this example the database in question is word492.

Note: You might have more than one database running in your server. So make sure you select the correct database.


Step 3 ) When I click on word492 database, I can start searching for the plugins tables. In the following image, you can see straight away some plugin’s tables that are safe to delete with WordPress default database prefix wp_.

Note: WordPress default database prefix is wp_. In your site your database prefix might be different.

Tables Safe To Delete

  • aiowps_events
  • aiowps_failed_logins
  • aiowps_global_meta
  • aiowps_login_activity
  • aiowps_login_lockdown
  • aiowps_permanent_block

For the following two tables you need further investigation. In other words, don’t delete them. You need to search inside of them for any entries related to aiowps.

Investigate These Tables Further

| commentmeta |
| comments |


phpMyAdmin Search Options

Step 4 ) The following image shows you how to search your database for any entries that have the following word aiowps. Please make sure you carry out the following steps.

Searching Steps:

  • Enter the following word aiowps in the field as illustrated in the image below.
  • Under Find: select at lease one of the words. I find this to be the best option in this case.
  • Under Inside tables: Select Select all. Make sure all tables are selected in the database.
  • Finally click on Go button to begin the search.


phpMyAdmin Search Criteria Displayed

Step 5 ) The following image shows you 5 entries found in the following table wp_options. Click on Browse link to view all the entries found.

Note: In your case the search might show more than 5 entries found.


Step 6 ) The following image shows you the 5 entries found. If the options name have the following name values aio or aiowps, then you can safely delete them. Otherwise you need to edit and search for any entries with a the following values name aio or aiowps.

The following image shows you the Edit link you need to click on to begin searching. In this tutorial, the following option_name needed to be searched.

Search Inside

  1. _site_transient_update_plugins
  2. _transient_plugin_slugs
  3. aio_wp_security_configs
  4. aiowpsec_db_version
  5. You might also find the following entry aiowps_temp_configs, not showing in the image below.
  6. cron = For cron jobs, you might want to use one of the following plugins Manage WordPress Cron Jobs to delete the cron job from your site. This is much safer than working in phpMyAdmin.

Note: If you find more entries in options, please let me know and I will add them to the list above.


I hope the above tutorial helps you remove all aiowps entries from your database.

Click on the following link Troubleshooting to continue configuring the plugins settings.

If you have any questions please let me know. I will be updating this post from time to time. So keep coming back for the latest.


All In One WP Security & Firewall Plugin Tutorial List

I have been working in IT since 1999 and I enjoy the challenges it brings me. I love developing websites with WordPress. I spend a lot of time helping out in forums. I have been writing tutorials since 2011. Now I am learning how to manage my own VPS "Virtual Private Server.

  6 Responses to “Remove All In One WP Security Database Tables”

  1. I deactivated and deleted this plugin via ftp because it totally screwed up my site. I see that it is still sitting in the menu sidebar of my wordpress site. How do I get rid of this thing entirely please? Thank you.

    • Hi, sorry to hear about your issue.

      Did you enable any of the advanced feature? Is your site hosted in a none aPache server?

      Regarding the removal of the plugin from your site, did you follow the instructions above?


  2. If you have a private email we could discuss this I would appreciate it.
    I was Forbidden, absolutely nothing no first page even. I ftp disabled all plugins, then I deleted All In One WP security plugin. I relaoded htaccess from backup, checked wp config which had my db prefix to what it changed it to so I reloaded that file from back up – backups before the plugin. Went to MyPHP – yes apache- deleted the six tables.
    From there on I needed to contact my host which got me back online, said permissions were changed on some files.
    I haven’t gone back to myPHP yet but something isn’t right and I haven’t the expertise to go any further. Don’t want to mess with db because then I have to bug my host again when something breaks. My https login is messed up and is where Id rather talk privately if you don’t mind. Site is ecommerce

  3. I tried everything, including turning off the server’s firewall, restarting apache, nginx and etc.

    I deleted all entries from the bank, plugin, htaccess and still does not display the admin bar, nor does it let me enter wp-admin.

    I also tried a new installation with the old bank. Problem persists, I do not enter wordpress anymore.

    • Let me see if I understand your issue. You have disabled and deleted our plugin, but you still can’t log into your site. Is this correct?

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



4 + 17 =