Page 167 - IT-802_class_12
P. 167

10   Type the password for the root user.
            11   Click on the Next button twice.







                                                                                           10















                                                                                            11

            12   Click on the Execute button.
            13   Click on the Finish button.

            Once the setup is downloaded, double-click on it to start the installation.

            1.4.2 Creating a Database
            The CREATE DATABASE command is used to create a database in MySQL.

            Syntax:

            CREATE DATABASE Database_Name;
            Example:

            CREATE DATABASE SCHOOL;
            After creating a database in MySQL, we need to open it by using the following command:

            USE Database_Name;
            Example:

            USE SCHOOL;
            Now, we can create tables in the database.

            1.4.3 Show Database

            This command helps to show all databases.
            Syntax:

            SHOW DATABASES;
            Output:
            +--------------------+
            | Database           |
            +--------------------+
            | information_schema |
            | mysql              |
            | performance_schema |
            | school             |
            | sys                |
            +--------------------+
                                                                                 Database Concepts—RDBMS Tool   165
   162   163   164   165   166   167   168   169   170   171   172