MySQL-create-Database

Create Database:-

•  In our last tutorial we have configured mysql setup now we are ready to start work with database.
• In this tutorial we will learn how to create database in mysql and how to use them.
• when we install Mysql in our computer it by default create some databases and you can see tham  by command

           Mysql>  show databases;

                      
                         

note- ; to terminate the line of command

• Basic syntax of CREATE DATABASE QUERY in mysql is

         create database database_name;

   for example:-

      mysql> create database tutorialspoint4java;

      mysql> show databases;

now database has been created with name tutorialspoint4java

                      

• In next tutorial we will learn how to create table in database

MySQL-Introduction

• Mysql free MySQL tutorial for beginners who want to learn mysql.
• Mysql is RDBMS(Relational Database managment System) type of database.
• Mysql Is Open source database and it is also known By "My Sequal".
• To use Mysql database you need to install Mysql database software setup on your computer and you can download this sql database softwate tool from  http://dev.mysql.com/downloads/

How to Install Mysql:-

1. To install mysql, Download sql batabase setup from http://dev.mysql.com/downloads/

2. Double click on setup file and click 'next'

3.read term and license agreement , check it and click   'next'

4. click on complete button to install complete package.

5. click 'next'

6. again click 'next'.

7. Launch mysql configuration wizart automatical and click 'finish'

8. click on 'next'

9. check standard configuration and click on 'next'.

10. click check box to set windows path and click 'next'.

11. Enter your password in my case it is 'root','root' and click 'next'

12. click on 'execute' button and 'finish'

13. now your you can use Mysql and manage you database. 

14. click start->run->mysql and enter