{"id":2331,"date":"2026-04-01T23:38:37","date_gmt":"2026-04-01T23:38:37","guid":{"rendered":"https:\/\/veerhost.com\/docs\/how-to-create-mysql-database-cpanel\/"},"modified":"2026-07-02T23:03:47","modified_gmt":"2026-07-02T23:03:47","slug":"how-to-create-mysql-database-cpanel","status":"publish","type":"docs","link":"https:\/\/veerhost.com\/de\/docs\/getting-started\/how-to-create-mysql-database-cpanel\/","title":{"rendered":"How to Create and Manage MySQL Databases in cPanel"},"content":{"rendered":"

Overview<\/h2>\n\n\n\n

Most web applications \u2014 including WordPress, Joomla, Magento, and custom PHP scripts \u2014 require a MySQL database<\/strong> to store content and settings. cPanel makes it easy to create databases, database users, and assign permissions without needing to touch the command line.<\/p>\n\n\n\n

Step 1 \u2014 Create a New Database<\/h2>\n\n\n\n
    \n
  1. Log in to your cPanel<\/strong> account.<\/li>\n
  2. In the Databases<\/strong> section, click MySQL Databases<\/strong>.<\/li>\n
  3. Under Create New Database<\/strong>, type a name for your database (e.g., mysite_db<\/code>).<\/li>\n
  4. Click Create Database<\/strong>.<\/li>\n<\/ol>\n\n\n\n

    Note: cPanel will automatically prefix the database name with your cPanel username (e.g., cpuser_mysite_db<\/code>). This is normal.<\/p>\n\n\n\n

    Step 2 \u2014 Create a Database User<\/h2>\n\n\n\n
      \n
    1. Scroll down to MySQL Users<\/strong>.<\/li>\n
    2. Under Add New User<\/strong>, enter a username and a strong password.<\/li>\n
    3. Click Create User<\/strong>.<\/li>\n<\/ol>\n\n\n\n

      Like databases, the username will be prefixed automatically (e.g., cpuser_myuser<\/code>).<\/p>\n\n\n\n

      Step 3 \u2014 Assign the User to the Database<\/h2>\n\n\n\n
        \n
      1. Scroll down to Add User to Database<\/strong>.<\/li>\n
      2. Select your newly created user and your database from the dropdowns.<\/li>\n
      3. Click Add<\/strong>.<\/li>\n
      4. On the next screen, select All Privileges<\/strong>, then click Make Changes<\/strong>.<\/li>\n<\/ol>\n\n\n\n

        Your database is now ready to use. Use the full prefixed names (e.g., cpuser_mysite_db<\/code> and cpuser_myuser<\/code>) when connecting your application.<\/p>\n\n\n\n

        How to Manage Your Database with phpMyAdmin<\/h2>\n\n\n\n

        cPanel includes phpMyAdmin<\/strong>, a web-based interface for managing your databases visually.<\/p>\n\n\n\n

          \n
        1. In cPanel, click phpMyAdmin<\/strong> (under the Databases section).<\/li>\n
        2. Select your database from the left sidebar.<\/li>\n
        3. From here you can browse tables, run SQL queries, import\/export data, and more.<\/li>\n<\/ol>\n\n\n\n

          How to Delete a Database<\/h2>\n\n\n\n

          To remove a database you no longer need:<\/p>\n\n\n\n

            \n
          1. Go to MySQL Databases<\/strong> in cPanel.<\/li>\n
          2. Scroll to the Current Databases<\/strong> list.<\/li>\n
          3. Click Delete<\/strong> next to the database you want to remove.<\/li>\n
          4. Confirm the deletion.<\/li>\n<\/ol>\n\n\n\n\n

            \u26a0\ufe0f Warning:<\/strong> Deleting a database is permanent. Always take a backup first via phpMyAdmin (Export<\/em> tab) before deleting anything.<\/p>\n\n\n\n\n

            WordPress Database Details<\/h2>\n\n\n\n

            When connecting WordPress to your database, you will need to enter these details in wp-config.php<\/code>:<\/p>\n\n\n\n