{"id":1964,"date":"2010-11-15T10:25:00","date_gmt":"2010-11-15T10:25:00","guid":{"rendered":"http:\/\/mts-help.nick.php.dev\/after_sale_support\/Demo_movies_database\/OsCommerce\/article8.html"},"modified":"2018-09-21T08:18:17","modified_gmt":"2018-09-21T12:18:17","slug":"how-to-create-a-database","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/how-to-create-a-database.html","title":{"rendered":"How to create a database"},"content":{"rendered":"<p>This tutorial shows how to create a database using hosting control panel.<\/p>\r\n<p>1. Open MySQL Databases.<\/p>\r\n\r\n<a href=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-1.png\"><img loading=\"lazy\" src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-1-300x168.png\" alt=\"\" title=\"How_to_create_a_database-1\" width=\"300\" height=\"168\" class=\"alignnone size-medium wp-image-24747\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-1-300x168.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-1-150x84.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-1.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>2. Specify database name.<\/p>\r\n\r\n<a href=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-2.png\"><img loading=\"lazy\" src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-2-300x158.png\" alt=\"\" title=\"How_to_create_a_database-2\" width=\"300\" height=\"158\" class=\"alignnone size-medium wp-image-24748\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-2-300x158.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-2-150x79.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-2.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>3. Add new database user.<\/p>\r\n\r\n<a href=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-3.png\"><img loading=\"lazy\" src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-3-300x162.png\" alt=\"\" title=\"How_to_create_a_database-3\" width=\"300\" height=\"162\" class=\"alignnone size-medium wp-image-24749\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-3-300x162.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-3-150x81.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-3.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>4. Assign database user to your database.<\/p>\r\n<p>4.1. Select user and database, click Add.<\/p>\r\n\r\n<a href=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-4.png\"><img loading=\"lazy\" src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-4-300x125.png\" alt=\"\" title=\"How_to_create_a_database-4\" width=\"300\" height=\"125\" class=\"alignnone size-medium wp-image-24750\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-4-300x125.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-4-150x62.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-4.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>4.2. Set all privileges for database user.<\/p>\r\n\r\n<a href=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-5.png\"><img loading=\"lazy\" src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-5-300x174.png\" alt=\"\" title=\"How_to_create_a_database-5\" width=\"300\" height=\"174\" class=\"alignnone size-medium wp-image-24751\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-5-300x174.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-5-150x87.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-5.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>5. In order to access database you should open phpmyadmin database management tool.<\/p>\r\n\r\n<a href=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-6.png\"><img loading=\"lazy\" src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-6-300x177.png\" alt=\"\" title=\"How_to_create_a_database-6\" width=\"300\" height=\"177\" class=\"alignnone size-medium wp-image-24752\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-6-300x177.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-6-150x88.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-6.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>6. Open your database.<\/p>\r\n\r\n<a href=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-7.png\"><img loading=\"lazy\" src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-7-300x107.png\" alt=\"\" title=\"How_to_create_a_database-7\" width=\"300\" height=\"107\" class=\"alignnone size-medium wp-image-24753\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-7-300x107.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-7-150x53.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2010\/11\/How_to_create_a_database-7.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n\r\n<a href=\"\/help\/files\/hosting\/How_to_create_a_database.htm\" target=\"blank\">How to create a database<\/a>\r\n\r\n<p>If you want to learn how to use a <a href=\"https:\/\/www.templatemonster.com\/blog\/create-website-2017-ultimate-guide\/\" target=\"_blank\">sitebuilder<\/a> and put together a great website, use the latest guidance from TemplateMonster.<\/p>\r\n\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/cart.php?addOffer=587\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-1-(500-x100).jpg\" \/>\r\n<\/a>\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>This tutorial shows how to create a database using hosting control panel.<\/p>\n","protected":false},"author":39,"featured_media":24802,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1019],"tags":[796,545],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/1964"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=1964"}],"version-history":[{"count":3,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/1964\/revisions"}],"predecessor-version":[{"id":82867,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/1964\/revisions\/82867"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/24802"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=1964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=1964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=1964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}