{"id":101,"date":"2016-01-04T15:04:15","date_gmt":"2016-01-04T15:04:15","guid":{"rendered":"http:\/\/truehost.co.ke\/blog\/?p=52"},"modified":"2024-06-07T12:41:31","modified_gmt":"2024-06-07T12:41:31","slug":"hosting-a-database-driven-website","status":"publish","type":"post","link":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/","title":{"rendered":"Hosting a database Driven Website"},"content":{"rendered":"<p><u>Hosting a database Driven Website<\/u><\/p>\n<p>Hosting a data base driven website on a Cpanel hosting as offered by Truehost is simple.<\/p>\n<p>They only difference between hosting a non-database driven website and website driven website is that a database driven website require database set up and upload.<\/p>\n<p><strong>Setting up database for a website, during web hosting<\/strong><\/p>\n<p>Login to your Cpanel using credentials provided by Truehost Kenya.<\/p>\n<p>Basically mean clicking on the Cpanel url <a href=\"http:\/\/www.yourdomain.com\/cpanel\">http:\/\/www.yourdomain.com\/cpanel<\/a> or http:\/\/www.serveripaddress\/~yourusername\/cpanel<\/p>\n<p>Input your username<\/p>\n<p>Input your password<\/p>\n<p>Login.<\/p>\n<p>On successful login, proceed to click mysql databases icon in the Cpanel<br \/>\n<u>Creating a database<\/u><\/p>\n<p>Under create database<\/p>\n<p>Give your database a name<\/p>\n<p>Click create database<\/p>\n<p>Database name will therefore be your username_newnameyouhavegiven<\/p>\n<p>&nbsp;<\/p>\n<p><u>Adding User to a new database<\/u><\/p>\n<p>Online databases do not use the root user as default on localhost (local development phpmyadmin)<\/p>\n<p>Under add new user<\/p>\n<p>Indicate username<\/p>\n<p>Username should have fewer than 7 characters<\/p>\n<p>Input a desired database password<\/p>\n<p>I recommend to use password creator to have a strong password.<\/p>\n<p>At this point make sure you have saved your database name, your database username and your database password in a text file for use in your website.<\/p>\n<p>&nbsp;<\/p>\n<p><u>Adding user to your database<\/u><\/p>\n<p>Under Add a User to a Database<\/p>\n<p>Selected the user you have created<\/p>\n<p>Select your database<\/p>\n<p>Click Add to add<\/p>\n<p>It prompts you for roles to issue you database user<\/p>\n<p>You may select all<\/p>\n<p>Then presses add to finalize.<\/p>\n<p><u>Uploading Database<\/u><\/p>\n<p>Make sure you have exported your database from your localhost (local development environment) to a .sql file or .zip file if you are dealing with large database.<\/p>\n<p>From your Cpanel Home<\/p>\n<p>Click on phpmyAdmin icon<\/p>\n<p>It will open in a new tab<\/p>\n<p>Choose the database created earlier from the left side panel<\/p>\n<p>Click on the database<\/p>\n<p>Click on import option<\/p>\n<p>Browse the location of your exported database<\/p>\n<p>Select database file to import<\/p>\n<p>On Successful import \u2013 you will have uploaded your database<\/p>\n<p>Upload the files in the normal way as illustrated in the upload of non-database driven website tutorial<\/p>\n<p>Ensure database connection or config files of your website reflect the new database name, new database user, new database password<\/p>\n<p>Server should remain localhost unless advised otherwise by Truehost team.<\/p>\n<p>&nbsp;<\/p>\n<p>Bingo \u2013 u r live now.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hosting a database Driven Website Hosting a data base driven website on a Cpanel hosting as offered by Truehost is simple. They only difference between hosting a non-database driven website and website driven website is that a database driven website require database set up and upload. Setting up database for a website, during web hosting [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[99,24,26,32,35,42],"tags":[143,94,95,144,145,97,100,101,105,106,107,146,126,127,147,148,149,150,151,152,153,154,155,133,60,156,138,157,158,139],"class_list":["post-101","post","type-post","status-publish","format-standard","hentry","category-cloud","category-graphics-design","category-hosting","category-seo","category-web-design","category-web-services","tag-africa","tag-application-hosting-companies-in-kenya","tag-best-cloud-companies-in-kenya","tag-best-small-and-medium-business-domain-registration","tag-best-smes-cloud-provider-in-kenya","tag-business-cloud-solution-providers","tag-cloud-companies-in-kenya","tag-cloud-computing-companies-in-kenya","tag-cloudpap","tag-cloudpap-hosting","tag-cpanel-web-hosting-in-kenya","tag-east-africa","tag-large-disk-space-hosting-in-kenya","tag-large-website-hosting","tag-small-and-medium-business-cloud","tag-small-and-medium-business-hosting-company","tag-small-and-medium-business-web-hosting-services","tag-small-business-cloud-data-back-up","tag-small-business-virtual-computers","tag-small-business-virtual-office","tag-smes-cloud-solutions","tag-smes-email-solutions","tag-smes-web-hosting-solution","tag-truehost","tag-truehost-kenya","tag-truehsot-kenya-web-hosting-guide","tag-web-development-companies-in-kenya","tag-web-hosting-a-data-base-driven-website","tag-web-hosting-tutorials-by-truehost-kenya","tag-website-design-company-in-kenya"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hosting a database Driven Website -<\/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:\/\/truehost.com\/support\/hosting-a-database-driven-website\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hosting a database Driven Website -\" \/>\n<meta property=\"og:description\" content=\"Hosting a database Driven Website Hosting a data base driven website on a Cpanel hosting as offered by Truehost is simple. They only difference between hosting a non-database driven website and website driven website is that a database driven website require database set up and upload. Setting up database for a website, during web hosting [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-04T15:04:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T12:41:31+00:00\" \/>\n<meta name=\"author\" content=\"kt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"kt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/\"},\"author\":{\"name\":\"kt\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/person\\\/13b0dca8f0a4699018d92ad9869668c8\"},\"headline\":\"Hosting a database Driven Website\",\"datePublished\":\"2016-01-04T15:04:15+00:00\",\"dateModified\":\"2024-06-07T12:41:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/\"},\"wordCount\":388,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\"},\"keywords\":[\"Africa\",\"application hosting companies in kenya\",\"best cloud companies in kenya\",\"Best Small and Medium Business Domain Registration\",\"Best SMEs Cloud provider in Kenya\",\"business cloud solution providers\",\"cloud companies in kenya\",\"cloud computing companies in kenya\",\"cloudpap\",\"cloudpap hosting\",\"cpanel web hosting in kenya\",\"East Africa\",\"large disk space hosting in kenya\",\"large website hosting\",\"Small and medium business cloud\",\"Small and Medium Business Hosting Company\",\"Small and Medium Business Web Hosting Services\",\"Small Business cloud data Back up\",\"Small Business Virtual Computers\",\"Small business virtual office\",\"SMEs Cloud Solutions\",\"SMEs Email Solutions\",\"SMEs Web Hosting solution\",\"truehost\",\"truehost kenya\",\"Truehsot kenya web hosting guide\",\"web development companies in kenya\",\"web hosting a data base driven website\",\"web hosting tutorials by truehost kenya\",\"website design company in kenya\"],\"articleSection\":[\"Cloud\",\"Graphics Design\",\"Hosting\",\"SEO\",\"web design\",\"Web Services\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/\",\"name\":\"Hosting a database Driven Website -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\"},\"datePublished\":\"2016-01-04T15:04:15+00:00\",\"dateModified\":\"2024-06-07T12:41:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/hosting-a-database-driven-website\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hosting a database Driven Website\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"name\":\"\",\"description\":\"Help In a Click\",\"publisher\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truehost.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\",\"name\":\"Truehost Kenya\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"width\":240,\"height\":48,\"caption\":\"Truehost Kenya\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/person\\\/13b0dca8f0a4699018d92ad9869668c8\",\"name\":\"kt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b15c3006fe3bf174dea56e93ccc38a5ca0aa2f465be4368c6e1dc5fe306f971a?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b15c3006fe3bf174dea56e93ccc38a5ca0aa2f465be4368c6e1dc5fe306f971a?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b15c3006fe3bf174dea56e93ccc38a5ca0aa2f465be4368c6e1dc5fe306f971a?s=96&r=g\",\"caption\":\"kt\"},\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/author\\\/truehost\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hosting a database Driven Website -","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:\/\/truehost.com\/support\/hosting-a-database-driven-website\/","og_locale":"en_US","og_type":"article","og_title":"Hosting a database Driven Website -","og_description":"Hosting a database Driven Website Hosting a data base driven website on a Cpanel hosting as offered by Truehost is simple. They only difference between hosting a non-database driven website and website driven website is that a database driven website require database set up and upload. Setting up database for a website, during web hosting [&hellip;]","og_url":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/","article_published_time":"2016-01-04T15:04:15+00:00","article_modified_time":"2024-06-07T12:41:31+00:00","author":"kt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"kt","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/#article","isPartOf":{"@id":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/"},"author":{"name":"kt","@id":"https:\/\/truehost.com\/support\/#\/schema\/person\/13b0dca8f0a4699018d92ad9869668c8"},"headline":"Hosting a database Driven Website","datePublished":"2016-01-04T15:04:15+00:00","dateModified":"2024-06-07T12:41:31+00:00","mainEntityOfPage":{"@id":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/"},"wordCount":388,"commentCount":0,"publisher":{"@id":"https:\/\/truehost.com\/support\/#organization"},"keywords":["Africa","application hosting companies in kenya","best cloud companies in kenya","Best Small and Medium Business Domain Registration","Best SMEs Cloud provider in Kenya","business cloud solution providers","cloud companies in kenya","cloud computing companies in kenya","cloudpap","cloudpap hosting","cpanel web hosting in kenya","East Africa","large disk space hosting in kenya","large website hosting","Small and medium business cloud","Small and Medium Business Hosting Company","Small and Medium Business Web Hosting Services","Small Business cloud data Back up","Small Business Virtual Computers","Small business virtual office","SMEs Cloud Solutions","SMEs Email Solutions","SMEs Web Hosting solution","truehost","truehost kenya","Truehsot kenya web hosting guide","web development companies in kenya","web hosting a data base driven website","web hosting tutorials by truehost kenya","website design company in kenya"],"articleSection":["Cloud","Graphics Design","Hosting","SEO","web design","Web Services"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/","url":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/","name":"Hosting a database Driven Website -","isPartOf":{"@id":"https:\/\/truehost.com\/support\/#website"},"datePublished":"2016-01-04T15:04:15+00:00","dateModified":"2024-06-07T12:41:31+00:00","breadcrumb":{"@id":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/truehost.com\/support\/hosting-a-database-driven-website\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"Hosting a database Driven Website"}]},{"@type":"WebSite","@id":"https:\/\/truehost.com\/support\/#website","url":"https:\/\/truehost.com\/support\/","name":"","description":"Help In a Click","publisher":{"@id":"https:\/\/truehost.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truehost.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/truehost.com\/support\/#organization","name":"Truehost Kenya","url":"https:\/\/truehost.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","width":240,"height":48,"caption":"Truehost Kenya"},"image":{"@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/truehost.com\/support\/#\/schema\/person\/13b0dca8f0a4699018d92ad9869668c8","name":"kt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b15c3006fe3bf174dea56e93ccc38a5ca0aa2f465be4368c6e1dc5fe306f971a?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b15c3006fe3bf174dea56e93ccc38a5ca0aa2f465be4368c6e1dc5fe306f971a?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b15c3006fe3bf174dea56e93ccc38a5ca0aa2f465be4368c6e1dc5fe306f971a?s=96&r=g","caption":"kt"},"url":"https:\/\/truehost.com\/support\/author\/truehost\/"}]}},"_links":{"self":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/posts\/101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/comments?post=101"}],"version-history":[{"count":1,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/posts\/101\/revisions"}],"predecessor-version":[{"id":11489,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/posts\/101\/revisions\/11489"}],"wp:attachment":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/media?parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/categories?post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/tags?post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}