{"id":2197,"date":"2023-08-11T00:41:33","date_gmt":"2023-08-10T16:41:33","guid":{"rendered":"https:\/\/ebuildhost.com\/?post_type=docs&p=2197"},"modified":"2023-08-11T00:41:33","modified_gmt":"2023-08-10T16:41:33","slug":"create-database-user-and-assign-permissions-in-cpanel","status":"publish","type":"docs","link":"https:\/\/ebuildhost.com\/en\/docs\/products\/web-hosting\/cpanel\/cpanel-databases\/create-database-user-and-assign-permissions-in-cpanel\/","title":{"rendered":"Create Database, User, and Assign Permissions in cPanel"},"content":{"rendered":"\n

In this tutorial, we will explore how to create a database, create a user, and assign permissions in cPanel. These steps are vital in setting up your website or application.<\/p>\n\n\n\n

Step 1: Log in to cPanel<\/h2>\n\n\n\n

First, you’ll need to log into your cPanel account. You can find the cPanel URL in our welcome letter.<\/p>\n\n\n\n

Enter your cPanel username and password, then click “Log in”.<\/p>\n\n\n\n

\"\"
<\/figcaption><\/figure>\n\n\n\n

Or you can log in to cPanel by using our Client Area one-click login feature.<\/p>\n\n\n\n

Services -> My Services -> Select your hosting service -> In Actions you can find “Login to cPanel”<\/p>\n\n\n\n

\"\"
<\/figcaption><\/figure>\n\n\n\n

Step 2: Locate the MySQL Databases or Database Wizard<\/h2>\n\n\n\n

On your cPanel home page, find the “Databases” section. In this section, you should see the “MySQL Databases” and “MySQL Database Wizard” options.<\/p>\n\n\n\n

\"\"
<\/figcaption><\/figure>\n\n\n\n

If you are creating a database for the first time, we recommend using the “MySQL Database Wizard” because this tool will guide you through all the steps, including creating a database, creating a user, and assigning permissions.<\/p>\n\n\n\n

Step 3: Use the MySQL Database Wizard to Create a Database and User<\/h2>\n\n\n\n

Click on the “MySQL Database Wizard”, then follow the wizard’s instructions.<\/p>\n\n\n\n

    \n
  1. Enter the name of the database in the “New Database” field, then click “Next Step”.<\/li>\n\n\n\n
  2. On the “Add User” page, enter a username and password, then click “Create User”.<\/li>\n\n\n\n
  3. On the “Manage User Privileges” page, select the privileges you wish to grant to the user, then click “Next Step”.<\/li>\n<\/ol>\n\n\n\n

    Step 4: Confirm the Database and User Have Been Created Successfully<\/h2>\n\n\n\n

    On the final page, you should see a message saying that the database and user have been created successfully. Make a note of these details as you may need them when setting up your website or application.<\/p>\n\n\n\n

    Conclusion<\/h2>\n\n\n\n

    Congratulations! You now know how to create a database, create a user, and assign permissions in cPanel. If you encounter any difficulties along the way, don’t hesitate to contact our customer service.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this tutorial, we will explore how to create a datab […]<\/p>\n","protected":false},"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","meta":{"footnotes":""},"docs_categories":[50],"class_list":["post-2197","docs","type-docs","status-publish","format-standard","hentry","docs_categories-cpanel-databases"],"_links":{"self":[{"href":"https:\/\/ebuildhost.com\/cn\/wp-json\/wp\/v2\/docs\/2197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ebuildhost.com\/cn\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ebuildhost.com\/cn\/wp-json\/wp\/v2\/types\/docs"}],"version-history":[{"count":1,"href":"https:\/\/ebuildhost.com\/cn\/wp-json\/wp\/v2\/docs\/2197\/revisions"}],"predecessor-version":[{"id":2202,"href":"https:\/\/ebuildhost.com\/cn\/wp-json\/wp\/v2\/docs\/2197\/revisions\/2202"}],"wp:attachment":[{"href":"https:\/\/ebuildhost.com\/cn\/wp-json\/wp\/v2\/media?parent=2197"}],"wp:term":[{"taxonomy":"docs_categories","embeddable":true,"href":"https:\/\/ebuildhost.com\/cn\/wp-json\/wp\/v2\/docs_categories?post=2197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}