{"id":6185,"date":"2020-11-29T20:51:41","date_gmt":"2020-11-29T20:51:41","guid":{"rendered":"https:\/\/truehost.co.ke\/support\/?post_type=ht_kb&#038;p=6185"},"modified":"2024-06-07T13:03:32","modified_gmt":"2024-06-07T13:03:32","password":"","slug":"how-to-create-a-database-in-cpanel","status":"publish","type":"docs","link":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/","title":{"rendered":"How to Create a Database in cPanel"},"content":{"rendered":"\n<p>Unlike on your local machine where you create a database via phpMyAdmin, databases in cPanel are created differently. To create a database in cPanel, use this guide<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Login to cPanel<\/li><li>Go to MySQL Databases icon under Databases and click it<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"926\" height=\"189\" src=\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main.png\" alt=\"\" class=\"wp-image-6147\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main.png 926w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main-300x61.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main-768x157.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main-50x10.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main-920x188.png 920w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main-600x122.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main-320x65.png 320w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/figure>\n\n\n\n<p>3. Under Create New Database, type your database name. NOTE that the database name will take the format <strong>cpaneluser_databasename<\/strong> eg if I create a database called blog and my cPanel username is truehost, then database will be truehost_blog<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"310\" src=\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-1024x310.png\" alt=\"\" class=\"wp-image-6148\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-1024x310.png 1024w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-300x91.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-768x233.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-50x15.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-920x279.png 920w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-600x182.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases-320x97.png 320w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-MySQL\u00ae-Databases.png 1248w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4. Now to access the database and manage it, eg create tables, go to <strong>phpMyAdmin<\/strong> icon<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"925\" height=\"179\" src=\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1.png\" alt=\"\" class=\"wp-image-6149\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1.png 925w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1-300x58.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1-768x149.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1-50x10.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1-920x178.png 920w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1-600x116.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main1-320x62.png 320w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unlike on your local machine where you create a database via phpMyAdmin, databases in cPanel are created differently. To create a database in cPanel, use this guide Login to cPanel Go to MySQL Databases icon under Databases and click it 3. Under Create New Database, type your database name. NOTE that the database name will [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_category":[],"doc_tag":[],"class_list":["post-6185","docs","type-docs","status-publish","hentry"],"year_month":"2026-06","word_count":93,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"w m","author_nicename":"wm","author_url":"https:\/\/truehost.com\/support\/author\/wm\/"},"doc_category_info":[],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create a Database in cPanel -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Database in cPanel -\" \/>\n<meta property=\"og:description\" content=\"Unlike on your local machine where you create a database via phpMyAdmin, databases in cPanel are created differently. To create a database in cPanel, use this guide Login to cPanel Go to MySQL Databases icon under Databases and click it 3. Under Create New Database, type your database name. NOTE that the database name will [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T13:03:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/\",\"url\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/\",\"name\":\"How to Create a Database in cPanel -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/truehost.co.ke\\\/support\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/Screenshot_2020-11-23-cPanel-Main.png\",\"datePublished\":\"2020-11-29T20:51:41+00:00\",\"dateModified\":\"2024-06-07T13:03:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/truehost.co.ke\\\/support\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/Screenshot_2020-11-23-cPanel-Main.png\",\"contentUrl\":\"https:\\\/\\\/truehost.co.ke\\\/support\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/Screenshot_2020-11-23-cPanel-Main.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-database-in-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Database in cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"name\":\"\",\"description\":\"Help In a Click\",\"publisher\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truehost.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\",\"name\":\"Truehost Kenya\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"width\":240,\"height\":48,\"caption\":\"Truehost Kenya\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Database in cPanel -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How to Create a Database in cPanel -","og_description":"Unlike on your local machine where you create a database via phpMyAdmin, databases in cPanel are created differently. To create a database in cPanel, use this guide Login to cPanel Go to MySQL Databases icon under Databases and click it 3. Under Create New Database, type your database name. NOTE that the database name will [&hellip;]","og_url":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/","article_modified_time":"2024-06-07T13:03:32+00:00","og_image":[{"url":"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/","url":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/","name":"How to Create a Database in cPanel -","isPartOf":{"@id":"https:\/\/truehost.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main.png","datePublished":"2020-11-29T20:51:41+00:00","dateModified":"2024-06-07T13:03:32+00:00","breadcrumb":{"@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/#primaryimage","url":"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main.png","contentUrl":"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/11\/Screenshot_2020-11-23-cPanel-Main.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/how-to-create-a-database-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Create a Database in cPanel"}]},{"@type":"WebSite","@id":"https:\/\/truehost.com\/support\/#website","url":"https:\/\/truehost.com\/support\/","name":"","description":"Help In a Click","publisher":{"@id":"https:\/\/truehost.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truehost.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/truehost.com\/support\/#organization","name":"Truehost Kenya","url":"https:\/\/truehost.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","width":240,"height":48,"caption":"Truehost Kenya"},"image":{"@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/comments?post=6185"}],"version-history":[{"count":1,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6185\/revisions"}],"predecessor-version":[{"id":6187,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6185\/revisions\/6187"}],"wp:attachment":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/media?parent=6185"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_category?post=6185"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_tag?post=6185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}