{"id":684,"date":"2025-07-21T15:14:29","date_gmt":"2025-07-21T15:14:29","guid":{"rendered":"https:\/\/yegara.com\/en\/guide\/?p=684"},"modified":"2025-07-21T15:14:29","modified_gmt":"2025-07-21T15:14:29","slug":"how-to-create-database-and-import-your-filelike-sql-filein-cpanel","status":"publish","type":"post","link":"https:\/\/yegara.com\/en\/guide\/how-to-create-database-and-import-your-filelike-sql-filein-cpanel\/","title":{"rendered":"How to create database and import your file(like.sql file)in Cpanel"},"content":{"rendered":"\n<p class=\"has-large-font-size\">Step 1: Log in to Cpanel<\/p>\n\n\n\n<p>Go to yourdomain.com\/cpanel or use login to  cpanel button from your yegara host dashboard<\/p>\n\n\n\n<p class=\"has-large-font-size\">Step 2: Create MYSQL database<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In Cpanel dashboard scroll to database section<\/li>\n\n\n\n<li>Click &#8220;database wizard&#8221;<\/li>\n\n\n\n<li>Under create new database \n<ul class=\"wp-block-list\">\n<li>Enter a name (e.g,mydb)and click &#8220;next step&#8221;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"456\" src=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-19-1024x456.png\" alt=\"\" class=\"wp-image-685\" srcset=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-19-1024x456.png 1024w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-19-300x134.png 300w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-19-768x342.png 768w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-19.png 1351w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-large-font-size\">Step 3: Create database user<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add a username and password<\/li>\n\n\n\n<li>Click on &#8220;create user&#8221;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-20-1024x408.png\" alt=\"\" class=\"wp-image-686\" srcset=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-20-1024x408.png 1024w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-20-300x119.png 300w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-20-768x306.png 768w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-20.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-large-font-size\">Step 4: Add user to the database<\/p>\n\n\n\n<p>Select all privileges and on click &#8220;make change&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"470\" src=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-21-1024x470.png\" alt=\"\" class=\"wp-image-687\" srcset=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-21-1024x470.png 1024w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-21-300x138.png 300w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-21-768x353.png 768w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-21.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-large-font-size\">Step 5: Import your database file<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go back to the Cpanel dashboard<\/li>\n\n\n\n<li>Under database,click&#8221; phpmyadmin&#8221;.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"596\" src=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-22-1-1024x596.png\" alt=\"\" class=\"wp-image-693\" srcset=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-22-1-1024x596.png 1024w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-22-1-300x175.png 300w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-22-1-768x447.png 768w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-22-1.png 1071w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the left sidebar,click on the name of your new database<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"496\" src=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-23-1024x496.png\" alt=\"\" class=\"wp-image-689\" srcset=\"https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-23-1024x496.png 1024w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-23-300x145.png 300w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-23-768x372.png 768w, https:\/\/yegara.com\/en\/guide\/wp-content\/uploads\/2025\/07\/Screenshot-23.png 1324w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the &#8220;import&#8221; tab<\/li>\n\n\n\n<li>Click &#8220;choose file&#8221; and select your .sql file<\/li>\n\n\n\n<li>Scroll down and click&#8221; import&#8221;<\/li>\n<\/ul>\n\n\n\n<p class=\"has-large-font-size\">DONE!<\/p>\n\n\n\n<p>You are now <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Created a database and user<\/li>\n\n\n\n<li>Given proper access<\/li>\n\n\n\n<li>Imported your sql file successfully <\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Step 1: Log in to Cpanel Go to yourdomain.com\/cpanel or use login to cpanel button from your yegara host dashboard Step 2: Create MYSQL database Step 3: Create database user Step 4: Add user to the database Select all privileges and on click &#8220;make change&#8221; Step 5: Import your database file DONE! You are now<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-684","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/posts\/684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/comments?post=684"}],"version-history":[{"count":6,"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/posts\/684\/revisions"}],"predecessor-version":[{"id":722,"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/posts\/684\/revisions\/722"}],"wp:attachment":[{"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/media?parent=684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/categories?post=684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yegara.com\/en\/guide\/wp-json\/wp\/v2\/tags?post=684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}