{"id":862,"date":"2018-12-26T10:40:27","date_gmt":"2018-12-26T10:40:27","guid":{"rendered":"https:\/\/new.hostitsmart.com\/blog\/?p=862"},"modified":"2021-02-04T09:26:54","modified_gmt":"2021-02-04T09:26:54","slug":"creating-database-in-centos-web-panel","status":"publish","type":"post","link":"https:\/\/new.hostitsmart.com\/blog\/creating-database-in-centos-web-panel\/","title":{"rendered":"Creating Database in Centos Web Panel"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-863 aligncenter\" src=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/00.png\" alt=\"\" width=\"596\" height=\"249\" srcset=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/00.png 596w, https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/00-300x125.png 300w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/p>\n<p>In this article, we will be explaining to you about creating the new database and user. A user can create the database using root or user login.<\/p>\n<p><strong>Related Blog:\u00a0<a href=\"https:\/\/new.hostitsmart.com\/blog\/five-best-open-source-control-panels-for-servers\/\">Five Best Open Source Control Panels for Servers<\/a><\/strong><\/p>\n<p><strong>1)<\/strong>\u00a0Log in to your account (https:\/\/your-server-ip:2030) using root details.<\/p>\n<p><strong>2)<\/strong>\u00a0Navigate to\u00a0<strong>SQL Services \u2013&gt; MySQL Manager<\/strong>\u00a0and on the top, you will be able to see the option Create Database and User<\/p>\n<p>You will be navigated to the next page, where you need to enter the below details.<\/p>\n<p><strong>New Database for user:<\/strong>\u00a0Select the username (associated with the website) for which the database will be used.<br \/>\n<strong>Database Name:<\/strong>\u00a0Enter the database name<br \/>\n<strong>Confirm New Password:<\/strong>\u00a0Password for your database<\/p>\n<p><strong>3)<\/strong>\u00a0Click create and your database along with the username and password will be created.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-864 aligncenter\" src=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/01.jpg\" alt=\"\" width=\"600\" height=\"403\" srcset=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/01.jpg 600w, https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/01-300x202.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-865 aligncenter\" src=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/02.jpg\" alt=\"\" width=\"600\" height=\"550\" srcset=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/02.jpg 600w, https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/02-300x275.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-866 aligncenter\" src=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/03.jpg\" alt=\"\" width=\"602\" height=\"613\" srcset=\"https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/03.jpg 602w, https:\/\/new.hostitsmart.com\/blog\/wp-content\/uploads\/2018\/12\/03-295x300.jpg 295w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will be explaining to you about creating the new database and user. A user can create&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[57],"tags":[],"class_list":["post-862","post","type-post","status-publish","format-standard","hentry","category-website"],"_links":{"self":[{"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/posts\/862"}],"collection":[{"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/comments?post=862"}],"version-history":[{"count":0,"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/posts\/862\/revisions"}],"wp:attachment":[{"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/media?parent=862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/categories?post=862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/new.hostitsmart.com\/blog\/wp-json\/wp\/v2\/tags?post=862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}