{"id":2795,"date":"2010-10-20T17:26:42","date_gmt":"2010-10-20T15:26:42","guid":{"rendered":"http:\/\/localhost\/helpcentre\/?p=2795"},"modified":"2026-01-30T10:18:51","modified_gmt":"2026-01-30T08:18:51","slug":"update-database-connection-strings","status":"publish","type":"post","link":"https:\/\/xneelo.co.za\/help-centre\/website\/update-database-connection-strings\/","title":{"rendered":"How to update database connection strings via konsoleH"},"content":{"rendered":"<p>Use the konsoleH\u00a0<a title=\"File Manager\" href=\"https:\/\/xneelo.co.za\/help-centre\/website\/file-manager\/\" target=\"_blank\" rel=\"noopener\">File Manager<\/a>\u00a0(recommended) or FTP program such as <a title=\"FileZilla\" href=\"https:\/\/xneelo.co.za\/help-centre\/website\/filezilla-ftp\/\" target=\"_blank\" rel=\"noopener\">FileZilla<\/a> or <a title=\"CuteFTP\" href=\"https:\/\/xneelo.co.za\/help-centre\/website\/cute-ftp\/\" target=\"_blank\" rel=\"noopener\">CuteFTP<\/a>\u00a0 to retrieve the configuration file and edit your database configuration.<\/p>\n<p>This is required when setting up a new database or when the database password has been updated. Using Option 1 (File Manager) is recommended as it makes edits directly on the server without the need to download, edit and then upload the configuration file via FTP.<\/p>\n<h2><b>Option1: Edit connection strings via File Manager:<\/b><\/h2>\n<div id=\"action_points\">\n<ol>\n<li>Browse to <a href=\"http:\/\/secure.konsoleh.co.za\" target=\"_blank\" rel=\"noopener noreferrer\">konsoleH<\/a>\u00a0and login<\/li>\n<li>Click <b>Manage Services<\/b>\u00a0from the left-hand menu<\/li>\n<li>Select <strong>Files &amp; Folders &gt;\u00a0<\/strong><b>File Manager<\/b><\/li>\n<li>Within File Manager select the configuration file and select <b>Edit<\/b>\u00a0from the right hand menu<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20375\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1.png\" alt=\"\" width=\"1828\" height=\"928\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1.png 1828w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1-300x152.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1-1024x520.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1-768x390.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1-1536x780.png 1536w\" sizes=\"auto, (max-width: 1828px) 100vw, 1828px\" \/><\/a><\/li>\n<li><strong>Manage MySQL<\/strong>\n<ul>\n<li>For <strong>WordPress<\/strong> please edit <strong>wp-config.php<\/strong><\/li>\n<li>For <strong>Joomla<\/strong> please edit <strong>configuration.php<\/strong><\/li>\n<li>For <strong>Drupal<\/strong> please edit <strong>sites\/default\/settings.php<\/strong><\/li>\n<li>For <strong>Magento<\/strong> please edit <strong>app\/etc\/local.xml<\/strong><\/li>\n<\/ul>\n<\/li>\n<li>Search for the information you wish to change and replace by clicking and replacing the text, where:\n<ul>\n<li>DB_NAME is the database name<\/li>\n<li>DB_USER is the database login<\/li>\n<li>DB_PASSWORD is the database password<\/li>\n<li>DB_HOST is the database server name (note that the database does not live on the same server as the website)<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20371\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2.png\" alt=\"\" width=\"1552\" height=\"1002\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2.png 1552w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2-300x194.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2-1024x661.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2-768x496.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2-1536x992.png 1536w\" sizes=\"auto, (max-width: 1552px) 100vw, 1552px\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>Click\u00a0<strong>Save Changes<\/strong><\/li>\n<\/ol>\n<\/div>\n<h2><b>Option2: Edit connection strings via FTP program:<\/b><\/h2>\n<div id=\"action_points\">\n<ol>\n<li>Make an FTP connection to your domain with your FTP program..<\/li>\n<li>Locate the <strong>public_html<\/strong>\u00a0directory. (In most programs you will be able to \u2018double click\u2019 to access this folder).<\/li>\n<li>Locate the applicable configuration file for your database eg. configuration.php.\n<ul>\n<li>For <strong>WordPress<\/strong> please edit <strong>wp-config.php<\/strong><\/li>\n<li>For <strong>Joomla<\/strong> please edit <strong>configuration.php<\/strong><\/li>\n<li>For <strong>Drupal<\/strong> please edit <strong>sites\/default\/settings.php<\/strong><\/li>\n<li>For <strong>Magento<\/strong> please edit <strong>app\/etc\/local.xml<\/strong><\/li>\n<\/ul>\n<\/li>\n<li>Download this file to your local computer.<\/li>\n<li>Open the file in Notepad or a <strong>text editor<\/strong> of your choice and search for the information (hostname, database name, username\/login, and password) you wish to change.<\/li>\n<li><strong>Replace<\/strong> all instances of the old information with the new details e.g. old passwords with new passwords.<\/li>\n<li><strong>Save<\/strong> your changes.<\/li>\n<li>Upload the updated configuration file with your FTP program to replace the current one.<\/li>\n<\/ol>\n<\/div>\n<div id=\"action_points\"><\/div>\n<p>Should you be familiar with Telnet or SSH you may wish to access and edit the configuration files directly on the hosting server.<\/p>\n","protected":false,"plain":"Use the konsoleH\u00a0<a title=\"File Manager\" href=\"https:\/\/xneelo.co.za\/help-centre\/website\/file-manager\/\" target=\"_blank\" rel=\"noopener\">File Manager<\/a>\u00a0(recommended) or FTP program such as <a title=\"FileZilla\" href=\"https:\/\/xneelo.co.za\/help-centre\/website\/filezilla-ftp\/\" target=\"_blank\" rel=\"noopener\">FileZilla<\/a> or <a title=\"CuteFTP\" href=\"https:\/\/xneelo.co.za\/help-centre\/website\/cute-ftp\/\" target=\"_blank\" rel=\"noopener\">CuteFTP<\/a>\u00a0 to retrieve the configuration file and edit your database configuration.\r\n\r\nThis is required when setting up a new database or when the database password has been updated. Using Option 1 (File Manager) is recommended as it makes edits directly on the server without the need to download, edit and then upload the configuration file via FTP.\r\n<h2><b>Option1: Edit connection strings via File Manager:<\/b><\/h2>\r\n<div id=\"action_points\">\r\n<ol>\r\n \t<li>Browse to <a href=\"http:\/\/secure.konsoleh.co.za\" target=\"_blank\" rel=\"noopener noreferrer\">konsoleH<\/a>\u00a0and login<\/li>\r\n \t<li>Click <b>Manage Services<\/b>\u00a0from the left-hand menu<\/li>\r\n \t<li>Select <strong>Files &amp; Folders &gt;\u00a0<\/strong><b>File Manager<\/b><\/li>\r\n \t<li>Within File Manager select the configuration file and select <b>Edit<\/b>\u00a0from the right hand menu<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1.png\"><img class=\"alignnone size-full wp-image-20375\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig1.png\" alt=\"\" width=\"1828\" height=\"928\" \/><\/a><\/li>\r\n \t<li><strong>Manage MySQL<\/strong>\r\n<ul>\r\n \t<li>For <strong>Wordpress<\/strong> please edit <strong>wp-config.php<\/strong><\/li>\r\n \t<li>For <strong>Joomla<\/strong> please edit <strong>configuration.php<\/strong><\/li>\r\n \t<li>For <strong>Drupal<\/strong> please edit <strong>sites\/default\/settings.php<\/strong><\/li>\r\n \t<li>For <strong>Magento<\/strong> please edit <strong>app\/etc\/local.xml<\/strong><\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Search for the information you wish to change and replace by clicking and replacing the text, where:\r\n<ul>\r\n \t<li>DB_NAME is the database name<\/li>\r\n \t<li>DB_USER is the database login<\/li>\r\n \t<li>DB_PASSWORD is the database password<\/li>\r\n \t<li>DB_HOST is the database server name (note that the database does not live on the same server as the website)<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2.png\"><img class=\"alignnone size-full wp-image-20371\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/11\/kh-file-manager-edit-wpconfig2.png\" alt=\"\" width=\"1552\" height=\"1002\" \/><\/a><\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Click\u00a0<strong>Save Changes<\/strong><\/li>\r\n<\/ol>\r\n<\/div>\r\n<h2><b>Option2: Edit connection strings via FTP program:<\/b><\/h2>\r\n<div id=\"action_points\">\r\n<ol>\r\n \t<li>Make an FTP connection to your domain with your FTP program..<\/li>\r\n \t<li>Locate the <strong>public_html<\/strong>\u00a0directory. (In most programs you will be able to \u2018double click\u2019 to access this folder).<\/li>\r\n \t<li>Locate the applicable configuration file for your database eg. configuration.php.\r\n<ul>\r\n \t<li>For <strong>Wordpress<\/strong> please edit <strong>wp-config.php<\/strong><\/li>\r\n \t<li>For <strong>Joomla<\/strong> please edit <strong>configuration.php<\/strong><\/li>\r\n \t<li>For <strong>Drupal<\/strong> please edit <strong>sites\/default\/settings.php<\/strong><\/li>\r\n \t<li>For <strong>Magento<\/strong> please edit <strong>app\/etc\/local.xml<\/strong><\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Download this file to your local computer.<\/li>\r\n \t<li>Open the file in Notepad or a <strong>text editor<\/strong> of your choice and search for the information (hostname, database name, username\/login, and password) you wish to change.<\/li>\r\n \t<li><strong>Replace<\/strong> all instances of the old information with the new details e.g. old passwords with new passwords.<\/li>\r\n \t<li><strong>Save<\/strong> your changes.<\/li>\r\n \t<li>Upload the updated configuration file with your FTP program to replace the current one.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<div id=\"action_points\"><\/div>\r\nShould you be familiar with Telnet or SSH you may wish to access and edit the configuration files directly on the hosting server."},"excerpt":{"rendered":"<p>We recommend that you use the\u00a0File Manager in konsoleH\u00a0to retrieve the configuration file. Alternatively, an FTP program such as FileZilla or CuteFTP.<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"lsx_disable_title":"0","_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"categories":[178,168,166],"tags":[23090,23093,18243,15460,263],"topics":[10403],"class_list":["post-2795","post","type-post","status-publish","format-standard","hentry","category-ftp","category-managing-website","category-website","tag-database-connection-strings","tag-update-database","tag-update-connection-strings","tag-database","tag-konsoleh","topics-konsoleh-tools"],"acf":[],"additional_meta":{"category_title":[{"term_id":178,"name":"FTP","slug":"ftp","term_group":0,"term_taxonomy_id":178,"taxonomy":"category","description":"Using FTP to upload files","parent":168,"count":14,"filter":"raw","term_order":"73","cat_ID":178,"category_count":14,"category_description":"Using FTP to upload files","cat_name":"FTP","category_nicename":"ftp","category_parent":168},{"term_id":168,"name":"Managing your Website","slug":"managing-website","term_group":0,"term_taxonomy_id":168,"taxonomy":"category","description":"Managing your Website","parent":166,"count":52,"filter":"raw","term_order":"83","cat_ID":168,"category_count":52,"category_description":"Managing your Website","cat_name":"Managing your Website","category_nicename":"managing-website","category_parent":166},{"term_id":166,"name":"Website","slug":"website","term_group":0,"term_taxonomy_id":166,"taxonomy":"category","description":"About your Website(s)","parent":0,"count":169,"filter":"raw","term_order":"120","cat_ID":166,"category_count":169,"category_description":"About your Website(s)","cat_name":"Website","category_nicename":"website","category_parent":0}],"tag_title":[{"term_id":23090,"name":"database connection strings","slug":"database-connection-strings","term_group":0,"term_taxonomy_id":23090,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"450"},{"term_id":23093,"name":"update database","slug":"update-database","term_group":0,"term_taxonomy_id":23093,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"451"},{"term_id":18243,"name":"update connection strings","slug":"update-connection-strings","term_group":0,"term_taxonomy_id":18243,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw","term_order":"2043"},{"term_id":15460,"name":"database","slug":"database","term_group":0,"term_taxonomy_id":15460,"taxonomy":"post_tag","description":"","parent":0,"count":12,"filter":"raw","term_order":"2569"},{"term_id":263,"name":"konsoleh","slug":"konsoleh","term_group":0,"term_taxonomy_id":263,"taxonomy":"post_tag","description":"","parent":0,"count":15,"filter":"raw","term_order":"2999"}]},"featured_image_src":null,"author_info":{"display_name":"marketing","author_link":"https:\/\/xneelo.co.za\/help-centre\/author\/marketing\/","author_avatar":"https:\/\/secure.gravatar.com\/avatar\/a6ea315e112423b2b955cb020fbce2b0835956c6ad85ff0f13f1db298977eaaa?s=96&d=mm&r=g"},"_links":{"self":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/2795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/comments?post=2795"}],"version-history":[{"count":0,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/2795\/revisions"}],"wp:attachment":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/media?parent=2795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/categories?post=2795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/tags?post=2795"},{"taxonomy":"topics","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/topics?post=2795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}