So, if the name of the database does not exist in MySQL, then run the following command in MySQL shell to create a new database: CREATE DATABASE databasename However, if the name of the database already existed. Use the MySQL DROP DATABASE statement to delete a database. One is whether the database’s name already existed in MySQL or not.If you view the schemas pane, you will see that the testdb2 is not on the list anymore. Because the testdb2 is an empty database, the number of affected rows is zero. MySQL returns the following output indicating that the database is dropped successfully. If you choose Drop Now, it’ll delete the database immediately.įourth, once you are sure that the SQL statement is going to drop the right database, you can click the Execute button to execute the statement. If you choose Review SQL, you’ll see the SQL statement that will be executed.
Launch the MySQL Workbench application and go to Database >. Third, MySQL Workbench displays a dialog to confirm the deletion. Implementation In this step, we will connect to the database you created using MySQL Workbench.
#Create new mysql database workbench how to#
This contains information about the target server, including how to connect. Select the newly created database, double click on it, and you will get the sub-menu under the database. In order to administer your MySQL Server you need to first create a Server Instance. Here, you can see all the previously created databases. Select your connection and click Continue. Then, go to the Navigation tab and click on the Schema menu. MySQL Workbench Community Edition Select Reverse Engineer from the Database menu. Second, right-click the database that you want to remove, for example, testdb2 and choose the Drop Schema. option. Open the MySQL Workbench and logged in using username and password.
DROP DATABASE using MySQL Workbenchįirst, launch the MySQL workbench and log in to the MySQL Server. Next, enter the information to connect to the database. Once the application has started, click the + icon on the top left of the screen to create a MySQL connection. MySQL returned zero affected rows indicating that the testdb database has no tables. Now that you have the credentials for the database handy, you can start MySQL Workbench and set up your connection.
#Create new mysql database workbench code#
Query OK, 0 rows affected (0.03 sec) Code language: Shell Session ( shell )
0 kommentar(er)
