{"id":13745,"date":"2017-02-06T16:13:31","date_gmt":"2017-02-06T15:13:31","guid":{"rendered":"https:\/\/supporttest.hemsida.eu\/artikel\/hur-skapar-jag-databaser-i-cpanel\/"},"modified":"2026-02-05T13:34:38","modified_gmt":"2026-02-05T12:34:38","slug":"how-do-i-create-databases-via-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/supporttest.hemsida.eu\/en\/artikel\/how-do-i-create-databases-via-cpanel\/","title":{"rendered":"How do I create databases via cPanel?"},"content":{"rendered":"\n

Our servers run MariaDB<\/a>, but cPanel still refers to the database functions as MySQL, which is why it is stated as such in the interface. For the sake of accuracy, however, the instructions here will refer to the database engine as MariaDB.<\/p>\n\n\n\n

To create databases, begin by logging on to cPanel<\/a>. Once there, you can create databases in two ways: either via a wizard accessible via the icon MySQL Database Wizard<\/code>, or manually via the icon MySQL Databases<\/code>.<\/p>\n\n\n\n

The manual method might be suitable if you already have a database for which you want to create an additional user. Otherwise, the guided method will be quicker.<\/p>\n\n\n\n

External database access<\/strong>

If you need to access the database from another server than the one you’ve created it at, you need to allow remote access. Please refer to these instructions<\/a> for more information.<\/p>\n\n\n\n

Via the MySQL Database Wizard<\/h2>\n\n\n\n
    \n
  1. Begin by logging on to cPanel<\/a>.<\/li>\n\n\n\n
  2. Click the icon MySQL Database Wizard<\/code> under Databases<\/code>.
    \"\"<\/a><\/li>\n\n\n\n
  3. First, enter a name for the database in New Database<\/code>. The name will always be based on your cPanel username, so you select the last part of the name here. In our example, we can select the part of the name following exempel_<\/code>. Then click Next Step<\/code>.
    \"\"<\/a><\/li>\n\n\n\n
  4. Then, it’s time to create a user with access to the database. Choose a Username<\/code> and a Password<\/code>. The database username will always begin with your cPanel username (just like the database name). Enter the password twice and click Create user<\/code>.
    \"\"<\/a><\/li>\n\n\n\n
  5. Grant the user privileges on the database. Most often you wish to grant all. Then click Next Step<\/code>.
    \"\"<\/a><\/li>\n\n\n\n
  6. And you’re done! You may now start using the database with the credentials you selected above.
    \"\"<\/a><\/li>\n<\/ol>\n\n\n\n

    Manually<\/h2>\n\n\n\n

    Begin by logging on to cPanel<\/a>.<\/p>\n\n\n\n

    Once there, click the icon MySQL Databases<\/code> under Databases<\/code>.<\/p>\n\n\n\n

    \"\"<\/a><\/figure>\n\n\n\n

    Creating a database<\/h3>\n\n\n\n

    First, you need to create a database and select a name for it under Create New Database<\/code>. The name will always be based on your cPanel username, so you select the last part of the name here. In our example, we can select the part of the name following exempel_<\/code>.<\/p>\n\n\n\n

    \"\"<\/a><\/figure>\n\n\n\n

    Creating a database user<\/h3>\n\n\n\n

    Now, create a database user unless you already have one from earlier. Under Add New User<\/code> you can enter the credentials for a new database user, then click Create User<\/code>.<\/p>\n\n\n\n

    \"\"<\/a><\/figure>\n\n\n\n

    Add a user to a database<\/h3>\n\n\n\n

    Finally, you need to add the user to the database you’ve created. Under Add User To Database<\/code>, you select the user and the database you wish to connect, then click the Add<\/code> button.<\/p>\n\n\n\n

    \"\"<\/a><\/figure>\n\n\n\n

    Now you will get to grant privileges for the user on the database. The most common is to grant all privileges, e.g.<\/em> in various CMSes such as WordPress and Joomla, you’ll need to grant all for everything to work properly. You can read more about MySQL privileges here<\/a>. Confirm your choices with the Make Changes<\/code> button. Your database and user are now ready to be used.<\/p>\n\n\n\n

    \"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

    To create databases, begin by logging on to cPanel. Once there, you can create databases in two ways: either via a wizard accessible via the icon MySQL Database Wizard, or manually via the icon MySQL Databases. The manual method might be suitable if you already have a database for which…<\/p>\n","protected":false},"author":12,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"ht-kb-category":[197],"ht-kb-tag":[],"class_list":["post-13745","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/ht-kb\/13745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/comments?post=13745"}],"version-history":[{"count":18,"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/ht-kb\/13745\/revisions"}],"predecessor-version":[{"id":24787,"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/ht-kb\/13745\/revisions\/24787"}],"wp:attachment":[{"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/media?parent=13745"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/ht-kb-category?post=13745"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/supporttest.hemsida.eu\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=13745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}