Drop all databases in MySQL

We have many databases in our MySQL and we want to shrink/purge ibdata1 file in MySQL.

How can we drop all the databases from the MySQL except information_schema and mysqld databases?

Related Posts:

  1. MySQL error 2006: mysql server has gone away
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. Cannot delete or update a parent row: a foreign key constraint fails
  4. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  5. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  6. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  7. what does “/index.php?admin/admin_dashboard” in my url mean
  8. How to join two tables by multiple columns in SQL?
  9. How to get size of mysql database?
  10. SQL – Update multiple records in one query
  11. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  12. MySQL: Invalid use of group function
  13. mysqladmin: connect to server at ‘localhost’ failed
  14. mysql update multiple columns with same now()
  15. Usage of MySQL’s “IF EXISTS”
  16. Generating a random & unique 8 character string using MySQL
  17. MySQL > Table doesn’t exist. But it does (or it should)
  18. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  19. How to create a foreign key in phpmyadmin
  20. Can’t create test file lower test start server mysql
  21. MySQL delete multiple rows in one query conditions unique to each row
  22. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  23. How to get the max of two values in MySQL?
  24. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  25. MySql – HAVING vs WHERE 
  26. How to stop mysqld
  27. Is merge statement available in MySQL
  28. GROUP_CONCAT comma separator – MySQL
  29. Set page template for all pages?
  30. How to log mysql errors from wordpress core?
  31. Optimize Multiple Taxonomy Term MySQL Query?
  32. WordPress MySQL & PHP Performance
  33. What specific database privileges does WordPress need?
  34. Using source control with WordPress
  35. My WordPress site always displays a cached version of its homepage
  36. wpdb Custom Meta Data with 2 conditions
  37. Updating User Meta with SQL Query
  38. wpdb prepare syntax
  39. How to run this SQL query of wp_terms database
  40. Proper way to work with wpdb to get user’s firstname
  41. How to change post format from Aside to Image for all posts?
  42. Inserting Hundreds of Thousands of Posts at Once
  43. wp_admin edit.php slow with lots of queries
  44. How to add and SQL query of posts only published
  45. Slow Mysql Queries
  46. can database and media folder be moved to a different drive?
  47. Find duplicate posts with same slug and author
  48. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  49. Rewrite database urls
  50. writing inner join in wpdb
  51. How to get data from WordPress site sql file
  52. Unknown collation when I import a dump from an existing site into a development database?
  53. PHP script can’t connect to Database on port 3307
  54. WordPress with php5-fpm and nginx
  55. Migrating from Existing MySQL Setup to WordPress
  56. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  57. How to translate this mySQL query to $wpdb query
  58. $wpdb to insert html form information
  59. Proper usage of $wpdb->update()?
  60. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  61. Separate DB by yearly archive of WordPress
  62. What should a WordPress developer know about MySQL? [closed]
  63. Copyright: Get first and last date of post type
  64. Update MySQL query so that it functions again
  65. Is there a page length limit?
  66. Query posts by custom taxonomy and sort by post_modified
  67. WordPress $wpdb get posts from category and sort by custom meta
  68. WordPress insert query is not working : Showing no Error
  69. Some Post Content Does Not Show Up In DB Search
  70. Array Formation Issue
  71. How can I write a formal sql query to get data from a custom table
  72. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  73. WordPress $wpdb no result
  74. How can I view my site directly from WordPress dashboard?
  75. Word Press and database from another server sync
  76. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  77. When I add metadata, metavalue length is added in to the value in some cases
  78. edit_user_created_user hook – using to update Groups
  79. Changes not being reflected on new server
  80. Mysql Error in querying form entries in Gravity Form plugin
  81. WordPress database error Duplicate entry for key ‘slug’
  82. Improving performance of SQL sub-queries in WordPress
  83. MySQL – How to combine data from two tables into one?
  84. Saving custom term value to the database in new table
  85. Stop my loop to register data twice
  86. MySQL errors after a WordPress clone
  87. How to restore: Database intact but folders deleted
  88. XML RPC post produces immediate revision with odd post_date_gmt
  89. MYSQL Join on meta key value?
  90. Woocommerce: Grab total revenue of a product over all orders
  91. Complicated MySQL Query
  92. problem with quotes on new post
  93. SQL Database Lost
  94. Where other than wp-config can database access details be defined?
  95. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  96. Why does the MySQL command line tool ignore the –port parameter?
  97. How can I show user’s privileges in MySQL?
  98. Postgres equivalent to MySQL’s \G?
  99. Changing host permissions for MySQL users
  100. Possible SQL injection. How to locate and fix?

Leave a Comment