The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 239 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8
Author Message
PostPosted: Fri Jan 21, 2011 5:32 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jan 19, 2011 12:39 am
Posts: 9
Well Ostoprohor I know basicly zero about this database style web sites. A I managed to resolve my issue by reading the 7 pages of info.

As well My error had some more text in read that said password=NO or something

good luck

Ostoprohor wrote:
I have the same problem. I am using WampServer2.1e-x32 localhost.
I now have this Database Error: Unable to connect to the database: Could not connect to MySQL

Anyone one please help.


Top
 Profile  
 
PostPosted: Wed Jan 26, 2011 7:56 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Jan 26, 2011 7:25 am
Posts: 1
Just thought I'd share what worked for me.

For some reason our configuration.php file's $password (database password) value was reset to a randomly generated password. Simply replace that with your password.

Not sure why this happens... due to Joomla or host provider?


Top
 Profile  
 
PostPosted: Sat Jan 29, 2011 9:12 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Aug 14, 2007 11:52 am
Posts: 30
Hi all,

regarding www.attention-fritid.se j1.5

Going nuts here. from some computers/browsers i get :
Database Error: Unable to connect to the database: Could not connect to MySQL

From some i dont.

i have:

set new user/pw = didnt work
checked existing 100 times.
Cleared cache
tryed live site setting
SEF on/ off

Suggestions?


Top
 Profile  
 
PostPosted: Sun Mar 06, 2011 10:56 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Mar 11, 2009 1:19 pm
Posts: 5
I have the same problem. I'm on hostgator and for the past couple of weeks I've been getting "Database Error: Unable to connect to the database: Could not connect to MySQL" completely randomly. I've double and triple checked every setting in Joomla, optimized my database, done everything I could, I've been in touch with Hostgator's support, but the random connect issue is still there.


Top
 Profile  
 
PostPosted: Tue Mar 22, 2011 11:36 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Sun Jun 17, 2007 9:17 am
Posts: 143
Location: Australia
hi guys.

i've got a simular problem but not quiet.

i've uploaded a few joomla and have done the sql and configuration.php changes before. however, the site im currently having problems with has been moved from one host to another. as far as i know everything in configuration.php is right. when i go to the site, all i get is that database error message. normally i just make the changes and it works but not this time.

any ideas on what to do? i've tried renaming the db, viewing the site via the ip address, uploaded new db, creating new user names and passwords, and a few other things but still nothing.

any help would be fantastic, thanks.


Top
 Profile  
 
PostPosted: Fri Mar 25, 2011 9:51 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Jan 19, 2011 1:33 am
Posts: 4
Hi all. I've had the same error a number of times with the same site. In all instances, I was making a change to the Global Site Settings. The most recent time I was updating the keywords but I've also had the same message when I have clicked the 'seo friendly URL' setting, and also the 'site offline' radio button. My hosting provider (MD Web Hosting and now NETREGISTRY) has been fantastic in their support. They have been able to get me back online reasonably quickly but it still doesn't help me understand why I can't update the global settings on my site.
Incidentally I have 2 other joomla installations with the same hosting account with the same provider and I can make global changes easily without being kicked out. If anyone can offer some insight it would be much appreciated.


Top
 Profile  
 
PostPosted: Mon Apr 11, 2011 7:06 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Apr 11, 2011 7:00 am
Posts: 1
;) Hi, folks. First time Joomla user and had all the problems we can think.

for the guys having the above error while installing joomla update or new version I had to change the backup to delete option on the database.

sure do your backup first and set it to delete instead of backup during the installation.

I was installing 1.6 version and my database had no data so it was a no brainer to try it but if you have data already on the database, please, take the precaution of backing up your database and doing the required adjustments afterwards.

Hope it helps. :)


Top
 Profile  
 
PostPosted: Wed Apr 13, 2011 3:09 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Feb 24, 2011 4:18 pm
Posts: 15
admodum wrote:
Hi there I'm having exactly the same message appearing on my new installation of the latest version of joomla 1.5. I have used ircmaxell's code below:

Code:
<?php
$host = 'localhost';
$user = 'mysqluser';
$pass = 'mypass';
$db = 'databasename';

//Don't change below here
$conn = mysql_connect($host, $user, $pass);
mysql_select_db($db, $conn);
echo '<hr />anything above this linebreak is BAD!';


Using the above code I got the following results:

Quote:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'admomco_joom1'@'localhost' (using password: YES) in /home/admomco/public_html/testserver/test.php on line 8

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/admomco/public_html/testserver/test.php on line 9
anything above this linebreak is BAD!


As far as I can tell all parameters are ok (database name / user / pass etc. But would the message above mean that there are some permissions that need to be changed by my webhost?

Thanks in advance
Jon


If you're using GoDaddy, this may be an issue brought on by not using their full hostname. Well, even if you are not using GoDaddy... Anyhow to find your full db hostname on GoDaddy go to the database control panel, choose the database you need, and note the long database hostname that looks sort of like this -- whatyouthoughtyourdatabasenamewas.db.1234567.hostedresource.com

Worked for me


Top
 Profile  
 
PostPosted: Thu Apr 14, 2011 10:03 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Dec 07, 2009 3:19 pm
Posts: 14
Thank you pe7er!! I changed the password for my cpanel and my site crashed. I got that "could not connect to database" error. 6 hours I tried to figure out what to do, then I came here. This was the first thing that came up when I did a search. Did what you said, looked in the configuration.php, got the db password and I had my site back up in about 3 minutes. ;D
You ROCK!!! I don't know why I didn't come here first. :-[


Top
 Profile  
 
PostPosted: Thu Jun 02, 2011 5:44 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Jun 02, 2011 5:33 am
Posts: 5
I was struggling with this issue quite some time. I was pretty sure that all my username and password and stuff in the configuration.php was correct. I even watched a guide-video on how to setup Joomla!. And they didn't solve my problem either. Then I used my own imagination...which worked. To solve this problem simply write ""mysql6.[url banned].com" or whatever you get as summary when you create the database. If you put this information instead of "localhost" everything works out fine ;-)

_________________
Please read forum rules regarding signatures: viewtopic.php?t=65


Top
 Profile  
 
PostPosted: Fri Jul 29, 2011 7:28 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Jul 29, 2011 7:26 am
Posts: 1
For those of you who get this error when trying to change SEF settings, use
Code:
ini_set('mysql.default_socket','/tmp/mysql.sock');
if you've got problems with "repairing" your website.


Top
 Profile  
 
PostPosted: Tue Aug 02, 2011 2:49 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Jun 01, 2007 12:48 am
Posts: 9
Location: San Antonio, TX
Network Solutions changed IP addresses of MySQL servers. If you have the IP hard coded in configuration.php, in lieu of "localhost" or "mydomain.xxx", check for accuracy.


Top
 Profile  
 
PostPosted: Thu Aug 04, 2011 3:09 am 
Joomla! Intern
Joomla! Intern

Joined: Thu Jul 07, 2011 9:00 pm
Posts: 51
I have not read this whole entire thread, but I will say that I encountered the same problem initially, upon installation (Joomla 1.5), and I later found out that the host name was incorrect. Though my hosting service did not "support" Joomla, they observed that the information I was provided was incorrect.

I recommend asking your hosting service to confirm the account details and login information you have acquired before assuming that the permissions are incorrect.


Top
 Profile  
 
PostPosted: Mon Aug 15, 2011 2:46 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Aug 15, 2011 2:30 am
Posts: 1
Alright, I'm also having the same "Database Error: Unable to connect to the database:Could not connect to MySQL" issue but on top of that I cannot log into phpmyadmin because of this error -"#2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 111" So I am completely stuck here. I have no idea if it's a hosting issue or not. When it happened I was only adding some text to my site, that's it. Is there anyway to somehow save my site, transfer it, something. I've put a lot of work into it and dont want to start over if possible.


Top
 Profile  
 
PostPosted: Tue Aug 16, 2011 3:41 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Aug 16, 2011 2:58 am
Posts: 1
I am having the same problem! I recently switched from godaddy to hostgator and Im now receiving this error message.


Top
 Profile  
 
PostPosted: Tue Aug 23, 2011 4:01 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Sat Jun 11, 2011 5:53 pm
Posts: 118
kaizentr wrote:
Thank you everyone i solve my problem

hi kaizentr
could u tell me how did u solve problem?

_________________
Phan mem crm ==> http://winmain.vn
dien thoai - laptop ==> http://itlead.vn


Top
 Profile  
 
PostPosted: Wed Aug 24, 2011 7:57 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Jul 24, 2009 8:12 pm
Posts: 17
Some great posts, I tried them all and nothing helped. I tried the PHP connection script (btw the script is not closed with "?>") and the connection was fine.

Finally, I started the installation process over again and it worked even though I entered the same exact DB connection data in the form.

_________________
Steve Moreland
CEO, Intexch, Inc.
http://www.intexch.com


Top
 Profile  
 
PostPosted: Wed Sep 28, 2011 9:22 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Sep 27, 2011 10:50 pm
Posts: 3
Hello
I am using 1.5.22 version and everything is OK but when i add a new article and share it in social media (facebook , twitter) "Unable to connect to the Database" error message appear and after two or three minute disappear.

I checked my database and i found max_connections = 1.500 and max user connections = 10
Please, can anyone know why this message?

Thanks


Top
 Profile  
 
PostPosted: Thu Dec 08, 2011 6:49 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Dec 08, 2011 4:47 pm
Posts: 14
I had this problem and my host support took me through changing the parameters in configuration.php and now it's all good.


Top
 Profile  
 
PostPosted: Fri Dec 09, 2011 8:06 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Thu Nov 02, 2006 10:43 am
Posts: 251
@JannetB8
Think you can list the changes?
Just in case I get that later on :P

_________________
Down with winBLOWS
Long Live Open Source


Top
 Profile  
 
PostPosted: Wed Jan 04, 2012 11:03 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Sep 04, 2010 7:06 pm
Posts: 8
ferret141 wrote:
The config can be found in the main directory where you uploaded Joomla to.


Just want to mention a 'gotcha' which has had me stumped for the last day.

Check that there is not a configuration.php file in your /local directory.

(As I just moved joomla to a new host I ftp'd my local copy running in wamp up to the webserver. I changed the database settings in the main /configuration.php file and was getting the intermittent 'cannot connect' errors. I just remembered to delete the copy in /local/configuration.php and all works well now. Maybe its some sort of cacheing thing that means joomla intermittently picks up the proper /configuration.php file instead of the /local one, I dunno.)


Top
 Profile  
 
PostPosted: Tue Feb 07, 2012 2:48 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Feb 07, 2012 1:28 am
Posts: 5
please can u guys help me out too. am new to joomla and am trying to host my first website, but have been having problem with the final stage where i need to paste the web source code in the sql section of the database. according to the tutorial am using, the query suppose to be successful and the website available, but i dont know what is wrong, there is no information as regard whether any success or failure and the home page of the web is displaying index of..

Please i really need help.

Thanks


Top
 Profile  
 
PostPosted: Sat Mar 17, 2012 12:03 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Mar 16, 2012 11:49 pm
Posts: 2
Hi
have the same problem on step 4 when I install Joomla 1.5 on Godaddy ( this is not my first site on godaddy i have 10 more ) they all work fine on my godaddy account , but now I try to install clean copy of joomla to another GoDadday account and the problems start

here is the link where I try to install joomla 1.5 - http://wesbrookpreschool.com/treta

and here is the DB details from godaddy -
$hostname='p50mysql393.secureserver.net';
$username='proba23';
$password='Viabolid1!';
$dbname='proba23';
$usertable='jos_';

Please help me to resolve the problem

Even if I try to auto install ( offered by Godaddy) there is still error connecting with the DB


Top
 Profile  
 
PostPosted: Sat Mar 17, 2012 11:58 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Mar 16, 2012 11:49 pm
Posts: 2
mecho24 wrote:
Hi
have the same problem on step 4 when I install Joomla 1.5 on Godaddy ( this is not my first site on godaddy i have 10 more ) they all work fine on my godaddy account , but now I try to install clean copy of joomla to another GoDadday account and the problems start

here is the link where I try to install joomla 1.5 - http://wesbrookpreschool.com/treta

and here is the DB details from godaddy -
$hostname='p50mysql393.secureserver.net';
$username='proba23';
$password='Viabolid1!';
$dbname='proba23';
$usertable='jos_';

Even if I try to auto install ( offered by Godaddy) there is still error connecting with the DB


Please help me to resolve the problem


I also create DB on my Godaddy account where the DB is working , and try to connect the new Db on my Godaddy account to the domain of the other Godaddy account and the same message appears


Top
 Profile  
 
PostPosted: Fri May 25, 2012 7:53 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri May 25, 2012 6:15 am
Posts: 1
Hi,
I have developed a website using Joomla 1.5 CMS. Recently I am facing a problem which I want to share with you.
Whenever any webpage of the website is loaded, sometimes the following error message is showing---
"Database Error: Unable to connect to the database:Could not connect to MySQL"
But after refreshing it for 1 or 2 times,it is again loading properly.
After seeing the probable solution from the Internet,I have verified the below parameters is configuration.php file--
var $dbtype = 'mysql';
var $host = 'localhost';
var $user = 'user_with_database_access';
var $db = 'the_actual_database_name';
var $dbprefix = 'table_prefix_';
But found no problem there.Can anyone help me in this regard????


Top
 Profile  
 
PostPosted: Mon Jul 09, 2012 9:15 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Apr 20, 2009 9:22 pm
Posts: 21
To me it was a read/write/execute issue.
Configuration.php was only read.

Change permissions to write as well, and the changed configuration.php will also be saved.

_________________
Kristian M. Kamstrup
Netdyrlæge.dk - din dyrlæge på nettet


Top
 Profile  
 
PostPosted: Fri Jan 11, 2013 11:32 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Jun 05, 2008 8:47 pm
Posts: 2
I have the same problem. Only logging into the administrator panel in Joomla 1.5.26.

It happened after I installed and started running JUpdate. The front end is fine. Now I cannot get into my administrator panel to work on the site.

I read elsewhere that some programs turn the sql server detection off while running.

My configuration.php is fine.

I hope someone has the answer.


Top
 Profile  
 
PostPosted: Wed Jan 23, 2013 12:48 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Jul 05, 2010 10:07 pm
Posts: 33
I am using godaddy. A year before I installed Joomla. Today I meddled with database and reset the password there. Then I got this error.

I went to configuration.php file and changed the password there to the one I reset. It solved the problem.


Top
 Profile  
 
PostPosted: Thu Feb 14, 2013 5:22 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Dec 04, 2012 7:45 pm
Posts: 2
It is impossible to investigate something that is 100% random!

95% the site is OK and it is constantly serving pages, around 4000 daily. Not a great thing, but decent.

Then I open the administrator (I just did) and I tried to add a new note and this is all I got after tapping on the green NEW button:

Database Error: Unable to connect to the database:Could not connect to MySQL

Then I refresh and refresh and refresh 4 or 5 or 6 times and voilà it opens again! But it's totally unpredictable.

Does anybody have a reason for this?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 239 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8



Who is online

Users browsing this forum: ichiro [Crawler] and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group