Reply
Unable to connect to database server!
Old 12-31-2007, 07:05 AM Unable to connect to database server!
Novice Talker

Posts: 5
Name: samatha
Hi, I am at my wits end, I can not find out what is causeing this to happen, my host has been helping me get it set back and said some one changed the password and reset it for me, but still everything is good for about 3 days and then out of the blue this happens,

when I try to go to the shop I get

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ######@'localhost' (using password: YES) in /home/######/public_html/w#####.com/shop/includes/functions/database.php on line 24
Unable to connect to database server!

when I go to the admin page I get

Warning: mysql_connect() [function.mysql-connect]: Access denied for user #####@'localhost' (using password: YES) in /home/#####/public_html/w######.com/shop/mall_admin/includes/functions/database.php on line 24
Unable to connect to database server!

the answer I got on this,

the error you reported was an access denied error, which means either the username or password was incorrect, or persistant connections is disabled in the mysql configuration file.

the last time this happened I told this to my host and they said they fixed it, but again today it happened again,

Please Please someone tell what to do, my host is going to get tired of helping me, every three days, and I can't run Mall site when no one can get in,

Thanks
Sameeee
sameeee is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
     
Old 12-31-2007, 03:23 PM Re: Unable to connect to database server!
chrishirst's Avatar
Super Moderator

Posts: 11,894
Location: Blackpool. UK
Quote:
my host is going to get tired of helping me
Nope, that's what their support is there for. If you didn't change anything (passwords or usernames) in your files are database, it's something that they have configured incorrectly.

If they can't or won't get it right, find a new host!
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 12-31-2007, 03:56 PM Re: Unable to connect to database server!
ADAM Web Design's Avatar
Canadastaninianite

Posts: 5,945
Name: Adam for web page design, not program
Location: Toronto, Ontario, Canada
Hirst is right. If you didn't change it, it's one of two things:

1) A hosting issue (most likely).

2) A hack issue (which is a subset of a hosting or script issue, but one you may be able to self-determine). FTP to your site and see if there are any files there that you didn't upload or that were modified after you uploaded them in ways you don't do. That's often a tipoff.
ADAM Web Design is offline
Reply With Quote
View Public Profile Visit ADAM Web Design's homepage!
 
Old 01-02-2008, 03:47 AM Re: Unable to connect to database server!
©®azy-¢øÐ3R's Avatar
Average Talker

Posts: 19
Name: ©®azy-¢øÐ3R
Location: Doncaster
make sure your user and password is right.. sometimes u need to include the database and user name for example...

database name = hello username = hihi = hello_hihi

sometime it can be database name and username and other times it can just be username for example "hihi" if you dont have any clue about the server settings contact your host they will be happy to help with such a small problem.
__________________
Samari.org <----- check it out.
Proxy @ Samari.org 'N' FatBlitz @ Samari.org...
©®azy-¢øÐ3R is offline
Reply With Quote
View Public Profile Visit ©®azy-¢øÐ3R's homepage!
 
Old 01-02-2008, 06:35 AM Re: Unable to connect to database server!
Novice Talker

Posts: 5
Name: samatha
Thanks for your help. I changed the username and password, my site came back, also I found the persistant connections was disabled in the mysql configuration file. I set that to true, hope that was what is couseing it to happen, will let ya all know if it happens again, it had been doing it about every three days,

Thanks
Sameeee
sameeee is offline
Reply With Quote
View Public Profile
 
Old 01-06-2008, 07:51 AM Re: Unable to connect to database server!
Novice Talker

Posts: 5
Name: samatha
n update on what has been going on,
since I first made this topic almost every few days I have had to have my host fix this problem, as of yesterday. I have lost count of how many times they have helped me with this, and today it started again,
What is causeing this is happen??? I don't know, and I have no idea where to start to troubleshoot it, and get it fixed.

When I go to my mall I get
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user '*****_osc'@'localhost' (using password: YES) in /home/*******/public_html/*************.com/shop/includes/functions/database.php on line 22
Unable to connect to database server!

when I try to go to the admin I get
Warning: mysql_connect() [function.mysql-connect]: Access denied for user '********_osc'@'localhost' (using password: YES) in /home/*******/public_html/*********/shop/mall_admin/includes/functions/database.php on line 24
Unable to connect to database server!

I have asked if anyone else is having this problem and have gotten no answers so I guess it is working for everyone else,

I have installed osCMall on a different domain ( a addon domain with the same host ) and am waiting to see if I have this problem with it, so far it is working ok,

in another post Stephen answered on this,
the first error you reported was an access denied error, which means either the username or password was incorrect, or persistant connections is disabled in the mysql configuration file.

I have done this
my host says someone is changing the username and password, and to get my site back has been resetting the username and password,
in another post Stephen answered on this,
please make sure you remove the install directory as this is the only place that can edit the configuration files that i'm aware of.
the install directory was removed,

persistant connections was disabled in the mysql configuration file.
I set it to true,

some have said it might be my servers cofiguration,
What do I ask them to look for to fix it on their side???

All I am asking is for ideas! as to where to look and find the problem that is causeing this to happen so it can be fixed,
Sameeee

Last edited by sameeee : 01-06-2008 at 08:04 AM.
sameeee is offline
Reply With Quote
View Public Profile
 
Old 02-02-2008, 08:59 AM Re: Unable to connect to database server!
Junior Talker

Posts: 1
Name: Dani
I've got the same error while using mysql_connect() to a host "localhost". When I add localhost:3307 I got another error

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in

It seems to me a server settings related error ... not coding.

I would appreciate if someone can shine some more light ...
__________________
Tiger Warrior
-------------------------
www.000webhost.com
TigerWarrior is offline
Reply With Quote
View Public Profile
 
Old 02-25-2008, 09:59 AM Re: Unable to connect to database server!
Experienced Talker

Posts: 31
Name: Jin
Location: Bangkok
I have had some problems like this for mine I had the path to the files set wrong so you may want to just give that a quick check.
Thai Freelance is offline
Reply With Quote
View Public Profile Visit Thai Freelance's homepage!
 
Reply     « Reply to Unable to connect to database server!
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.15357 seconds with 13 queries