- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Create a new database with MySQL Workbench?
152 Lectures 16 hours
87 Lectures 5.5 hours
To create a new database with MySQL Workbench, you need to launch MySQL workbench. The screenshot is as follows.
Now, let us test connection with MySQL. Follow the below steps −
Database->Connect to database (Ctrl +U).
The following is the screenshot that displays the “Connect to Database” dialog box. Add password to continue.
After that, you need to press the OK button twice to establish a connection.
Now, to create a database, you need to click the symbol shown in the following screenshot −
After clicking the symbol, you will get the following wizard to create a database −
In the above wizard, you need to give the database name. I have given the database name “Education”.
Now, you need to press the “Apply” button.
After pressing the apply button, we will get another wizard as shown above. This itself states that we have successfully created the database. You can check whether the database has been created or not under the “Schemas” tab as shown in the following screenshot −
- Create a stored Procedures using MySQL Workbench?
- How to take MySQL database backup using MySQL Workbench?
- How to get ER model of database from server with MySQL Workbench?
- How to create a new database in MongoDB?
- Can we create a database with a numeric name with MySQL?
- Create a new user with password in MySQL 8?
- Create a new table in MySQL with specific options with DEFAULT?
- How can we create a new database by using mysqladmin?
- Which PHP function is used to create a new database?
- Create a database in MySQL from Java?
- How can we create a new database by using PHP script?
- Declare syntax error in MySQL Workbench?
- How to create a new table from merging two tables with MySQL union?
- Connecting to a MySQL database with Java
- Use workbench along with SAP Business One