{"id":129988,"date":"2022-11-22T10:29:36","date_gmt":"2022-11-22T10:29:36","guid":{"rendered":"https:\/\/phppot.com\/?p=20034"},"modified":"2022-11-22T10:29:36","modified_gmt":"2022-11-22T10:29:36","slug":"phpmyadmin-how-to-create-a-database-2","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2022\/11\/22\/phpmyadmin-how-to-create-a-database-2\/","title":{"rendered":"phpMyAdmin \u2013 How to Create a Database?"},"content":{"rendered":"
by Vincy<\/a>. Last modified on November 22nd, 2022.<\/div>\n

PHPMyAdmin is one of the widely used database clients for PHP MySQL developers. It provides a simple user interface that can be easily adapted by beginners.<\/p>\n

We can blindly say that PHPMyAdmin as the de-facto database client used by PHP developers for MySQL \/ MariaDB. It is hugely popular and that is because of its simplicity and ease of use.<\/p>\n

It allows many database operations. Example,<\/p>\n

    \n
  1. Creating databases and the corresponding tables.<\/li>\n
  2. Adding and managing data.<\/li>\n
  3. Altering the existing structure and attributes defined.<\/li>\n
  4. Import, and export operations.<\/li>\n<\/ol>\n

    In this article, we will see how to create a MySQL database using PHPMyAdmin.<\/p>\n

    How to create a database?<\/h2>\n

    First login to the PHPMyAdmin client to go to the database control panel.<\/p>\n

    \"phpmyadmin<\/p>\n

    After login, it redirects to the PHPMyAdmin control panel which allows doing the following.<\/p>\n

      \n
    1. To manage and manipulate MySQL database assets.<\/li>\n
    2. To perform CRUD or other database-related operations.<\/li>\n<\/ol>\n

      \"phpmyadmin<\/p>\n

      If you want to see code to perform the MySQL database CRUD operations from a PHP application<\/a>, the linked article has the source,<\/p>\n

      Ways to create a database using PHPMyAdmin<\/h2>\n

      There are 4 ways to create a new MySQL database using the PHPMyAdmin client interface.<\/p>\n

        \n
      1. Via the left panel navigation.<\/li>\n
      2. Via the header tab control navigation.<\/li>\n
      3. By executing a CREATE statement via the SQL tab.<\/li>\n
      4. By importing a CREATE statement SQL script via the Import tab.<\/li>\n<\/ol>\n

        1. Create database via left panel<\/h2>\n

        In the PHPMyAdmin left panel, it contains a New link. It redirects to the page to create a new database.<\/p>\n

        2. Create database via header tab<\/h2>\n

        The PHPMyAdmin UI shows tabs like Database, Import, Export and more. The Database tab redirects to show a list of existing databases with an option to create a new one.<\/p>\n

        Both of these navigation controls will display the UI as shown in the figure.<\/p>\n

        \"database<\/p>\n

        The database create-form shows two fields.<\/p>\n

          \n
        1. To type the name of the database to be created.<\/li>\n
        2. To choose a collation that is encoding type.<\/li>\n<\/ol>\n

          In the above screenshot, the utf8_unicode_ci collation is selected.<\/p>\n

          The other two methods are for the one who has the SQL script for creating a new MySQL database.<\/p>\n

          Sometimes the database SQL will be provided. In that case, it is not required to use the interface to input the database name and the collation.<\/p>\n

          3. Create database via SQL tab, by running a CREATE SQL query<\/h2>\n

          Choose the SQL tab from the PHPMyAdmin header. It will show a textarea to paste the CREATE database query.<\/p>\n

          Then, execute the entered query to see the created database among the existing list.<\/p>\n

          \"phpmyadmin<\/p>\n

          4. Create database via Import tab, by uploading a SQL script<\/h2>\n

          If you have the database CREATE statement Choose the Import tab from the PHPMyAdmin header. Then browse the SQL script that contains the CREATE statement.<\/p>\n

          Then click the \u201cGo\u201d button to process the import. It will result in displaying a new database imported.<\/p>\n

          \"phpmyadmin<\/p>\n

          We have seen PHP code for importing Excel data into a database<\/a> using a custom code.<\/p>\n

          After creating a MySQL database<\/h2>\n

          After creating a MySQL database using PHPMyAdmin, the next job is to start adding the tables.<\/p>\n

          The PHPMyAdmin has the option to \u201cCheck privileges\u201d to map roles and MySQL database operations.<\/p>\n

          But, this is a rarely used feature. If the database is associated with more than one user, then this feature will be used.<\/p>\n

          How to create tables in a database?<\/h2>\n

          After creating a database, the PHPMyAdmin shows a form to a create table. That form show fields to enter the table name and the number of columns of the table.<\/p>\n

          \"create<\/p>\n

          After specifying the table name and the \u201cNumber of columns\u201d, the PHPMyAdmin panel will show inputs to add the table column specification.<\/p>\n

          See the following screen that is added with the column names with their corresponding types and more details.<\/p>\n

          \"create<\/p>\n

          Add user accounts and set privileges<\/h2>\n

          Select the \u201cUser accounts\u201d tab to see the number of existing user accounts. The PHPMyAdmin also allows adding a new user via the interface.<\/p>\n

          The \u201cCreate user\u201d page will have the option to select the user account details and set the permission to perform operations like,<\/p>\n