Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Mysql MySQL Create Database

Related Tutorials


 
 

Share on Google+Share on Google+

MySQL Create Database

Advertisement
This tutorial explains you how to create a database in MySQL using the MySQL Command Line Client. You can also use the Table Editor which contains both the MySQL Query Browser and MySQL Administrator, enabling the visual creation and modification of tables. It also allows you the create the MySQL database.

MySQL Create Database

                         

In this tutorial I will explains you how to create the database on MySQL Server. MySQL Database server is one of the very powerful database server which is free and also available as a enterprise version editions. There are many tools out there for easily management of the database server.

MySQL comes with the easy to use the command line tool through which you can connect to the MySQL database server and then execute the queries.

Through this tool you can connect to your database server running on the localhost (same machine) and then create the database. The SQL create database <database name> is used to create a new database on the MySQL database server.

So, you need to connect to the MySQL database server through "MySQL x.x Command Line Client". First all make sure you have MySQL 5.x or database is installed on your computer (Windows 7 or Windows 8), if it is not installed then download and install it on your machine.

Here are the steps to create a database in MySQL Server:

Step 1: Connect to the database through "MySQL x.x Command Line Client". From the Click on Start and search for MySQL Client as shown below in the Windows 7.

MySQL Command Line Client

Step 2: Enter the password to connect to the server as shown below:

MySQL Command Line Client Login

Enter the password and the click on the "Enter" button. If the login is successful it will display the following screen:

MySQL Command Line Client LoginSuccess

Step 3: Create the database. To create the database type the following command

create database mytestdb;

and ending with  semi-colon(";"), then press enter as shown below:

MySQL Command Line Client Create database

So, in this tutorial you learned how to create the database in MySQL Server. There many tools for creating and managing the database in MySQL. Here is the list of few important tools which you can use for your managing the MySQL Database.

MySQL Database front end tool:

  1. Download MySQL Workbench - This is the latest tool for editing the MySQL database. You can create databases, tables, run queries and update the data through this browser tool.

    MySQL Query Browser (Archived Versions) - MySQL Table Editor
    The MySQL Table Editor is a component of both the MySQL Query Browser and MySQL Administrator, enabling the visual creation and modification of tables. The MySQL Table Editor can be accessed from the MySQL Query Browser by right clicking on a table within the database browser and choosing the Edit Table option, or by right clicking on a database within the database browser and choosing the Create New Table option.  The MySQL Table Editor can be accessed from MySQL Administrator through the Catalogs screen. Once you have selected a database, right click on a table and choose the Edit Table option from the drop-down menu. 
                             
  2. phpMyAdmin
    phpMyAdmin is a tool developed in PHP for managing the MySQL Database. It comes with many advance features and tools for administration of data and database.
     

                         

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 18, 2008

Related Tutorials

Discuss: MySQL Create Database   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:3
rupesh kumar panda
September 17, 2011
sql

plz tell me query,delete data from table
Avinav
July 9, 2012
oracle

nice
Hannah
August 26, 2012
ZhDMjeWhvrToAd

Taking the ovrvieew, this post hits the spot
DMCA.com