Difference between revisions of "Unable to connect to the database"

From Joomla! Documentation

(I run into this problem during installation with XAMPP, as I thought I should create a new password and didn't leave it blank.)
m (The Most Common Reasons: clean up categories with <noinclude> tags)
Line 19: Line 19:
# Your database username or password has changed.
# Your database username or password has changed.
[[Category:Administration FAQ]]
[[Category:Administration FAQ]]
[[Category:Getting Started FAQ]]
[[Category:Getting Started FAQ]]
[[Category:Version 1.5 FAQ]]
[[Category:Version 1.5 FAQ]]</noinclude>
<endFeed />
<endFeed />

Latest revision as of 15:19, 1 September 2012

This Article Needs Your Help

This article is tagged because it NEEDS REVIEW. You can help the Joomla! Documentation Wiki by contributing to it.
More pages that need help similar to this one are here. NOTE-If you feel the need is satistified, please remove this notice.

Unable to Connect to the Database: Could Not Connect to MySQL

If during or after installation, you received "Unable to connect to the database" error, verify that you have entered your MySQL database details correctly. The installation script will not allow you to continue unless the details are correct. The error might be due to writing a password which doesn't exist: you are not expected to create a password for the database during installation.

If the failure occurs after moving your site to another host, check the following items of your configuration.php file. The normal database settings are the following:

var $dbtype = 'mysql';
var $host = 'localhost';
var $user = 'user_with_database_access';
var $db = 'the_actual_database_name';
var $dbprefix = 'table_prefix_';

The Most Common Reasons

  1. Sometimes you will see this message if MySQL has stopped running on your server. Your server administrator may temporarily turn MySQL off to run maintenance utilities. In such circumstances, your site will likely return shortly.
  2. Your database user has been deleted. If this is the case, you will need to recreate your database user with the same username and password that existed when you first installed Joomla. Use your domain control panel to administer this or contact your server administrator.
  3. Your database username or password has changed.