{"id":69,"date":"2020-02-12T10:36:24","date_gmt":"2020-02-12T10:36:24","guid":{"rendered":"https:\/\/www.lcn.com\/support\/knowledge-base\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/"},"modified":"2021-06-02T09:01:26","modified_gmt":"2021-06-02T09:01:26","slug":"how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel","status":"publish","type":"ht_kb","link":"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/","title":{"rendered":"How to manage databases on Cloud hosting using Vesta control panel"},"content":{"rendered":"\n<p>This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel.<\/p>\n\n\n\n<p><i>For cloud hosting customers using cPanel, please click <a href=\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-cpanel\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a> for the relevant support guide.<\/i><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating databases:<\/h3>\n\n\n\n<p>To add a database within the Vesta control panel, select the &#8216;DB&#8217; link from the Vesta menu:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/support\/articles\/attachment\/464\/inline\/original\/1457090958\/vesta_db_menu.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Then select the + icon to add a database:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/support\/articles\/attachment\/465\/inline\/original\/1457091000\/vesta_add_db.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>You will then need to complete the following fields:<\/p>\n\n\n\n<p>Database: database name (will be prefixed with admin_)<br>User: database user-name (will be prefixed with admin_ and should be no longer than 16 characters together with the prefix)<br>Password: Select \u2018generate\u2019 to automatically generate a strong password<br><br>Once the required fields are filled out, select \u2018add\u2019 to create the database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Access to Phpmyadmin:<\/h3>\n\n\n\n<p>To access Phpmyadmin, go to the \u2018DB\u2019 section of the control panel and select the link provided on this page for Phpmyadmin. Then enter your database username and database password to log in.<\/p>\n\n\n\n<p>To manage databases in Phpmyadmin, select the database name that you want to manage from the column on the left side of the page:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/support\/articles\/attachment\/466\/inline\/original\/1457091129\/vesta_phpma_select_db.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>You can then select from the options in the header area of the page, to import\/export, edit, manage or browse the database contents:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/support\/articles\/attachment\/467\/inline\/original\/1457091165\/vesta_phpma_menu.png\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Related guides<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-cpanel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to manage databases on Cloud hosting using cPanel<\/a><\/li><li><a href=\"https:\/\/www.lcn.com\/support\/articles\/how-to-configure-email-accounts-on-cloud-hosting-using-vesta-control-panel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to configure email accounts on Cloud hosting using Vesta control panel<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel. For cloud hosting customers using cPanel, please click here for the relevant support guide. Creating databases: To add a database within the Vesta control panel, select the &#8216;DB&#8217; link from the Vesta menu: Then select the [&hellip;]<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[7],"ht-kb-tag":[18],"class_list":["post-69","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-creating-and-managing-databases","ht_kb_tag-cloud-servers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to manage databases on Cloud hosting using Vesta control panel - LCN.com<\/title>\n<meta name=\"description\" content=\"This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel.\" \/>\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.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to manage databases on Cloud hosting using Vesta control panel - LCN.com\" \/>\n<meta property=\"og:description\" content=\"This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/\" \/>\n<meta property=\"og:site_name\" content=\"Customer Support Guides - LCN\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/lcndotcom\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-02T09:01:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.lcn.com\/support\/articles\/attachment\/464\/inline\/original\/1457090958\/vesta_db_menu.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@lcndotcom\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/\",\"url\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/\",\"name\":\"How to manage databases on Cloud hosting using Vesta control panel - LCN.com\",\"isPartOf\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#website\"},\"datePublished\":\"2020-02-12T10:36:24+00:00\",\"dateModified\":\"2021-06-02T09:01:26+00:00\",\"description\":\"This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.lcn.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to manage databases on Cloud hosting using Vesta control panel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.lcn.com\/support\/#website\",\"url\":\"https:\/\/www.lcn.com\/support\/\",\"name\":\"Customer Support Guides - LCN\",\"description\":\"- LCN\",\"publisher\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.lcn.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.lcn.com\/support\/#organization\",\"name\":\"LCN.com\",\"url\":\"https:\/\/www.lcn.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg\",\"contentUrl\":\"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg\",\"width\":461,\"height\":461,\"caption\":\"LCN.com\"},\"image\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/lcndotcom\",\"https:\/\/x.com\/lcndotcom\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to manage databases on Cloud hosting using Vesta control panel - LCN.com","description":"This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel.","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.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/","og_locale":"en_US","og_type":"article","og_title":"How to manage databases on Cloud hosting using Vesta control panel - LCN.com","og_description":"This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel.","og_url":"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/","og_site_name":"Customer Support Guides - LCN","article_publisher":"https:\/\/www.facebook.com\/lcndotcom","article_modified_time":"2021-06-02T09:01:26+00:00","og_image":[{"url":"https:\/\/www.lcn.com\/support\/articles\/attachment\/464\/inline\/original\/1457090958\/vesta_db_menu.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@lcndotcom","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/","url":"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/","name":"How to manage databases on Cloud hosting using Vesta control panel - LCN.com","isPartOf":{"@id":"https:\/\/www.lcn.com\/support\/#website"},"datePublished":"2020-02-12T10:36:24+00:00","dateModified":"2021-06-02T09:01:26+00:00","description":"This guide will explain how to create and manage databases for domains on Cloud hosting using Vesta control panel.","breadcrumb":{"@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-manage-databases-on-cloud-hosting-using-vesta-control-panel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lcn.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to manage databases on Cloud hosting using Vesta control panel"}]},{"@type":"WebSite","@id":"https:\/\/www.lcn.com\/support\/#website","url":"https:\/\/www.lcn.com\/support\/","name":"Customer Support Guides - LCN","description":"- LCN","publisher":{"@id":"https:\/\/www.lcn.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.lcn.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.lcn.com\/support\/#organization","name":"LCN.com","url":"https:\/\/www.lcn.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg","contentUrl":"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg","width":461,"height":461,"caption":"LCN.com"},"image":{"@id":"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/lcndotcom","https:\/\/x.com\/lcndotcom"]}]}},"_links":{"self":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":2,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/69\/revisions"}],"predecessor-version":[{"id":1550,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/69\/revisions\/1550"}],"wp:attachment":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-category?post=69"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}