{"id":24333,"date":"2022-02-02T14:30:23","date_gmt":"2022-02-02T14:30:23","guid":{"rendered":"https:\/\/1-grid.com\/knowledge\/plesk-how-to-create-new-databases\/"},"modified":"2025-05-07T11:28:23","modified_gmt":"2025-05-07T11:28:23","slug":"plesk-how-to-create-new-databases","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/","title":{"rendered":"Plesk: How to create a MYSQL new Databases"},"content":{"rendered":"<h2>Overview<\/h2>\n<p>Creating a database in Plesk is essential for running dynamic websites or applications that rely on data storage. This guide walks you through setting up a new database, assigning users, and managing access securely.<\/p>\n<h3>Why You Might Need to Create a New Database<\/h3>\n<p><strong>Databases are required for:<\/strong><\/p>\n<p>\u25cf Content Management Systems like WordPress, Joomla, or Drupal<\/p>\n<p>\u25cf E-commerce platforms like Magento or WooCommerce<\/p>\n<p>\u25cf Custom web applications that store data, user accounts, or product info<\/p>\n<p>Setting up a dedicated database, you ensure organized, secure, and scalable data management for your website.<\/p>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><span style=\"box-sizing: border-box; font-size: 24px; color: #000000;\"><strong style=\"box-sizing: border-box; font-weight: bold;\">Step 1<\/strong>&#8211; Login to Plesk.<\/span><\/p>\n<ul style=\"box-sizing: border-box; margin-bottom: 4px; margin-left: 0px; padding: 0px 0px 0px 40px; line-height: 17px; list-style: disc; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-size: 13px; font-weight: 400; text-align: start; text-indent: 0px;\">\n<li style=\"box-sizing: border-box; font-size: 13px; line-height: 18px; margin-bottom: 0px; margin-left: 0px; word-break: normal; overflow-wrap: break-word;\">Go to your hosting Plesk control panel account. Enter your username and password, then click &#8220;Log in.&#8221;<\/li>\n<\/ul>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><img loading=\"lazy\" decoding=\"async\" class=\"fr-fic fr-fil fr-dib aligncenter\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33092306844\/original\/svZ0zgnUE1sOQOBdjgrnVnWANqyNjWnZAQ.png?1677668757\" width=\"305\" height=\"321\" data-attachment=\"[object Object]\" data-id=\"33092306844\" data-identifyelement=\"502\" \/><\/p>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><span style=\"box-sizing: border-box; font-size: 24px; color: #000000;\"><strong style=\"box-sizing: border-box; font-weight: bold;\">Step 2<\/strong>&#8211; Click on Add Databases.<\/span><\/p>\n<p>Once logged in:<\/p>\n<p>1. Click on Websites &amp; Domains from the left-hand menu<\/p>\n<p>2. Select your domain<\/p>\n<p>3. Click on Databases<\/p>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><span style=\"box-sizing: border-box; font-size: 24px;\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-bordered aligncenter\" style=\"width: 649px;\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33039006769\/original\/HBmYC6nGaEMHrarxqNowgaOOHYhL8z-cVA.png?1585755760\" data-id=\"33039006704\" \/><\/span><\/p>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><span style=\"box-sizing: border-box; font-size: 24px; color: #000000;\"><strong style=\"box-sizing: border-box; font-weight: bold;\">Step 3<\/strong>&#8211; Complete Database information and click OK.<\/span><\/p>\n<p>1. Click on Add Database<\/p>\n<p>2. Fill in the required fields:<\/p>\n<p>\u25cb Database Name: Choose a name that relates to your website or app<\/p>\n<p>\u25cb Related Site: Select the domain this database will be associated with<\/p>\n<p>\u25cb Database User: Create a new user or assign an existing one<\/p>\n<p>\u25cb Password: Choose a strong, secure password<\/p>\n<p>3. Click OK to create the database<\/p>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><span style=\"box-sizing: border-box; font-size: 24px;\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-bordered aligncenter\" style=\"width: 598px;\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33039006902\/original\/K5WNcOtER1N97LfteAJCidEySO6J_K2C6Q.png?1585755916\" height=\"458\" data-id=\"33039006850\" \/><\/span><\/p>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><span style=\"box-sizing: border-box; font-size: 24px; color: #000000;\"><strong>Step 4<\/strong>&#8211; New created database will be listed under Databases.<\/span><\/p>\n<p>After creation, you\u2019ll be able to:<\/p>\n<p>\u25cf Access the database using phpMyAdmin (for MySQL) or pgAdmin (for PostgreSQL)<\/p>\n<p>\u25cf Modify user permissions<\/p>\n<p>\u25cf Import or export data<\/p>\n<p>\u25cf Connect your application or CMS to the database using the database name, username, and password<\/p>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\"><span style=\"box-sizing: border-box; font-size: 24px;\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-bordered aligncenter\" style=\"width: 598px;\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33039007034\/original\/lwsejIJFsKNTt27j5DrK6dQTXnKJ1w2yhg.png?1585756022\" height=\"243\" data-attachment=\"[object Object]\" data-id=\"33039007034\" \/><\/span><\/p>\n<p><strong>Troubleshooting and FAQs<\/strong><\/p>\n<p>I can&#8217;t find the &#8216;Databases&#8217; tab: You may not have access permissions. Contact your hosting provider or account administrator to check your role.<\/p>\n<p>What is the difference between MySQL and PostgreSQL? Both are relational database systems. MySQL is commonly used with PHP applications like WordPress, while PostgreSQL is often chosen for more complex applications due to its advanced features.<\/p>\n<p>How do I connect my app to the new database? You\u2019ll need the database host (usually localhost), name, username, and password. These are entered in your application\u2019s configuration file.<\/p>\n<p><strong>Best Practices for Database Management<\/strong><\/p>\n<p>\u25cf Always use strong passwords for database users<\/p>\n<p>\u25cf Limit user permissions based on the application\u2019s needs<\/p>\n<p>\u25cf Regularly backup your databases to avoid data loss<\/p>\n<p>\u25cf Remove unused databases to reduce clutter and security risk<\/p>\n<p>Additional Resources For advanced database management options, refer to the official Plesk documentation: https:\/\/docs.plesk.com\/<\/p>\n<p><strong>Summary<\/strong><\/p>\n<p>Setting up a new database in Plesk is quick and secure. Whether you&#8217;re launching a CMS, an online store, or a custom app, this process ensures you have the correct data structure to support your project. Need help? Contact 1-grid Support for expert assistance.<\/p>\n<hr \/>\n<p style=\"box-sizing: border-box; margin-bottom: 0px; margin-left: 0px; font-size: 13px; line-height: 18px; word-break: normal; overflow-wrap: break-word; color: #183247; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; font-weight: 400; text-align: start; text-indent: 0px;\">\n","protected":false},"excerpt":{"rendered":"<p>Overview Creating a database in Plesk is essential for running dynamic websites or applications that rely on data storage. This guide walks you through setting up a new database, assigning users, and managing access securely. Why You Might Need to Create a New Database Databases are required for: \u25cf Content&#8230;<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1199],"ht-kb-tag":[247,270,470,480,662,668,747],"class_list":["post-24333","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-plesk","ht_kb_tag-create","ht_kb_tag-database","ht_kb_tag-hosting","ht_kb_tag-how-to","ht_kb_tag-mysql","ht_kb_tag-new","ht_kb_tag-plesk"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Plesk: How to create a MYSQL new Databases -<\/title>\n<meta name=\"description\" content=\"This article provides you with steps to create new databases via your Plesk Control Panel. Plesk: How to create a MYSQL new Databases\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plesk: How to create a MYSQL new Databases -\" \/>\n<meta property=\"og:description\" content=\"This article provides you with steps to create new databases via your Plesk Control Panel. Plesk: How to create a MYSQL new Databases\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-07T11:28:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33092306844\/original\/svZ0zgnUE1sOQOBdjgrnVnWANqyNjWnZAQ.png?1677668757\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\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:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/\",\"name\":\"Plesk: How to create a MYSQL new Databases -\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2022-02-02T14:30:23+00:00\",\"dateModified\":\"2025-05-07T11:28:23+00:00\",\"description\":\"This article provides you with steps to create new databases via your Plesk Control Panel. Plesk: How to create a MYSQL new Databases\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Plesk: How to create a MYSQL new Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Plesk: How to create a MYSQL new Databases -","description":"This article provides you with steps to create new databases via your Plesk Control Panel. Plesk: How to create a MYSQL new Databases","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Plesk: How to create a MYSQL new Databases -","og_description":"This article provides you with steps to create new databases via your Plesk Control Panel. Plesk: How to create a MYSQL new Databases","og_url":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2025-05-07T11:28:23+00:00","og_image":[{"url":"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33092306844\/original\/svZ0zgnUE1sOQOBdjgrnVnWANqyNjWnZAQ.png?1677668757"}],"twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/","url":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/","name":"Plesk: How to create a MYSQL new Databases -","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2022-02-02T14:30:23+00:00","dateModified":"2025-05-07T11:28:23+00:00","description":"This article provides you with steps to create new databases via your Plesk Control Panel. Plesk: How to create a MYSQL new Databases","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Plesk: How to create a MYSQL new Databases"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=24333"}],"version-history":[{"count":5,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24333\/revisions"}],"predecessor-version":[{"id":33219,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24333\/revisions\/33219"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=24333"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=24333"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=24333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}