{"id":429,"date":"2020-08-29T08:33:33","date_gmt":"2020-08-29T02:48:33","guid":{"rendered":"http:\/\/babal.host\/blog\/?p=429"},"modified":"2023-05-09T13:01:34","modified_gmt":"2023-05-09T07:16:34","slug":"how-to-create-a-database-and-user-and-link-them-using-cpanel","status":"publish","type":"post","link":"https:\/\/babal.host\/blog\/how-to-create-a-database-and-user-and-link-them-using-cpanel\/","title":{"rendered":"How to create a database and user and link them using cPanel?"},"content":{"rendered":"\r\n<p>We create the database for storing our data in tables and managing them in proper order. Here is the step by step description about creating the database and user and linking them using cPanel.<br \/><br \/><strong>Video for creating Database and User and link then in cPanel:<\/strong><\/p>\r\n<p><iframe loading=\"lazy\" title=\"Youtube Video Player\" src=\"https:\/\/www.youtube.com\/embed\/PCa_dix99Ew\" width=\"100%\" height=\"500pt\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\r\n<p><strong><br \/>Blog for creating Database and User and link then in cPanel:<\/strong><\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>First, open your cPanel and search for databases table and then click on MySQL Databases.<br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"121\" class=\"wp-image-432\" style=\"width: 600px;\" src=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Finding-MySQL-Database.jpg\" alt=\"MySQL Database\" srcset=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Finding-MySQL-Database.jpg 963w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Finding-MySQL-Database-300x60.jpg 300w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Finding-MySQL-Database-768x155.jpg 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li>\r\n<li>Enter your database name and then click on the create user button.<br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"290\" class=\"wp-image-434\" style=\"width: 600px;\" src=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/creating-database.jpg\" alt=\"creating database named babal in cpanel\" srcset=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/creating-database.jpg 1365w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/creating-database-300x145.jpg 300w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/creating-database-1024x494.jpg 1024w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/creating-database-768x371.jpg 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li>\r\n<li>You will get database creation successful message.<br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"118\" class=\"wp-image-435\" style=\"width: 600px;\" src=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/successful-message-after-database-creation.jpg\" alt=\"successful message after database creation\" srcset=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/successful-message-after-database-creation.jpg 1257w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/successful-message-after-database-creation-300x59.jpg 300w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/successful-message-after-database-creation-1024x202.jpg 1024w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/successful-message-after-database-creation-768x152.jpg 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li>\r\n<li>Scroll down, after going back. Create a username of your choice and set password and click on the create user button. <br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"288\" class=\"wp-image-436\" style=\"width: 600px;\" src=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Creating-user-for-database.jpg\" alt=\"Creating user for database\" srcset=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Creating-user-for-database.jpg 1365w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Creating-user-for-database-300x144.jpg 300w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Creating-user-for-database-1024x491.jpg 1024w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/Creating-user-for-database-768x369.jpg 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li>\r\n<li>Scroll down and go to this section. Select the user you want to add and select the database for the above-selected users. And click on the add button to add.<br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"195\" class=\"wp-image-437\" style=\"width: 600px;\" src=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/adding-user-to-database.jpg\" alt=\"adding user to database\" srcset=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/adding-user-to-database.jpg 1194w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/adding-user-to-database-300x98.jpg 300w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/adding-user-to-database-1024x334.jpg 1024w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/adding-user-to-database-768x250.jpg 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li>\r\n<li>After clicking the add button, this page appears. Tick on the all privileges and click on make changes.<br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"397\" class=\"wp-image-438\" style=\"width: 600px;\" src=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/giving-privileges-to-user.jpg\" alt=\"Giving Privileges to User of the Database\" srcset=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/giving-privileges-to-user.jpg 990w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/giving-privileges-to-user-300x198.jpg 300w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/giving-privileges-to-user-768x508.jpg 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li>\r\n<li>You will get the successful message after making changes.<br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"73\" class=\"wp-image-439\" style=\"width: 600px;\" src=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/success-message-for-giving-privileges.jpg\" alt=\"success message for giving privileges\" srcset=\"https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/success-message-for-giving-privileges.jpg 377w, https:\/\/babal.host\/blog\/wp-content\/uploads\/2020\/01\/success-message-for-giving-privileges-300x37.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li>\r\n<\/ol>\r\n","protected":false},"excerpt":{"rendered":"<p>We create the database for storing our data in tables and managing them in proper order. Here is the step by step description about creating the database and user and linking them using cPanel. Video for creating Database and User and link then in cPanel: \ufeff Blog for creating Database and User and link then [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":444,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-429","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-babal-guide"],"_links":{"self":[{"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/posts\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/comments?post=429"}],"version-history":[{"count":5,"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":1362,"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/posts\/429\/revisions\/1362"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/media\/444"}],"wp:attachment":[{"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/media?parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/categories?post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/babal.host\/blog\/wp-json\/wp\/v2\/tags?post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}