Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



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

Posts: 11
Name: samatha
Trades: 0
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
 
 
Register now for full access!
Old 12-31-2007, 04:23 PM Re: Unable to connect to database server!
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
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!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 12-31-2007, 04:56 PM Re: Unable to connect to database server!
ADAM Web Design's Avatar
Canadastaninianite

Posts: 5,938
Name: Adam for web page design, not program
Location: Toronto, Ontario, Canada
Trades: 0
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.
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
(my blog)


Please login or register to view this content. Registration is FREE
(with proof)
ADAM Web Design is offline
Reply With Quote
View Public Profile Visit ADAM Web Design's homepage!
 
Old 01-02-2008, 04:47 AM Re: Unable to connect to database server!
©®azy-¢øÐ3R's Avatar
Average Talker

Posts: 19
Name: kokokoko
Trades: 0
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.
©®azy-¢øÐ3R is offline
Reply With Quote
View Public Profile
 
Old 01-02-2008, 07:35 AM Re: Unable to connect to database server!
Novice Talker

Posts: 11
Name: samatha
Trades: 0
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, 08:51 AM Re: Unable to connect to database server!
Novice Talker

Posts: 11
Name: samatha
Trades: 0
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 09:04 AM..
sameeee is offline
Reply With Quote
View Public Profile
 
Old 02-02-2008, 09:59 AM Re: Unable to connect to database server!
Junior Talker

Posts: 1
Name: Dani
Trades: 0
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
-------------------------

Please login or register to view this content. Registration is FREE
TigerWarrior is offline
Reply With Quote
View Public Profile
 
Old 02-25-2008, 10:59 AM Re: Unable to connect to database server!
Experienced Talker

Posts: 34
Name: Jin
Location: Bangkok
Trades: 0
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 Search this Thread
Search this Thread:

Advanced Search

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

BB 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.39955 seconds with 12 queries