{"id":4202,"date":"2018-04-13T08:36:09","date_gmt":"2018-04-13T12:36:09","guid":{"rendered":"http:\/\/wp-p3d2tsa2xh.pairsite.com\/?post_type=ht_kb&#038;p=4202"},"modified":"2025-06-17T11:48:08","modified_gmt":"2025-06-17T15:48:08","slug":"how-to-create-a-database","status":"publish","type":"ht_kb","link":"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/","title":{"rendered":"How to Create a Database"},"content":{"rendered":"\n<p><span class=\"s1\"><a style=\"color:#fff; text-decoration:none!important;\" href=\"https:\/\/www.pair.com\/support\/kb\/tags\/shared-hosting\/\"><p style=\"background-color:#1a3d6e !important;color:#fff;padding:6px; display:inline-block!important;font-size:12px;font-weight:bold; border-radius:3px;\">Shared<\/p><\/a> <a style=\"color:#fff; text-decoration:none!important;\" href=\"https:\/\/www.pair.com\/support\/kb\/tags\/vps\/\"><p style=\"background-color:#1a3d6e !important;color:#fff;padding:6px; display:inline-block!important;font-size:12px;font-weight:bold; border-radius:3px;\">VPS<\/p><\/a> <a style=\"color:#fff; text-decoration:none!important;\" href=\"https:\/\/www.pair.com\/support\/kb\/tags\/qs-dedicated\/\"><p style=\"background-color:#1a3d6e !important;color:#fff;padding:6px; display:inline-block!important;font-size:12px; font-weight:bold; border-radius:3px;\">Dedicated<\/p><\/a><\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">If you want to create a database, you can do so directly from your hosting account. Databases can be used in conjunction or separately from your websites.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating a Database on Your Hosting Account<\/h3>\n\n\n\n<p><span style=\"font-weight: 400;\">Choose the tutorial that reflects your ACC interface type:&nbsp;<\/span><\/p>\n\n\n\n<ul>\n<li><span style=\"font-weight: 400;\"><a href=\"#if-you-are-using-the-legacy-interface\">Legacy Interface<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\"><a href=\"#if-you-are-using-the-new-acc-interface\">New ACC Interface<\/a><\/span><\/li>\n<\/ul>\n\n\n\n<p><span style=\"font-weight: 400;\">Not sure what the difference is? See<\/span><a href=\"http:\/\/pair.com\/support\/kb\/which-acc-interface-am-i-using\/\"><span style=\"font-weight: 400;\"> Which ACC Interface Am I Using?&nbsp;<\/span><\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-weight: 400;\">If you are using the Legacy Interface:<\/span><\/h4>\n\n\n\n<ol>\n<li><span style=\"font-weight: 400;\">Log in to the Account Control Center (ACC) at <\/span><a href=\"https:\/\/my.pair.com\/\"><span style=\"font-weight: 400;\">my.pair.com<\/span><\/a><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">In the left sidebar, click <\/span><b>Databases<\/b><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">In the drop-down, click <\/span><b>Create a New Database<\/b><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">On this page, add the required information:<\/span><span style=\"font-weight: 400;\"><br><br><\/span><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\n<b>Database Name<\/b>\n<\/td><td>\n<p><span style=\"font-weight: 400;\">This will be the name you use to identify your new database. The name will be appended to your current account username. The outcome will look like <\/span><i><span style=\"font-weight: 400;\">username_databaseName<\/span><\/i><\/p>\n<\/td><\/tr><tr><td>\n<b>Access Level<\/b>\n<\/td><td>\n<p><span style=\"font-weight: 400;\">This defines what connections can be made to the database. If you choose <\/span><b>Local Only<\/b><span style=\"font-weight: 400;\">, only local connections will be allowed. If you choose <\/span><b>Local\/Remote<\/b><span style=\"font-weight: 400;\">, remote connections will also be allowed.<\/span><\/p>\n<\/td><\/tr><tr><td>\n<b>Optimization Period<\/b>\n<\/td><td>\n<p><span style=\"font-weight: 400;\">Select how often you want the database to be optimized. This can be <\/span><b>Monthly<\/b><span style=\"font-weight: 400;\">, <\/span><b>Biweekly<\/b><span style=\"font-weight: 400;\">, and <\/span><b>Weekly<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ol>\n<li><span style=\"font-weight: 400;\">When finished, click <\/span><b>Add Database<\/b><\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-weight: 400;\">If you are using the New ACC Interface:<\/span><\/h4>\n\n\n\n<ol>\n<li><span style=\"font-weight: 400;\">Log in to the Account Control Center (ACC) at <\/span><a href=\"https:\/\/my.pair.com\/\"><span style=\"font-weight: 400;\">my.pair.com<\/span><\/a><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">In the top navigation bar, click <\/span><b>Databases<\/b><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">Click the <\/span><b>Create New Database<\/b><span style=\"font-weight: 400;\"> button<\/span><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">On this page, add the required information:<\/span><span style=\"font-weight: 400;\"><br><\/span><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\n<b>Database Name<\/b>\n<\/td><td>\n<p><span style=\"font-weight: 400;\">This will be the name you use to identify your new database. The name will be appended to your current account username. The outcome will look like <\/span><i><span style=\"font-weight: 400;\">username_databaseName<\/span><\/i><\/p>\n<\/td><\/tr><tr><td>\n<b>Access Level<\/b>\n<\/td><td>\n<p><span style=\"font-weight: 400;\">This defines what connections can be made to the database. If you choose Local Only, only local connections will be allowed. If you choose Local\/Remote, remote connections will also be allowed.<\/span><\/p>\n<\/td><\/tr><tr><td>\n<b>Optimization Period<\/b>\n<\/td><td>\n<p><span style=\"font-weight: 400;\">Select how often you want the database to be optimized. This can be Monthly, Biweekly, and Weekly.<\/span><\/p>\n<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><span style=\"font-weight: 400;\">When finished, click the<\/span><b> Add Database<\/b><span style=\"font-weight: 400;\"> button<\/span><\/p>\n\n\n\n<p>Your database will now be created. If created successfully,&nbsp; the next page will display your new database information. Be sure to take note of the passwords and different username types that can be used to access the database. The different usernames have different access types:<\/p>\n\n\n \r\n    \t\t<div class=\"hts-accordion \"  >\r\n\r\n    \t\t\t    \t\t\t\t<div class=\"hts-accordion__section hts-accordion__section--active\">\r\n\t    \t\t\t\t<div class=\"hts-accordion__title\">Full Access<\/div>\r\n\t    \t\t\t\t<div class=\"hts-accordion__content\">\r\n\t    \t\t\t\t\t<div class=\"hts-accordion__contentwrap\">\r\n\t    \t\t\t\t\t\tThis user can read, edit, and run the database\t    \t\t\t\t\t<\/div>\r\n\t    \t\t\t\t<\/div>\r\n    \t\t\t\t<\/div>\r\n    \t\t\t    \t\t\t\t<div class=\"hts-accordion__section \">\r\n\t    \t\t\t\t<div class=\"hts-accordion__title\">Read access<\/div>\r\n\t    \t\t\t\t<div class=\"hts-accordion__content\">\r\n\t    \t\t\t\t\t<div class=\"hts-accordion__contentwrap\">\r\n\t    \t\t\t\t\t\tThis user can only see the database\t    \t\t\t\t\t<\/div>\r\n\t    \t\t\t\t<\/div>\r\n    \t\t\t\t<\/div>\r\n    \t\t\t    \t\t\t\t<div class=\"hts-accordion__section \">\r\n\t    \t\t\t\t<div class=\"hts-accordion__title\">Read\/write access<\/div>\r\n\t    \t\t\t\t<div class=\"hts-accordion__content\">\r\n\t    \t\t\t\t\t<div class=\"hts-accordion__contentwrap\">\r\n\t    \t\t\t\t\t\tThis user can see and edit the database\t    \t\t\t\t\t<\/div>\r\n\t    \t\t\t\t<\/div>\r\n    \t\t\t\t<\/div>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-accordion -->\r\n    \t\t\n\n\n\n<p>The different login types allow you to give out limited access if others need access to the database. This reduces the likelihood of errors and abuse. Even if you don't think this situation applies to you, we recommend storing all the login information in a safe place, just in case.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to create a database, you can do so directly from your hosting account. Databases can be used in conjunction or separately from your websites. Creating a Database on Your Hosting Account Choose the tutorial that reflects your ACC interface type:&nbsp; Not sure what the difference is? See&#8230;<\/p>\n","protected":false},"author":12,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[23],"ht-kb-tag":[178,176,177],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create a Database - Knowledge Base - Pair Networks<\/title>\n<meta name=\"description\" content=\"If you want to create a database, you can do so on directly on your hosting account. Databases can be used in conjunction or separately from your websites.\" \/>\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.pair.com\/support\/kb\/how-to-create-a-database\/\" \/>\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 - Knowledge Base - Pair Networks\" \/>\n<meta property=\"og:description\" content=\"If you want to create a database, you can do so on directly on your hosting account. Databases can be used in conjunction or separately from your websites.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - Pair Networks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pairnetworks\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-17T15:48:08+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@pairNetworks\" \/>\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.pair.com\/support\/kb\/how-to-create-a-database\/\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/\",\"name\":\"How to Create a Database - Knowledge Base - Pair Networks\",\"isPartOf\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#website\"},\"datePublished\":\"2018-04-13T12:36:09+00:00\",\"dateModified\":\"2025-06-17T15:48:08+00:00\",\"description\":\"If you want to create a database, you can do so on directly on your hosting account. Databases can be used in conjunction or separately from your websites.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pair.com\/support\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#website\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/\",\"name\":\"Knowledge Base - Pair Networks\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pair.com\/support\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#organization\",\"name\":\"Pair Networks\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg\",\"contentUrl\":\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg\",\"width\":360,\"height\":360,\"caption\":\"Pair Networks\"},\"image\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/pairnetworks\/\",\"https:\/\/twitter.com\/pairNetworks\",\"https:\/\/www.instagram.com\/pairnetworks\/\",\"https:\/\/www.linkedin.com\/company\/2269676\/\",\"https:\/\/www.pinterest.com\/pairnetworksinc\/pins\/\",\"https:\/\/www.youtube.com\/user\/pairnetworks\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Database - Knowledge Base - Pair Networks","description":"If you want to create a database, you can do so on directly on your hosting account. Databases can be used in conjunction or separately from your websites.","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.pair.com\/support\/kb\/how-to-create-a-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Create a Database - Knowledge Base - Pair Networks","og_description":"If you want to create a database, you can do so on directly on your hosting account. Databases can be used in conjunction or separately from your websites.","og_url":"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/","og_site_name":"Knowledge Base - Pair Networks","article_publisher":"https:\/\/www.facebook.com\/pairnetworks\/","article_modified_time":"2025-06-17T15:48:08+00:00","twitter_card":"summary_large_image","twitter_site":"@pairNetworks","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/","url":"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/","name":"How to Create a Database - Knowledge Base - Pair Networks","isPartOf":{"@id":"https:\/\/www.pair.com\/support\/kb\/#website"},"datePublished":"2018-04-13T12:36:09+00:00","dateModified":"2025-06-17T15:48:08+00:00","description":"If you want to create a database, you can do so on directly on your hosting account. Databases can be used in conjunction or separately from your websites.","breadcrumb":{"@id":"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pair.com\/support\/kb\/how-to-create-a-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pair.com\/support\/kb\/"},{"@type":"ListItem","position":2,"name":"How to Create a Database"}]},{"@type":"WebSite","@id":"https:\/\/www.pair.com\/support\/kb\/#website","url":"https:\/\/www.pair.com\/support\/kb\/","name":"Knowledge Base - Pair Networks","description":"","publisher":{"@id":"https:\/\/www.pair.com\/support\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pair.com\/support\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pair.com\/support\/kb\/#organization","name":"Pair Networks","url":"https:\/\/www.pair.com\/support\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg","contentUrl":"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg","width":360,"height":360,"caption":"Pair Networks"},"image":{"@id":"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pairnetworks\/","https:\/\/twitter.com\/pairNetworks","https:\/\/www.instagram.com\/pairnetworks\/","https:\/\/www.linkedin.com\/company\/2269676\/","https:\/\/www.pinterest.com\/pairnetworksinc\/pins\/","https:\/\/www.youtube.com\/user\/pairnetworks"]}]}},"_links":{"self":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/4202"}],"collection":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/comments?post=4202"}],"version-history":[{"count":13,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/4202\/revisions"}],"predecessor-version":[{"id":10204,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/4202\/revisions\/10204"}],"wp:attachment":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/media?parent=4202"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=4202"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=4202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}