You can set the new database as the default schema if you wish. Setting the Database as the Default Schema You will need to add tables and other database objects before you can add data. You will now be able to see the database under SCHEMAS in the left navigation pane. The following message will be displayed if the script has run successfully: The “Success” message when the script has run successfully. Review the SQL statement and click Apply: This screen allows you to review the script generated by MySQL before applying it. Enter the schema name (database name) and its default collation. Enter a Name & Default CollationĮnter a schema name (database name) and its default collation and click Apply: The “New Schema” dialog. The New Schema ButtonĬlick the “new schema” button on the MySQL Workbench toolbar: The “Create Schema” button on the MySQL Workbench toolbar. The database will now be created, and a message will display advising that the script was successful.īelow are screenshots for the above steps. Review the SQL statement and click Apply.Enter a schema name (database name) and its default collation and click Apply.Click the “new schema” button on the MySQL Workbench toolbar.To create a database in the MySQL Workbench GUI:
0 Comments
Leave a Reply. |