Jan

Creating Database in MySQL

There are a few ways to create a database (known as schema) in MySQL, such as using command line or third party software.

Using Command Line
If we decide to use command line, then we must know the syntax to create it. It’s pretty simple: CREATE DATABASE database_name. Of course we should have a MySQL account which has privilege to create a database.

Example:

mysql> CREATE DATABASE dagunetdb;

Don’t forget the semicolon, then press Enter. It’s Done.

Using PHPMyAdmin
PHPMyAdmin is a web-based application which is used to manage databases. PHPMyAdmin is written in PHP Language. It can be downloaded here. Don’t worry, it’s free of charge. To create a database, you need to login to PHPMyAdmin (You need MySQL account which has privilege to create a database). In the front page, there is a text box to fill the database name. If you have typed it, click Create button. It’s done.

Create database using PHPMyAdmin

Using MySQL Query Browser
PHPMyAdmin is a web-based application, but MySQL Query Browser is desktop-based application. This software is developed by mysql.com. And it’s free also. Download MySQL Query Browser here. To create a database is as simple as pressing Ctrl + N. Type database name in pop-up window. Click OK. It’s done.