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.
   
2. Adminer ([plugin_info slug="adminer" data="downloaded"]): [plugin_info slug="adminer" data="short_description"] (Thanks Jason!)
   
3. Search and Replace ([plugin_info slug="search-and-replace" data="downloaded"]): [plugin_info slug="search-and-replace" data="short_description"]
   
4. Search Regex ([plugin_info slug="search-regex" data="downloaded"]): [plugin_info slug="search-regex" data="short_description"]ort.
   
5. SQL Executioner ([plugin_info slug="sql-executioner" data="downloaded"]): [plugin_info slug="sql-executioner" data="short_description"]
   
6. Edit Any Table ([plugin_info slug="edit-any-table" data="downloaded"]): [plugin_info slug="edit-any-table" data="short_description"]
   
7. WP Clean Up ([plugin_info slug="wp-clean-up" data="downloaded"]): [plugin_info slug="wp-clean-up" data="short_description"]
   
8. ELI's SQL Admin Reports Shortcode and DB Backup ([plugin_info slug="elisqlreports" data="downloaded"]): [plugin_info slug="elisqlreports" data="short_description"]
   
9. Safe Search and Replace ([plugin_info slug="safe-search-replace" data="downloaded"]): [plugin_info slug="safe-search-replace" data="short_description"]
   
10. Find replace ([plugin_info slug="find-replace" data="downloaded"]): [plugin_info slug="find-replace" data="short_description"]
    

Other Plugins include:

• dbview ([plugin_info slug="dbview" data="downloaded"]): [plugin_info slug="dbview" data="short_description"]
  
• 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"]