How to check if mysql database exists

SELECT SCHEMA_NAME
  FROM INFORMATION_SCHEMA.SCHEMATA
 WHERE SCHEMA_NAME = 'DBName'

If you just need to know if a db exists so you won’t get an error when you try to create it, simply use (From here):

CREATE DATABASE IF NOT EXISTS DBName;

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How do I restore a dump file from mysqldump?
  4. How do I quickly rename a MySQL database (change schema name)?
  5. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  6. Create a new database with MySQL Workbench
  7. How to get size of mysql database?
  8. 1052: Column ‘id’ in field list is ambiguous
  9. 1052: Column ‘id’ in field list is ambiguous
  10. difference between primary key and unique key
  11. MySQL > Table doesn’t exist. But it does (or it should)
  12. How to create a foreign key in phpmyadmin
  13. importing a CSV into phpmyadmin
  14. Is there a Profiler equivalent for MySql?
  15. How to do a batch insert in MySQL
  16. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  17. MySQL: Cloning a MySQL database on the same MySql instance
  18. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  19. Data is not constantly loading from custom wordpress table
  20. What’s a good strategy for planning WordPress DB growth?
  21. How do I load a sql.gz file to my database? (importing)
  22. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  23. MySQL ERROR 1290 (HY000) –secure-file-priv option
  24. Case statement in MySQL
  25. mysql Foreign key constraint is incorrectly formed error
  26. mysql: SOURCE error 2?
  27. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  28. MySQL foreach loop
  29. MySQL IF NOT NULL, then display 1, else display 0
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  31. MySQL Calculate Percentage
  32. Repair all tables in one go
  33. Best way to test if a row exists in a MySQL table
  34. MySQL Error 1215: Cannot add foreign key constraint
  35. How to use the keyword ‘references’ in MySQL?
  36. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  37. What are the recommended database permissions for WordPress?
  38. How can I find the source of slow queries in WordPress?
  39. Resetting comment count
  40. $wpdb and MySQL Create Trigger
  41. Changing user_nicename
  42. WordPress will not operate correctly
  43. importing data from non-wordpress mysql db
  44. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  45. if statement on database query
  46. How to execute mulitple statement SQL queries using $wpdb->query?
  47. Database with mixed collation (utf8mb4 & utf8_general_ci)
  48. Split a database will improve performance?
  49. Is it good practice to use wpdb->query() function?
  50. Migrating database / content of non-CMS site to WordPress
  51. How to Query Database for posts with certain Taxonomy Term
  52. Delete all post meta except featured image Using SQL
  53. Error while importing database
  54. How do I find which articles are missing a featured image in The WordPress database?
  55. Can I restart MySQL engine when WordPress website is live?
  56. Error: MySQL shutdown unexpectedly [closed]
  57. Why my wordpress loopback traffic while socket is setup?
  58. How to remove /year/month from uploaded medias?
  59. new multisite, old db
  60. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  61. Not connecting to database in file with multiple MySQL connections
  62. Defining the same price to all WooCommerce Products
  63. Have working sql query… trying to adjust it to use $wpdb
  64. creating new field on mysql
  65. Database Structure on Different Servers
  66. How to get INSERT errors from $wpdb?
  67. SQL query to set posts in bulk based on the post content
  68. Export Yoast Keywords from MySQL/phpMyAdmin
  69. Same database; different WordPress
  70. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  71. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  72. Fetch a single row from a custom table for to a given ID
  73. Database create or redirect
  74. Upgrade DB Loop – WordPress DB Version Conflict
  75. Button writing to MYSQL database
  76. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  77. MySQL ‘duplicate entry’ error
  78. Performing CRUD operations on front end in wordpress
  79. What is my error trying to create a new table in the database?
  80. Deleted products from woocommerce are still in the database
  81. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  82. Using wpdb to connect to a different database is not working
  83. How to show result of sql query in a page?
  84. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  85. Insert data from form to database
  86. How can I get $wpdb to show MySQL warnings?
  87. Populate custom post type/custom fields from an external database
  88. CONCAT_WS in custom sql query
  89. How to extract some part of WordPress full source code
  90. Query does not filter duplicate _sku numbers
  91. Ordering topics by most replies in X days using MYSQL statement
  92. MySQL Select within WP Page template
  93. two wordpress sites, two themes, one database, same content
  94. wp_postmeta – lot of meta fields
  95. Running WordPress from MySQL Cluster with HAPRoxy
  96. Custom query_posts() parameter
  97. Delete posts with word count less than x number of words
  98. MySQL: get post_tag items that are tags (not SEO keywords)
  99. $wpdb->get_var returns 0
  100. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)

Leave a Comment