{"id":3560,"date":"2022-10-25T15:57:59","date_gmt":"2022-10-25T14:57:59","guid":{"rendered":"https:\/\/www.names.co.uk\/support\/?post_type=ht_kb&#038;p=3560"},"modified":"2022-10-25T17:08:45","modified_gmt":"2022-10-25T16:08:45","slug":"adding-accessing-your-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/","title":{"rendered":"Adding\/Accessing Your MYSQL Database on Apache Hosting"},"content":{"rendered":"\n<p>When creating a website, there can be several different reasons for needing a database for the site to run correctly. This guide will help you to both add and access your database through your Online Control Panel.<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Database Creation and Login<\/h2>\n\n\n\n<p>Firstly you will need to login to your control panel. If you don&#8217;t know how to do this, please see the guide below:<\/p>\n\n\n\n<p><br><a href=\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-your-control-panel\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.names.co.uk\/support\/articles\/how-to-access-your-control-panel\/<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Once logged into the control panel, click on <strong>Services <\/strong>then <strong>Dashboard<\/strong>.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png\" alt=\"\" class=\"wp-image-3561\" width=\"424\" height=\"347\" srcset=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png 491w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51-300x246.png 300w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51-50x41.png 50w\" sizes=\"auto, (max-width: 424px) 100vw, 424px\" \/><\/figure>\n\n\n\n<p>On your dashboard will be a list of your domains. Click on the manage hosting button associated with the domain you wish to create a database for.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"490\" height=\"338\" src=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-52.png\" alt=\"\" class=\"wp-image-3562\" srcset=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-52.png 490w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-52-300x207.png 300w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-52-50x34.png 50w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/figure>\n\n\n\n<p>Upon clicking on this, you will be presented with the following screen. On the left menu, click on the <strong>MySQL Databases<\/strong> option and then <strong>Add Database<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"928\" height=\"304\" src=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-58.png\" alt=\"\" class=\"wp-image-3568\" srcset=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-58.png 928w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-58-300x98.png 300w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-58-768x252.png 768w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-58-50x16.png 50w\" sizes=\"auto, (max-width: 928px) 100vw, 928px\" \/><\/figure>\n\n\n\n<p>Upon clicking <strong>Add Database, <\/strong>you will see the below screen. Fill out the details and then click <strong>Create<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"405\" height=\"602\" src=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-55.png\" alt=\"\" class=\"wp-image-3565\" srcset=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-55.png 405w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-55-202x300.png 202w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-55-34x50.png 34w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/figure>\n\n\n\n<p>Upon clicking create, you will see an option to <strong>Login<\/strong>. Click on this and you will see the below requesting details.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"502\" src=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-56.png\" alt=\"\" class=\"wp-image-3566\" srcset=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-56.png 495w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-56-296x300.png 296w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-56-50x50.png 50w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/figure>\n\n\n\n<p>As long as you have submitted the correct details you will now see the screen below and will be logged into your database.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"388\" src=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-57-1024x388.png\" alt=\"\" class=\"wp-image-3567\" srcset=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-57-1024x388.png 1024w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-57-300x114.png 300w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-57-768x291.png 768w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-57-50x19.png 50w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-57-1536x582.png 1536w, https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-57.png 1918w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When creating a website, there can be several different reasons for needing a database for the site to run correctly. This guide will help you to both add and access your database through your Online Control Panel. Database Creation and Login Firstly you will need to login to your control panel. If you don&#8217;t know [&hellip;]<\/p>\n","protected":false},"author":18,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[119],"ht-kb-tag":[103],"class_list":["post-3560","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting","ht_kb_tag-apache"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Adding\/Accessing Your MYSQL Database on Apache Hosting - Support Centre - names.co.uk<\/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:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding\/Accessing Your MYSQL Database on Apache Hosting - Support Centre - names.co.uk\" \/>\n<meta property=\"og:description\" content=\"When creating a website, there can be several different reasons for needing a database for the site to run correctly. This guide will help you to both add and access your database through your Online Control Panel. Database Creation and Login Firstly you will need to login to your control panel. If you don&#8217;t know [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Support Centre - names.co.uk\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/namesco\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-25T16:08:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@namesco\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/\",\"url\":\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/\",\"name\":\"Adding\/Accessing Your MYSQL Database on Apache Hosting - Support Centre - names.co.uk\",\"isPartOf\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png\",\"datePublished\":\"2022-10-25T14:57:59+00:00\",\"dateModified\":\"2022-10-25T16:08:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#primaryimage\",\"url\":\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png\",\"contentUrl\":\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png\",\"width\":491,\"height\":402},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.names.co.uk\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding\/Accessing Your MYSQL Database on Apache Hosting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.names.co.uk\/support\/#website\",\"url\":\"https:\/\/www.names.co.uk\/support\/\",\"name\":\"Support Centre - names.co.uk\",\"description\":\"names.co.uk Support Centre\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.names.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Adding\/Accessing Your MYSQL Database on Apache Hosting - Support Centre - names.co.uk","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.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/","og_locale":"en_GB","og_type":"article","og_title":"Adding\/Accessing Your MYSQL Database on Apache Hosting - Support Centre - names.co.uk","og_description":"When creating a website, there can be several different reasons for needing a database for the site to run correctly. This guide will help you to both add and access your database through your Online Control Panel. Database Creation and Login Firstly you will need to login to your control panel. If you don&#8217;t know [&hellip;]","og_url":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/","og_site_name":"Support Centre - names.co.uk","article_publisher":"https:\/\/www.facebook.com\/namesco","article_modified_time":"2022-10-25T16:08:45+00:00","og_image":[{"url":"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@namesco","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/","url":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/","name":"Adding\/Accessing Your MYSQL Database on Apache Hosting - Support Centre - names.co.uk","isPartOf":{"@id":"https:\/\/www.names.co.uk\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png","datePublished":"2022-10-25T14:57:59+00:00","dateModified":"2022-10-25T16:08:45+00:00","breadcrumb":{"@id":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#primaryimage","url":"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png","contentUrl":"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2022\/10\/image-51.png","width":491,"height":402},{"@type":"BreadcrumbList","@id":"https:\/\/www.names.co.uk\/support\/articles\/adding-accessing-your-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.names.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"Adding\/Accessing Your MYSQL Database on Apache Hosting"}]},{"@type":"WebSite","@id":"https:\/\/www.names.co.uk\/support\/#website","url":"https:\/\/www.names.co.uk\/support\/","name":"Support Centre - names.co.uk","description":"names.co.uk Support Centre","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.names.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/3560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/comments?post=3560"}],"version-history":[{"count":2,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/3560\/revisions"}],"predecessor-version":[{"id":3576,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/3560\/revisions\/3576"}],"wp:attachment":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/media?parent=3560"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-category?post=3560"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=3560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}