How to manage WordPress database using the WP Data Access plugin

WP Data Access is a data administration and development plugin that lets you perform database-related tasks directly from your WordPress dashboard. It enables data management from the WordPress dashboard, including JSON configuration, the addition of custom JavaScript functions, the management of local and remote databases, the import and export of multiple formats, the query builder, data project management, and the creation and modification of tables and indexes.This article will show you how to install a WP Data Access Plugin on your WordPress-powered website.

Installing and configuring WP Data Access Plugin

To use WP Data Access Plugin in your WordPress website, follow these steps:

  1. Log in to WordPress as the administrator.
  2. On the Dashboard in the left sidebar, click Plugin, and then click Add New:

  3. Search for “WP Data Access Plugin,” then click Install Now. Click Activate to activate the plugin:

  4. On the Dashboard in the left sidebar, click WP Data Access.The Data Explorer section lists out the tables and allows you to add, delete, edit, export  these tables:

  5. Query Builder section allows you to create, execute, and save queries in your database:

  6. Data Designer allows you to add tables to your database, as well as their names, data types, and other details:

  7. Data Project displays the projects and allows you to manage them via the dashboard:

More Information

For more information about the WP Data Access, please visit https://wordpress.org/plugins/wp-data-access/

Get Managed WordPress Hosting

Article Details

Other Articles in This Category

Show More

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.