{"id":105,"date":"2020-02-12T10:36:34","date_gmt":"2020-02-12T10:36:34","guid":{"rendered":"https:\/\/www.lcn.com\/support\/knowledge-base\/how-to-create-a-database-in-plesk\/"},"modified":"2020-02-12T10:36:34","modified_gmt":"2020-02-12T10:36:34","slug":"how-to-create-a-database-in-plesk","status":"publish","type":"ht_kb","link":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/","title":{"rendered":"How to create a database in Plesk"},"content":{"rendered":"

This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces.<\/p>\n

Power User interface<\/h3>\n

Follow these steps to create a new database in Plesk with the Power-user interface:<\/p>\n

    \n
  1. Open the databases<\/strong> menu from the left column of the Plesk panel.<\/li>\n
  2. Click the domain name\/subscription you want to add a database for.<\/li>\n
  3. Click the add database<\/strong> button.<\/li>\n
  4. Enter a Database name<\/strong> after the prefix that\u2019s automatically filled in.<\/li>\n
  5. The Create a database user<\/strong> tick-box should be enabled by default.<\/li>\n
  6. Enter a database username<\/strong>.<\/li>\n
  7. Enter a password<\/strong> for the database and re-enter into the confirm password<\/strong> field or select generate<\/strong> to automatically generate a strong password.<\/li>\n
  8. Select the Access Control<\/strong> settings for the database. It\u2019s recommended to select Allow local connections only<\/strong> unless you need to access the database remotely. If you need to enable remote access to the database, you can enable connections from any host or restrict access to specific IP addresses by selecting the Allow remote connections from<\/strong> option and then entering a list of the allowed IP addresses.<\/li>\n
  9. Select the OK<\/strong> button to create the database.<\/li>\n<\/ol>\n

    Service Provider interface<\/h3>\n
      \n
    1. Open the domains<\/strong> menu from the left column of the Plesk panel.<\/li>\n
    2. Click the domain name that you want to create a database for from the list on the following page.<\/li>\n
    3. Click the databases<\/strong> link from the domain name control panel page.<\/li>\n
    4. Click the add database<\/strong> button.<\/li>\n
    5. Enter a Database name<\/strong> after the prefix that\u2019s automatically filled in.<\/li>\n
    6. The Create a database user<\/strong> tick-box should be enabled by default.<\/li>\n
    7. Enter a database username<\/strong>.<\/li>\n
    8. Enter a password<\/strong> for the database and re-enter into the confirm password<\/strong> field or select generate<\/strong> to automatically generate a strong password.<\/li>\n
    9. Select the Access Control<\/strong> settings for the database. It\u2019s recommended to select Allow local connections only<\/strong> unless you need to access the database remotely. If you need to enable remote access to the database, you can enable connections from any host or restrict access to specific IP addresses by selecting the Allow remote connections from<\/strong> option and then entering a list of the allowed IP addresses.<\/li>\n
    10. Select the OK<\/strong> button to create the database.<\/li>\n<\/ol>\n

      This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces. Power User interface Follow these steps to create a new database in Plesk with the Power-user interface: Open the databases menu from the left column of the Plesk panel. Click the domain name\/subscription you want to […]<\/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-105","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-creating-and-managing-databases","ht_kb_tag-cloud-servers"],"yoast_head":"\nHow to create a database in Plesk - LCN.com<\/title>\n<meta name=\"description\" content=\"This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces.\" \/>\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-create-a-database-in-plesk\/\" \/>\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 Plesk - LCN.com\" \/>\n<meta property=\"og:description\" content=\"This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/\" \/>\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=\"og:image\" content=\"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/support-facebook-feed.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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-create-a-database-in-plesk\/\",\"url\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/\",\"name\":\"How to create a database in Plesk - LCN.com\",\"isPartOf\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#website\"},\"datePublished\":\"2020-02-12T10:36:34+00:00\",\"description\":\"This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.lcn.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create a database in Plesk\"}]},{\"@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 create a database in Plesk - LCN.com","description":"This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces.","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-create-a-database-in-plesk\/","og_locale":"en_US","og_type":"article","og_title":"How to create a database in Plesk - LCN.com","og_description":"This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces.","og_url":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/","og_site_name":"Customer Support Guides - LCN","article_publisher":"https:\/\/www.facebook.com\/lcndotcom","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/support-facebook-feed.jpg","type":"image\/jpeg"}],"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-create-a-database-in-plesk\/","url":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/","name":"How to create a database in Plesk - LCN.com","isPartOf":{"@id":"https:\/\/www.lcn.com\/support\/#website"},"datePublished":"2020-02-12T10:36:34+00:00","description":"This guide will explain how to create databases for domains in Plesk using either the Power-user or Service-provider interfaces.","breadcrumb":{"@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-database-in-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lcn.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to create a database in Plesk"}]},{"@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\/105","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=105"}],"version-history":[{"count":0,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/105\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/media?parent=105"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-category?post=105"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}