{"id":32,"date":"2020-02-12T10:36:13","date_gmt":"2020-02-12T10:36:13","guid":{"rendered":"https:\/\/www.lcn.com\/support\/knowledge-base\/how-to-create-a-mysql-database\/"},"modified":"2020-08-14T10:20:31","modified_gmt":"2020-08-14T10:20:31","slug":"how-to-create-a-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/","title":{"rendered":"How to create a MYSQL database"},"content":{"rendered":"\n<p>Databases are used with popular content management systems such as WordPress, Joomla or OpenCart. LCN\u202f<a href=\"https:\/\/www.lcn.com\/web-hosting\" target=\"_blank\" rel=\"noreferrer noopener\">Web Hosting<\/a>\u00a0and\u202f<a href=\"https:\/\/www.lcn.com\/web-hosting\/wordpress\" target=\"_blank\" rel=\"noreferrer noopener\">WordPress<\/a>\u202fhosting\u00a0packages\u00a0provide\u00a0the ability to\u00a0create a new MySQL database from\u00a0your\u00a0<a href=\"https:\/\/login.lcn.com\/login\">LCN\u00a0account<\/a>.\u00a0\u00a0<\/p>\n\n\n\n<p>Let\u2019s get started\u2026&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How to create a MYSQL database<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Log in to\u202f<a href=\"https:\/\/login.lcn.com\/login\" target=\"_blank\" rel=\"noreferrer noopener\">your LCN account<\/a>&nbsp;and head to your&nbsp;<strong>Control Panel<\/strong>.&nbsp;<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li>Click\u202fon the&nbsp;domain&nbsp;you\u2019d like to add a database to.&nbsp;<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Now click&nbsp;<strong>Hosting Settings&nbsp;<\/strong>followed by&nbsp;<strong>MySQL.<\/strong>&nbsp;<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>Next click&nbsp;<strong>Add database.<\/strong>&nbsp;<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li>You will now be presented with boxes to fill in for your Databases details.\u00a0\u00a0<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Database name\u00a0\u2013\u00a0<\/strong>The name will need to be\u00a0up to 12 characters and consisting only of letters and numbers.\u00a0As a\u00a0recommendation we have prefilled the box with\u00a0our suggested name,\u00a0we suggest this is used\u00a0as we have already confirmed that this is unique for the server indicated.\u00a0<\/li><li><strong>MySQL server\u00a0&#8211;\u00a0<\/strong>\u00a0Choose\u00a0between the MySQL servers\u00a0provided. The server that is currently serving the lowest number of databases is selected by default, and it is recommended that you\u00a0adhere\u00a0to this selection. However, you may choose a different server if you require a particular MySQL version, or your database must be on the same server as another database.\u00a0<\/li><li><strong>Default charset\u00a0\u2013\u00a0<\/strong>Our recommended charset\u00a0will be\u00a0automatically selected; we suggest that you leave it like that unless you particularly need to use another one.\u00a0The most popular are\u00a0<strong>latin1<\/strong>\u00a0and\u00a0<strong>utf8<\/strong>.\u00a0For more information on MySQL character set support, please refer to the\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL documentation<\/a>.\u00a0<\/li><li><strong>Username\u00a0&#8211;\u00a0<\/strong>Enter\u00a0a username of up to 12 characters and consisting only of letters and numbers. We\u00a0would\u00a0recommended that you use our suggested username\u00a0that is provided, as we have already confirmed that this is unique for the server indicated.\u00a0<\/li><li><strong>Password \u2013\u00a0<\/strong>Enter the password you would like for your Database. Make sure your chosen password is secure\u00a0it is recommended to be 5 to\u00a08 characters long\u00a0and\u00a0include at least 3 of the following: Lower case letter, upper case letter, number, special character. For a guide on making a secure password click\u202f<a href=\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-strong-password\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.\u00a0<\/li><li><strong>Confirm password\u00a0\u2013\u00a0<\/strong>Confirm your password that you entered above.\u00a0<\/li><li><strong>Remote access?\u00a0&#8211;\u00a0<\/strong>To ensure maximum security, by default your database will not accept connections from any location outside of the hosting cluster\u00a0and\u00a0we strongly recommend that databases are developed on your own machine. Once complete, the database can be uploaded to the live server via your MySQL control panel. However, in exceptional circumstances, you may need to enable remote access to your database. You will need a fixed IP address which you must provide to\u00a0our\u00a0<a href=\"https:\/\/www.lcn.com\/contact\" target=\"_blank\" rel=\"noreferrer noopener\">Support<\/a>\u00a0team\u00a0who can then permit access through the firewall.\u00a0<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\"><li>When you are happy with your entries click\u00a0<strong>Create<\/strong>\u00a0<\/li><\/ol>\n\n\n\n<p>That\u2019s it! You\u2019ve successfully created a database.&nbsp;&nbsp;<\/p>\n\n\n\n<div class=\"container row col-md-24 support-article panel panel-default panel-body\" style=\"background-color: #f6e9db; border-color: #ead9c7; border: 1px solid #ddd; border-radius: 4px; padding: 1% 2%; background-image: url('\/images\/my_account\/highlight.png'); background-position: left top; background-repeat: repeat-x;\">\n<p><span style=\"font-size: 17px;\"><strong style=\"color: #e77600 !important; font-size: 18px;\">Please Note: <\/strong>If you choose to install WordPress using our&nbsp;<a href=\"https:\/\/www.lcn.com\/support\/articles\/how-to-install-a-web-app\/\" target=\"_blank\" rel=\"noreferrer noopener\">one-click install<\/a>&nbsp;a new database will be made for you and placed inside your account.&nbsp;<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Databases are used with popular content management systems such as WordPress, Joomla or OpenCart. LCN\u202fWeb Hosting\u00a0and\u202fWordPress\u202fhosting\u00a0packages\u00a0provide\u00a0the ability to\u00a0create a new MySQL database from\u00a0your\u00a0LCN\u00a0account.\u00a0\u00a0 Let\u2019s get started\u2026&nbsp; How to create a MYSQL database Log in to\u202fyour LCN account&nbsp;and head to your&nbsp;Control Panel.&nbsp; Click\u202fon the&nbsp;domain&nbsp;you\u2019d like to add a database to.&nbsp; Now click&nbsp;Hosting Settings&nbsp;followed by&nbsp;MySQL.&nbsp; Next click&nbsp;Add [&hellip;]<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[7],"ht-kb-tag":[5],"class_list":["post-32","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-creating-and-managing-databases","ht_kb_tag-web-hosting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to create a MYSQL database - LCN.com Support Guide<\/title>\n<meta name=\"description\" content=\"How to create a MYSQL database at LCN.Create an MYSQL database for your website by following this simple step-by-step guide.\" \/>\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-mysql-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 MYSQL database - LCN.com Support Guide\" \/>\n<meta property=\"og:description\" content=\"How to create a MYSQL database at LCN.Create an MYSQL database for your website by following this simple step-by-step guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/\" \/>\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=\"2020-08-14T10:20:31+00:00\" \/>\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-mysql-database\/\",\"url\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/\",\"name\":\"How to create a MYSQL database - LCN.com Support Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#website\"},\"datePublished\":\"2020-02-12T10:36:13+00:00\",\"dateModified\":\"2020-08-14T10:20:31+00:00\",\"description\":\"How to create a MYSQL database at LCN.Create an MYSQL database for your website by following this simple step-by-step guide.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.lcn.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create a MYSQL database\"}]},{\"@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 MYSQL database - LCN.com Support Guide","description":"How to create a MYSQL database at LCN.Create an MYSQL database for your website by following this simple step-by-step guide.","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-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to create a MYSQL database - LCN.com Support Guide","og_description":"How to create a MYSQL database at LCN.Create an MYSQL database for your website by following this simple step-by-step guide.","og_url":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/","og_site_name":"Customer Support Guides - LCN","article_publisher":"https:\/\/www.facebook.com\/lcndotcom","article_modified_time":"2020-08-14T10:20:31+00:00","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-mysql-database\/","url":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/","name":"How to create a MYSQL database - LCN.com Support Guide","isPartOf":{"@id":"https:\/\/www.lcn.com\/support\/#website"},"datePublished":"2020-02-12T10:36:13+00:00","dateModified":"2020-08-14T10:20:31+00:00","description":"How to create a MYSQL database at LCN.Create an MYSQL database for your website by following this simple step-by-step guide.","breadcrumb":{"@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-create-a-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lcn.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to create a MYSQL database"}]},{"@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\/32","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":1,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/32\/revisions"}],"predecessor-version":[{"id":1218,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/32\/revisions\/1218"}],"wp:attachment":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-category?post=32"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}