{"id":2397,"date":"2012-10-02T13:13:40","date_gmt":"2012-10-02T17:13:40","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/10\/02\/305-change-database-settings\/"},"modified":"2022-08-18T11:20:32","modified_gmt":"2022-08-18T15:20:32","slug":"change-joomla-database-settings","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/","title":{"rendered":"How to Change your Joomla Database Settings"},"content":{"rendered":"

In our last tutorial, we showed you how having the wrong database credentials in your Joomla 3 configuration.php file can cause the Error displaying the error page: Application Instantiation Error<\/a>. To resolve this database error, you need to confirm that your database credentials with your hosting provider match those set within your Joomla configuration file.<\/p>\n\n\n\n

In this tutorial, we are going to give you a broad overview of how to ensure your Joomla website is connecting successfully to your MySQL database. This article assumes that you are familiar with basic file editing, using a program such as the File Manager<\/a> (located within cPanel).<\/p>\n\n\n\n

Follow along with the steps below to learn how to change your Joomla database configuration settings<\/strong>.<\/p>\n\n\n\n

\"error-displaying-the-error-page-application-instantiation-error\"<\/figure><\/div>\n\n\n\n

How to Ensure You Are Using the Correct Joomla Database Configuration Settings:<\/h2>\n\n\n\n
  1. Review the database settings you are currently using<\/b>
    Using an editor of your choice and open your Joomla configuration.php file. This file will be located in the top level of your Joomla 3.0 files on your server. When you open the file, pay attention to the following settings: 
    public $host = 'localhost';
    public $user = 'juser';
    public $password = 'jpass';
    public $db = 'jdb';<\/pre> 
    As you can see in the above, my database server is localhost<\/b>. I am connecting to a database named jdb<\/b>, with juser<\/b> and jpass<\/b> as the database username and password. <\/span><\/p><\/li>
  2. Confirm with your Joomla Hosting <\/a>provider your settings are correct<\/b>
    Most hosting providers will give you an interface where you can setup databases. If you\u2019re familiar with their tools, confirm that the database settings you are using in your Joomla configuration.php file match what is set on the server. If you can\u2019t see the password set on the server, reset it so you can be sure you are using the correct database password. If you need any assistance, contact your host\u2019s technical support for further assistance.<\/li>
  3. If needed, update the database settings in Joomla\u2019s configuration.php file<\/b>
    The key to connecting Joomla 3.0 to your database successfully is knowing what your database settings actually are on your server, and then making sure they match within Joomla\u2019s configuration.php file. For example, if you reset your database password on the server in step 2 above, be sure to update the password in your configuration file as well.<\/li><\/ol>\n\n\n\n
    Congratulations, now  you know how to change your Joomla Database configuration settings! <\/p>\n","protected":false},"excerpt":{"rendered":"
    In our last tutorial, we showed you how having the wrong database credentials in your Joomla 3 configuration.php file can cause the Error displaying the error page: Application Instantiation Error. To resolve this database error, you need to confirm that your database credentials with your hosting provider match those set within your Joomla configuration file. Read More ><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4403,94,4288,4305],"tags":[4404],"class_list":["post-2397","post","type-post","status-publish","format-standard","hentry","category-joomla","category-joomla-3","category-website","category-databases","tag-joomla-v3"],"acf":[],"yoast_head":"\nHow to Change your Joomla Database Settings | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"If you're having any trouble connecting Joomla 3.0 to a MySQL database, read this article for an overview on the steps needed to ensure you have Joomla setup correctly.\" \/>\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.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Change your Joomla Database Settings | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"If you're having any trouble connecting Joomla 3.0 to a MySQL database, read this article for an overview on the steps needed to ensure you have Joomla setup correctly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-02T17:13:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-18T15:20:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg\" \/>\n<meta name=\"author\" content=\"Brad Markle\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brad Markle\" \/>\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:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/\"},\"author\":{\"name\":\"Brad Markle\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf\"},\"headline\":\"How to Change your Joomla Database Settings\",\"datePublished\":\"2012-10-02T17:13:40+00:00\",\"dateModified\":\"2022-08-18T15:20:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/\"},\"wordCount\":388,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg\",\"keywords\":[\"Joomla v3\"],\"articleSection\":[\"Joomla\",\"Joomla 3\",\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/\",\"name\":\"How to Change your Joomla Database Settings | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg\",\"datePublished\":\"2012-10-02T17:13:40+00:00\",\"dateModified\":\"2022-08-18T15:20:32+00:00\",\"description\":\"If you're having any trouble connecting Joomla 3.0 to a MySQL database, read this article for an overview on the steps needed to ensure you have Joomla setup correctly.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg\",\"width\":637,\"height\":417,\"caption\":\"error-displaying-the-error-page-application-instantiation-error\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Change your Joomla Database Settings\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf\",\"name\":\"Brad Markle\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/bradm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Change your Joomla Database Settings | InMotion Hosting","description":"If you're having any trouble connecting Joomla 3.0 to a MySQL database, read this article for an overview on the steps needed to ensure you have Joomla setup correctly.","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.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/","og_locale":"en_US","og_type":"article","og_title":"How to Change your Joomla Database Settings | InMotion Hosting","og_description":"If you're having any trouble connecting Joomla 3.0 to a MySQL database, read this article for an overview on the steps needed to ensure you have Joomla setup correctly.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-10-02T17:13:40+00:00","article_modified_time":"2022-08-18T15:20:32+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg","type":"","width":"","height":""}],"author":"Brad Markle","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Brad Markle","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/"},"author":{"name":"Brad Markle","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf"},"headline":"How to Change your Joomla Database Settings","datePublished":"2012-10-02T17:13:40+00:00","dateModified":"2022-08-18T15:20:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/"},"wordCount":388,"commentCount":1,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg","keywords":["Joomla v3"],"articleSection":["Joomla","Joomla 3","Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/","name":"How to Change your Joomla Database Settings | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg","datePublished":"2012-10-02T17:13:40+00:00","dateModified":"2022-08-18T15:20:32+00:00","description":"If you're having any trouble connecting Joomla 3.0 to a MySQL database, read this article for an overview on the steps needed to ensure you have Joomla setup correctly.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_joomla-3_global-configuration_error-displaying-the-error-page-application-instantiation-error.jpg","width":637,"height":417,"caption":"error-displaying-the-error-page-application-instantiation-error"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/joomla\/joomla-3\/change-joomla-database-settings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Change your Joomla Database Settings"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf","name":"Brad Markle","url":"https:\/\/www.inmotionhosting.com\/support\/author\/bradm\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2397"}],"version-history":[{"count":6,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2397\/revisions"}],"predecessor-version":[{"id":99927,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2397\/revisions\/99927"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}