Create a new database with MySQL Workbench

  1. Launch MySQL Workbench.
  2. On the left pane of the welcome window, choose a database to connect to under “Open Connection to Start Querying”.
  3. The query window will open. On its left pane, there is a section titled “Object Browser”, which shows the list of databases. (Side note: The terms “schema” and “database” are synonymous in this program.)
  4. Right-click on one of the existing databases and click “Create Schema…”. This will launch a wizard that will help you create a database.

If you’d prefer to do it in SQL, enter this query into the query window:

CREATE SCHEMA Test

Press CTRL + Enter to submit it, and you should see confirmation in the output pane underneath the query window. You’ll have to right-click on an existing schema in the Object panel and click “Refresh All” to see it show up, though.

Related Posts:

  1. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  5. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  6. String concatenation in MySQL
  7. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  8. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  9. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  10. How do I restore a dump file from mysqldump?
  11. How do I quickly rename a MySQL database (change schema name)?
  12. Error Code: 2013. Lost connection to MySQL server during query
  13. How to get size of mysql database?
  14. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  15. 1052: Column ‘id’ in field list is ambiguous
  16. 1052: Column ‘id’ in field list is ambiguous
  17. difference between primary key and unique key
  18. MySQL error code: 1175 during UPDATE in MySQL Workbench
  19. Cannot connect to Database server (mysql workbench)
  20. How to create a foreign key in phpmyadmin
  21. importing a CSV into phpmyadmin
  22. How to check if mysql database exists
  23. Is there a Profiler equivalent for MySql?
  24. How to do a batch insert in MySQL
  25. Is there a naming convention for MySQL?
  26. How to unblock with mysqladmin flush hosts
  27. MySQL: Cloning a MySQL database on the same MySql instance
  28. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  29. Data is not constantly loading from custom wordpress table
  30. What’s a good strategy for planning WordPress DB growth?
  31. How do I load a sql.gz file to my database? (importing)
  32. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  33. Rename a table in MySQL
  34. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  35. Can’t find mysqladmin on Mac OSX 10.6.8
  36. When to use SELECT … FOR UPDATE?
  37. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  38. Escape string Python for MySQL
  39. SQL ZOO List each continent and the name of the country that comes first alphabetically
  40. Can’t connect to MySQL server on ‘127.0.0.1’ (61) on Mac
  41. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  42. How to install Python MySQLdb module using pip?
  43. Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
  44. MySQL Workbench Dark Theme
  45. Dump all tables in CSV format using ‘mysqldump’
  46. mysqlworkbench giving version error on exporting database
  47. If variable equals value php [duplicate]
  48. mysqldump data only
  49. PHP date() format when inserting into datetime in MySQL
  50. WordPress mysqli and PDO
  51. How to fetch Data in WordPress using MySQLi or $wpdb
  52. Connect to database using wordpress wp-config file
  53. How to properly insert data into custom table via plugin
  54. Alternative to mysql_real_escape_string
  55. Same option_id=0 for 2 options in wp_options?
  56. How can I call a row of user specific data from a custom table added to the WP Database
  57. How to merge local and live databases?
  58. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  59. Emojis getting converted to “?”
  60. greatest() function returns undefined property
  61. Join new table with SQL query
  62. wpdb custom post_type problem
  63. Why doesn’t this code add a table to my database?
  64. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  65. Can Someone Help Me Fix This WordPress Missing Argument Error?
  66. Help With MySQL to WPDB Query Conversion
  67. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  68. SQL Database, repeated tables?
  69. Create table from array with prepare
  70. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  71. Upload media only to DB
  72. How and where is wordpress adding mySQL content to database?
  73. Most commented posts by time period (last 12h, last 24h and etc)
  74. Using AND and bracket grouping in SQL not working
  75. How to list all categories and their IDs using SQL query?
  76. Setting up WordPress Locally on WAMP for a new site (with one already)
  77. How to create more than one new wpdb object?
  78. WordPress VIP realpath Alternative?
  79. Pull post name from value of a specific meta key
  80. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  81. PHP variables in mysql query
  82. How to fix the amount of comments displayed for each post?
  83. local wordpress broke after changing URL
  84. SQL query to change custom field in WordPress database
  85. MySQL Actibity without any active visitors via Google Analytics
  86. How to configure WordPress Database for CentOS 7
  87. How to create index (sql) to a meta_key?
  88. Display MySQL as part of a Page
  89. Hang Up Followed By Can’t select database
  90. WP Meta Query – mixed AND / OR query doesn’t work
  91. Second completely independent and disposable WordPress installation in subdirectory?
  92. get_results suddenly not working on a single table
  93. Query sql for truncate post_content in wp_posts table
  94. Foreach only outputs if id is 0
  95. How to pass username into form that sends data to database
  96. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  97. remove wordpress post links
  98. SQL get last entry of a specific gravity form
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?

Leave a Comment