WP Smith

Creating WordPress & Genesis Websites Since 2010

  • Home
  • About
  • Services
  • Blog
  • Contact

Feb 13 2014

SQL WordPress Plugins: Accessing the Database from within WordPress

In some sites more than others, I will find myself spending more time in the database or SQL side of the site as this makes for an incredibly efficient method to updating, restoring, or fixing data as opposed to using the WordPress admin interface. Sometimes you, too, may be forced to access the database directly, if you accidentally changed something like Home or Site URL (phpMyAdmin is awesome for this).

However, what if you have a client and they did not give you SQL access? What if your client does not have cPanel or phpMyAdmin? There are a variety of tools (i.e., WordPress plugins) available for you to do database stuff from WordPress (though not as fast per se).

Check out these plugins:

  1. MyWebSql: Allows editing/managing the WordPress database directly from within the admin panel, just like phpMyAdmin. Note, this needs the bcmath PHP extension as well as gmp & openssl extensions. If you don't have these extensions, try changing SECURE_LOGIN to false as directed here.
    WordPress SQL Plugin: MyWebSQL
  2. Adminer ([plugin_info slug="adminer" data="downloaded"]): [plugin_info slug="adminer" data="short_description"] (Thanks Jason!)
    WordPress SQL Plugins: Adminer
  3. Search and Replace ([plugin_info slug="search-and-replace" data="downloaded"]): [plugin_info slug="search-and-replace" data="short_description"]
    WordPress SQL Plugin: Search and  Replace
  4. Search Regex ([plugin_info slug="search-regex" data="downloaded"]): [plugin_info slug="search-regex" data="short_description"]ort.
    WordPress SQL Plugin: Search Regex
  5. SQL Executioner ([plugin_info slug="sql-executioner" data="downloaded"]): [plugin_info slug="sql-executioner" data="short_description"]
    WordPress SQL Plugin: SQL Executioner
  6. Edit Any Table ([plugin_info slug="edit-any-table" data="downloaded"]): [plugin_info slug="edit-any-table" data="short_description"]
    WordPress SQL Plugin: Edit Any Table
  7. WP Clean Up ([plugin_info slug="wp-clean-up" data="downloaded"]): [plugin_info slug="wp-clean-up" data="short_description"]
    WordPress SQL Plugin: WP Clean Up
  8. ELI's SQL Admin Reports Shortcode and DB Backup ([plugin_info slug="elisqlreports" data="downloaded"]): [plugin_info slug="elisqlreports" data="short_description"]
    WordPress SQL Plugin: Eli's SQL Report
  9. Safe Search and Replace ([plugin_info slug="safe-search-replace" data="downloaded"]): [plugin_info slug="safe-search-replace" data="short_description"]
    WordPress SQL Plugin: Safe Search and Replace
  10. Find replace ([plugin_info slug="find-replace" data="downloaded"]): [plugin_info slug="find-replace" data="short_description"]
    WordPress SQL Plugin: Find and replace

Other Plugins include:

  • dbview ([plugin_info slug="dbview" data="downloaded"]): [plugin_info slug="dbview" data="short_description"]
    WordPress SQL Plugin: DBView
  • WP MySQL Console (hasn't been updated in over 2 years) ([plugin_info slug="wp=mysql-console" data="downloaded"]): [plugin_info slug="wp-mysql-console" data="short_description"]
    WordPress SQL Plugin: WP MySQL Console Plugin

Written by Travis Smith · Categorized: Plugins

StudioPress Premium WordPress Themes     WP Engine Managed WordPress Hosting

What can I do for you!?

Custom Development

We develop plugins by determining both business/functional and technical requirements, following WordPress development best practices, and using agile methodology to ensure you get the best solution.

Consulting

Have questions? Need a reliable developer to consult? Please contact us today!

Customized Theme

We can customize your theme or child theme, or create a child theme for you based on your needs while enhancing the performance of every individual attribute.

Customized Plugin

We can customize your plugins, extend plugins (e.g., Gravity Forms, Jetpack, Soliloquy) based on your needs ensuring security, performance, and positive business impact.

Contact Us

About Travis Smith

As a WordPress enthusiast, developer, and speaker, Travis writes about what he learns in WordPress trying to help other WordPress travelers, beginners and enthusiasts with tutorials, explanations, & demonstrations.

Comments

  1. Paul says

    February 16, 2014 at 1:33 pm

    To me this is something way too risky to have access to from the admin area.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  • Twitter
  • Facebook
  • LinkedIn
  • Google+
  • RSS

Copyright © 2025 � WP Smith on Genesis on Genesis Framework � WordPress � Log in