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.
Step 2: Enter the password to connect to the server as shown below:
Enter the password and the click on the "Enter" button. If the login is successful it will display the following screen:
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:
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:
Posted on: December 18, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles