{"id":809,"date":"2019-10-03T04:19:52","date_gmt":"2019-10-02T18:19:52","guid":{"rendered":"https:\/\/hostmate.com.au\/hosting\/?p=809"},"modified":"2019-10-04T22:49:21","modified_gmt":"2019-10-04T12:49:21","slug":"how-to-create-a-mysql-database","status":"publish","type":"post","link":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/","title":{"rendered":"How to create a MySQL database"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"809\" class=\"elementor elementor-809\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-03c098d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"03c098d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c9e85a0\" data-id=\"c9e85a0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-74c4c57 elementor-widget elementor-widget-text-editor\" data-id=\"74c4c57\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>To create a database and database user, login to cPanel and go to Databases &#10140; MySQL Databases. On that page &#8220;Create New Database&#8221;. Then &#8220;Add New User&#8221;. Then &#8220;Add User to Database&#8221; and select all privileges.<\/p><p>You can then start using the database with your website.\u00a0Update your website configuration file to use the new database and user details. The database host to use is &#8220;localhost&#8221;.<\/p><p>You can also manually add\/edit\/delete data in the database using phpMyAdmin. To access phpMyAdmin in cPanel go to Databases &#10140; phpMyAdmin. A new window will open, click on the database name in the left column, you can then start viewing and editing the database.<\/p><p>You can use phpMyAdmin to import backup database files of your existing databases.\u00a0<span style=\"font-size: 1rem;\">Click on the database name in the left column. Then click the Import tab at top of page in the right side pane. Click \u201cChoose File\u201d and select your database file from your PC. Then click \u201cGo\u201d at bottom of page. Then wait for the import to complete.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>To create a database and database user, login to cPanel and go to Databases &#10140; MySQL Databases. On that page &#8220;Create New Database&#8221;. Then &#8220;Add New User&#8221;. Then &#8220;Add User to Database&#8221; and select all privileges. You can then start using the database with your website.\u00a0Update your website configuration file to use the new database [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-809","post","type-post","status-publish","format-standard","hentry","category-databases"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to create a MySQL database - Hostmate Australia Website &amp; Email Hosting Support<\/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:\/\/hostmate.com.au\/hosting\/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 - Hostmate Australia Website &amp; Email Hosting Support\" \/>\n<meta property=\"og:description\" content=\"To create a database and database user, login to cPanel and go to Databases &#10140; MySQL Databases. On that page &#8220;Create New Database&#8221;. Then &#8220;Add New User&#8221;. Then &#8220;Add User to Database&#8221; and select all privileges. You can then start using the database with your website.\u00a0Update your website configuration file to use the new database [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Hostmate Australia Website &amp; Email Hosting Support\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-02T18:19:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-04T12:49:21+00:00\" \/>\n<meta name=\"author\" content=\"hostmate\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hostmate\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/\"},\"author\":{\"name\":\"hostmate\",\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/#\\\/schema\\\/person\\\/7df19dd4572dccba5ccb01180f83aed6\"},\"headline\":\"How to create a MySQL database\",\"datePublished\":\"2019-10-02T18:19:52+00:00\",\"dateModified\":\"2019-10-04T12:49:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/\"},\"wordCount\":177,\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-AU\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/\",\"url\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/\",\"name\":\"How to create a MySQL database - Hostmate Australia Website &amp; Email Hosting Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/#website\"},\"datePublished\":\"2019-10-02T18:19:52+00:00\",\"dateModified\":\"2019-10-04T12:49:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/#\\\/schema\\\/person\\\/7df19dd4572dccba5ccb01180f83aed6\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/how-to-create-a-mysql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"FAQ\",\"item\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/support\\\/faq\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/support\\\/faq\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to create a MySQL database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/#website\",\"url\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/\",\"name\":\"Hostmate Australia Website &amp; Email Hosting Support\",\"description\":\"Cheap WordPress Web Hosting with Excellent Australian Support\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/#\\\/schema\\\/person\\\/7df19dd4572dccba5ccb01180f83aed6\",\"name\":\"hostmate\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/782a997311333335c4309bd5cdf0f9ea7829c5be982a5534c38f79cf92b57cf0?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/782a997311333335c4309bd5cdf0f9ea7829c5be982a5534c38f79cf92b57cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/782a997311333335c4309bd5cdf0f9ea7829c5be982a5534c38f79cf92b57cf0?s=96&d=mm&r=g\",\"caption\":\"hostmate\"},\"url\":\"https:\\\/\\\/hostmate.com.au\\\/hosting\\\/author\\\/hostmate\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create a MySQL database - Hostmate Australia Website &amp; Email Hosting Support","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:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to create a MySQL database - Hostmate Australia Website &amp; Email Hosting Support","og_description":"To create a database and database user, login to cPanel and go to Databases &#10140; MySQL Databases. On that page &#8220;Create New Database&#8221;. Then &#8220;Add New User&#8221;. Then &#8220;Add User to Database&#8221; and select all privileges. You can then start using the database with your website.\u00a0Update your website configuration file to use the new database [&hellip;]","og_url":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/","og_site_name":"Hostmate Australia Website &amp; Email Hosting Support","article_published_time":"2019-10-02T18:19:52+00:00","article_modified_time":"2019-10-04T12:49:21+00:00","author":"hostmate","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hostmate","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/#article","isPartOf":{"@id":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/"},"author":{"name":"hostmate","@id":"https:\/\/hostmate.com.au\/hosting\/#\/schema\/person\/7df19dd4572dccba5ccb01180f83aed6"},"headline":"How to create a MySQL database","datePublished":"2019-10-02T18:19:52+00:00","dateModified":"2019-10-04T12:49:21+00:00","mainEntityOfPage":{"@id":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/"},"wordCount":177,"articleSection":["Databases"],"inLanguage":"en-AU"},{"@type":"WebPage","@id":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/","url":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/","name":"How to create a MySQL database - Hostmate Australia Website &amp; Email Hosting Support","isPartOf":{"@id":"https:\/\/hostmate.com.au\/hosting\/#website"},"datePublished":"2019-10-02T18:19:52+00:00","dateModified":"2019-10-04T12:49:21+00:00","author":{"@id":"https:\/\/hostmate.com.au\/hosting\/#\/schema\/person\/7df19dd4572dccba5ccb01180f83aed6"},"breadcrumb":{"@id":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/hostmate.com.au\/hosting\/how-to-create-a-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"FAQ","item":"https:\/\/hostmate.com.au\/hosting\/support\/faq\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/hostmate.com.au\/hosting\/support\/faq\/databases\/"},{"@type":"ListItem","position":3,"name":"How to create a MySQL database"}]},{"@type":"WebSite","@id":"https:\/\/hostmate.com.au\/hosting\/#website","url":"https:\/\/hostmate.com.au\/hosting\/","name":"Hostmate Australia Website &amp; Email Hosting Support","description":"Cheap WordPress Web Hosting with Excellent Australian Support","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hostmate.com.au\/hosting\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Person","@id":"https:\/\/hostmate.com.au\/hosting\/#\/schema\/person\/7df19dd4572dccba5ccb01180f83aed6","name":"hostmate","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/secure.gravatar.com\/avatar\/782a997311333335c4309bd5cdf0f9ea7829c5be982a5534c38f79cf92b57cf0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/782a997311333335c4309bd5cdf0f9ea7829c5be982a5534c38f79cf92b57cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/782a997311333335c4309bd5cdf0f9ea7829c5be982a5534c38f79cf92b57cf0?s=96&d=mm&r=g","caption":"hostmate"},"url":"https:\/\/hostmate.com.au\/hosting\/author\/hostmate\/"}]}},"_links":{"self":[{"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/posts\/809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/comments?post=809"}],"version-history":[{"count":10,"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/posts\/809\/revisions"}],"predecessor-version":[{"id":919,"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/posts\/809\/revisions\/919"}],"wp:attachment":[{"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/media?parent=809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/categories?post=809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostmate.com.au\/hosting\/wp-json\/wp\/v2\/tags?post=809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}