{"id":679,"date":"2018-10-17T18:52:41","date_gmt":"2018-10-17T13:22:41","guid":{"rendered":"https:\/\/awpguide.com\/?p=679"},"modified":"2018-10-17T22:11:46","modified_gmt":"2018-10-17T16:41:46","slug":"how-to-create-a-database-using-cpanel","status":"publish","type":"post","link":"https:\/\/awpguide.com\/wp-guides\/how-to-create-a-database-using-cpanel\/","title":{"rendered":"How To Create a Database Using cPanel"},"content":{"rendered":"

You know database. We are using those for storing our WordPress websites data like users, posts, pages, and other related important things. If you are installing WordPress manually, you may want to create a MySQL database and user account manually.\u00a0In this post, we are going to show you how can you create a database using cPanel.<\/p>\n

How To Create a Database Using cPanel<\/h2>\n

First of all, log in to your website’s cPanel.<\/p>\n

\"How<\/p>\n

Now go to the MySQL databases section.<\/p>\n

\"database<\/p>\n

Enter a database name and click on create the database.<\/p>\n

\"create<\/p>\n

Your server will create a new database for you.<\/p>\n

\"new<\/p>\n

So we have successfully created a database. All we need now is, create a user and assign\u00a0the user for the database. Go to the bottom page. There, you can see a section for creating a user. Enter your username, user password and create the user.<\/p>\n

\"create<\/p>\n

Successfully created the user!<\/p>\n

\"MySQL<\/p>\n

Now comes the main part. We have created a database and a user. Now, add the user to the database.<\/p>\n

\"add<\/p>\n

You will need to choose the privileges. Select all of them and update the settings.<\/p>\n

\"MySQL<\/p>\n

You can see the user is assigned to your newly created database.<\/p>\n

\"mysql<\/p>\n

You can use this database for storing your website data.<\/p>\n

If you are still having trouble, you can contact your web hosting company. They will probably help you to do it.<\/p>\n

We hope you found this post useful and enjoyed the read. If you did, please consider sharing this post with your friends and fellow bloggers on social media. For more interesting guides and product reviews, check out our blog section<\/a>.<\/p>\n

If you need to create an FTP account, check out our guide on how to create an FTP account in cPanel<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

You know database. We are using those for storing our WordPress websites data like users, posts, pages, and other related important things. If you are installing WordPress manually, you may want to create a MySQL database and user account manually.\u00a0In this post, we are going to show you how can you create a database using… Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":813,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/posts\/679"}],"collection":[{"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/comments?post=679"}],"version-history":[{"count":0,"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/posts\/679\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/media\/813"}],"wp:attachment":[{"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/media?parent=679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/categories?post=679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/awpguide.com\/wp-json\/wp\/v2\/tags?post=679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}