Joomla Database Error – Could not connect to MySQL
Joomla Database Error is common problem happening to many joomla users. One day i faced a problem in Joomla on a remote host for the past few days. Tried re installing using a fresh copy of the Joomla files so I even deleted the Joomla files (uploaded by past users of my development team) in the remote server, but I realised that I ended up getting the “could not connect to Database” message in the browser.
Then I tried to install using the manual installation method: After completing all the steps in the manual installation section of the installation manual, I got the error message again “Database Error: Unable to connect to the database:Could not connect to MySQL” .
How to solve Joomla Database Error ?
After referring to the forums, I changed the server host name to ‘localhost’, and the error message became “Database Error: Unable to connect to “Could not connect to database” Is this considered an improvement in my situation? (it looks like a partial improvement if any). how do I rectify the new error? i tried for 2 days i check My configuration.php info are as such: * Database configuration section
/* Database Settings */
var $dbtype = ‘mysql’; // Normally mysql
var $host = ‘localhost’;
// This is normally set to localhost
var $user = ‘xxx_xxxx’; // MySQL username
var $password = ‘xxxx’; // MySQL password
var $db = ‘xxx_xxxx’; // MySQL database name
var $dbprefix = ‘jos_’; // Do not change unless you need to!
/* Server Settings */
var $secret = ‘xxxxx’; //Change this to something more secure
var $gzip = ‘0’;
var $error_reporting = ‘-1’;
var $helpurl = ‘http://help.joomla.org’;
var $xmlrpc_server = ‘1’;
var $ftp_host = ‘xxxx.com’;
var $ftp_port = ’21’;
var $ftp_user = ‘xxxx’;
var $ftp_pass = ‘xxxx’;
var $ftp_root = ‘/www’;
var $ftp_enable = ‘1’;
var $tmp_path= ‘/tmp’;
var $log_path= ‘/var/logs’;
var $offset = ‘0’;
var $live_site = ”;
Full url to Joomla install. I have tried to recreate the database/username in my remote host’s cpanel, tried to download a fresh copy of the Joomla 1.5 files for uploading via ftp, almost everything that could try with reference to the manual and the forums but it doesn’t work. i backup mysql and agiain connected to configuration.php file And the error was not solved. then i think it was a manual error done by me.
If you followed above steps but still the Joomla Database Error is not resolved then it may be a error done by you in your database.
sometimes the site will load ,but some times it wont. when the site was loading i log in with one of my user account. i seen i have deleted some users in my joomla database, then again i have inserted tables in mysql with same user ids..then the joomla database error gone and i am so happy now..
🙂 🙂 what about u? Not solved ? post a comment for help.. or hire me to resolve your Joomla Database Error.