Posted - 05/23/2012 : 14:39:30
| Hello everyone, I am new here (been a member for about 5 seconds now) and new to being an admin. I will try to be brief with the backstory:
I am part of a website and found myself helping out on the web end of things. I have taken a few w3schools courses (primarily in HTML for fun) and a few crash courses on PHP and SQL, due to an error we are encountering. I have edited web pages and done things on our FTP, form tools, etc. without incident and am reasonably comfortable with it. Our webmistress has taken a hiatus and is unreachable, so I find myself the only one able to attempt to fix this and it is a bit beyond my "level" right now. Any help would be appreciated for my stupid questions and/or help with the error. The error is as follows:
SQL Error [mysql4]
Access denied for user "our addy@ip" (using password:YES) 
An SQL error occured while fetching this page. Please contact admin if this persists.
It allows access to the site sometimes, and pulls up that error other times. There doesn't seem to be a rhyme or reason to it, it has a fit and then is fine about 15 minutes later. Others have experienced this over the past few weeks and I have tried to watch for patterns which would alert me as to why this is happening, but alas, I have turned to you good people.
I have googled the heck out of it and found several "possible" fixes, things to try, but my very first dilemma is, where do I begin? I have used MySQL commander to back-up the site, and another location to download the updates to my pc (which isn't the host computer, by the way) but where to do I go to begin at least reading some of these tables to see if the password has been tweaked in the config file, etc? Is it stored in the FTP, the location I go to download them or is there a location I have missed? I guess that is my first major question if anyone can start me in the right direction. I like to think I am pretty bright, but this has bent my brain a little.
Thank you in advance!