{"id":17111,"date":"2024-11-12T07:04:43","date_gmt":"2024-11-12T07:04:43","guid":{"rendered":"https:\/\/truehost.com\/support\/?post_type=docs&#038;p=17111"},"modified":"2024-11-12T07:04:44","modified_gmt":"2024-11-12T07:04:44","password":"","slug":"how-to-create-a-mysql-database-in-directadmin","status":"publish","type":"docs","link":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/","title":{"rendered":"How to create a MySQL Database in DirectAdmin"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">How to Create a MySQL Database in DirectAdmin<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You first need to login into DirectAdmin control panel using one of the URLs below,&nbsp;<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&nbsp;https:\/\/IP-address:2222&nbsp;or&nbsp;https:\/\/server-hostname:2222.<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"398\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png\" alt=\"\" class=\"wp-image-16951\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png 642w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155-300x186.png 300w\" sizes=\"auto, (max-width: 642px) 100vw, 642px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Next is to go to\u00a0<strong>Account Manager \u2192<\/strong>\u00a0<strong>MySQL Management<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"178\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-233.png\" alt=\"\" class=\"wp-image-17112\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-233.png 648w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-233-300x82.png 300w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To create a new database, click on Create New Database<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"733\" height=\"121\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-234.png\" alt=\"\" class=\"wp-image-17113\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-234.png 733w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-234-300x50.png 300w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You will then input the needed details. \n<ul class=\"wp-block-list\">\n<li><strong>Database name   <\/strong><\/li>\n\n\n\n<li><strong>Create a user for DB: <\/strong>De-select \u201cSame as database name\u201d, unless if you want them to be same <\/li>\n\n\n\n<li><strong>Enter the Username <\/strong><\/li>\n\n\n\n<li><strong>Configure the Password<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"157\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-235.png\" alt=\"\" class=\"wp-image-17114\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-235.png 577w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-235-300x82.png 300w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once you have input the details, click on\u00a0<strong>CREATE DATABASE<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"738\" height=\"207\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-236.png\" alt=\"\" class=\"wp-image-17115\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-236.png 738w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-236-300x84.png 300w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Your database is now created and you can see it among the available databases when you list them<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How to delete a MySQL Database in DirectAdmin<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You first need to login into DirectAdmin control panel using one of the URLs below,&nbsp;<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&nbsp;https:\/\/IP-address:2222&nbsp;or&nbsp;https:\/\/server-hostname:2222.<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"398\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png\" alt=\"\" class=\"wp-image-16951\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png 642w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155-300x186.png 300w\" sizes=\"auto, (max-width: 642px) 100vw, 642px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Next is to go to\u00a0<strong>Account Manager \u2192<\/strong>\u00a0<strong>MySQL Management<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"178\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-237.png\" alt=\"\" class=\"wp-image-17116\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-237.png 648w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-237-300x82.png 300w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Check the box that&#8217;s next to the Database that you wan to delete, then click on <strong>Delete<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"484\" height=\"244\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-238.png\" alt=\"\" class=\"wp-image-17117\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-238.png 484w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-238-300x151.png 300w\" sizes=\"auto, (max-width: 484px) 100vw, 484px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You will be asked to confirm the deletion. Do thta by Clicking on <strong>Delete<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"318\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-239.png\" alt=\"\" class=\"wp-image-17118\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-239.png 659w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-239-300x145.png 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Your database will now be deleted from the panel.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How to Create a MySQL Database in DirectAdmin How to delete a MySQL Database in DirectAdmin<\/p>\n","protected":false},"author":9,"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":[1820,1824,1879,2128],"doc_tag":[],"class_list":["post-17111","docs","type-docs","status-publish","hentry","doc_category-cloud-servers-in-kenya","doc_category-dedicated-servers","doc_category-servers","doc_category-vps-servers"],"year_month":"2026-07","word_count":193,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Eugene","author_nicename":"eugene","author_url":"https:\/\/truehost.com\/support\/author\/eugene\/"},"doc_category_info":[{"term_name":"Cloud servers in Kenya","term_url":"https:\/\/truehost.com\/support\/docs-category\/cloud-servers-in-kenya\/"},{"term_name":"dedicated servers","term_url":"https:\/\/truehost.com\/support\/docs-category\/dedicated-servers\/"},{"term_name":"Servers","term_url":"https:\/\/truehost.com\/support\/docs-category\/servers\/"},{"term_name":"VPS-Servers","term_url":"https:\/\/truehost.com\/support\/docs-category\/vps-servers\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to create a MySQL Database in DirectAdmin -<\/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:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/\" \/>\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 MySQL Database in DirectAdmin -\" \/>\n<meta property=\"og:description\" content=\"How to Create a MySQL Database in DirectAdmin How to delete a MySQL Database in DirectAdmin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-12T07:04:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/\",\"name\":\"How to create a MySQL Database in DirectAdmin -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image-155.png\",\"datePublished\":\"2024-11-12T07:04:43+00:00\",\"dateModified\":\"2024-11-12T07:04:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image-155.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image-155.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-create-a-mysql-database-in-directadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create a MySQL Database in DirectAdmin\"}]},{\"@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 MySQL Database in DirectAdmin -","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:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to create a MySQL Database in DirectAdmin -","og_description":"How to Create a MySQL Database in DirectAdmin How to delete a MySQL Database in DirectAdmin","og_url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/","article_modified_time":"2024-11-12T07:04:44+00:00","og_image":[{"url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/","url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/","name":"How to create a MySQL Database in DirectAdmin -","isPartOf":{"@id":"https:\/\/truehost.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/#primaryimage"},"image":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png","datePublished":"2024-11-12T07:04:43+00:00","dateModified":"2024-11-12T07:04:44+00:00","breadcrumb":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/#primaryimage","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2024\/11\/image-155.png"},{"@type":"BreadcrumbList","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-create-a-mysql-database-in-directadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to create a MySQL Database in DirectAdmin"}]},{"@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\/17111","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/comments?post=17111"}],"version-history":[{"count":1,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/17111\/revisions"}],"predecessor-version":[{"id":17119,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/17111\/revisions\/17119"}],"wp:attachment":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/media?parent=17111"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_category?post=17111"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_tag?post=17111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}