{"id":29996,"date":"2021-01-18T02:48:50","date_gmt":"2021-01-17T18:48:50","guid":{"rendered":"https:\/\/web.mwwsb.com.my\/pjci\/?post_type=kb&p=29996"},"modified":"2022-09-08T21:36:41","modified_gmt":"2022-09-08T13:36:41","slug":"how-to-manage-databases-and-database-users-in-cpanel","status":"publish","type":"kb","link":"https:\/\/www.casbay.com\/guide\/kb\/how-to-manage-databases-and-database-users-in-cpanel","title":{"rendered":"HOW TO: Manage databases and database users in cPanel"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

MANAGING DATABASES<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Creating Database<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

To create a MySQL database, follow these steps:<\/p>

    1. Firstly, click MySQL\u00ae Databases i<\/strong>n the Databases<\/strong> section of the cPanel home screen.<\/li>
    2. Next, type the name of the database in the New Databasetext<\/strong> box under Create New Database<\/strong>.<\/li>
    3. Lastly, click Create Database<\/strong>.<\/li><\/ol><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t

      Adding a user to a database<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t

      To add a MySQL user to a database, follow these steps:<\/p>

        1. Firstly, click MySQL\u00ae Databases<\/strong> in the Databases<\/strong> section of the cPanel home screen.<\/li>
        2. Under\u00a0Add User to Database<\/strong>, select the user that you want to add in the\u00a0User\u00a0list<\/strong> box.<\/li>
        3. In the\u00a0Database\u00a0list<\/strong> box, select the database.<\/li>
        4. Then, click Add<\/strong> checkbox to grant the user specific privileges, or click the ALL PRIVILEGES<\/strong> checkbox to grant the user all permissions to the database.<\/li>
        5. Lastly, click Make Changes<\/strong>.<\/li><\/ol><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t

          Checking and repairing a database<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t

          However, you can check MySQL databases for errors or possible corruption<\/strong>. If a database check reveals problems, you can repair the database as well.<\/p>

          To check and repair a database, follow these steps:<\/p>

            1. Firstly, click MySQL\u00ae Databases <\/strong>under the Databases<\/strong> section of the cPanel home screen.

              <\/li>
            2. To check a database<\/strong>: