Database problem: Access denied for user 'mysite'@'localhost' (using password: YES)

wowheaded posted 5th of October 2008 in Community Voice. 11 comments.

Hi again people.

 

I'm now the process of installing dolphin on another site of mine. I'm doing everything exactly the same way as I've done it three times before on other sites, but this time I'm having major problems getting my SQL database to register.

 

I've been stuck on the database screen for hours now, constantly having to return and reinput the same info over and over. It's a total nightmare. Everytime I get to the final step, I have the dreaded :Access denied for user 'mysite'@'localhost' (using password: YES), and I just don;t understand why?

 

I've set up the DB, I can see it, and my username, as clear as day in my cPanel. It's there...I'm the only user on there. I even called my husband over to show him because I thought I was going nuts.

 

When inputting the info into the dolphin install area, I am doing it correctly. the DB and user are copied DIRECTLY from the MySql page on my hosting. I'm not putting in just the end part of the DB name, nor am I just putting in the end of the username, which I gather is a common mistake. I'm putting this in:

 

DB Name: site_dbname

User: site_username

 

Again, coppied directly from what is shown on mysql page.

 

What in the heck can be wrong? I just don't understand!

 

Also, I've tried deleting the DB/user and creating new ones and following the same input steps. Even that's not working.

 

This is my own hosting account and I have no restrictions in place to stop my db from going up or connecting. As I say, it's there...It's in my cPanel and it's registered on my homepage of my cPanel.

 

Any advice would be awesome. Thanks!

 

 
Comments
·Oldest
·Top
Please login to post a comment.
melia
You have to make sure that your site_username has permissions to access the site_dbname. If you are not using the default account you have to explicitly add the site_username using cpanel. It's the same page where you see the list of databases you have. Your site_username will show up in the list. When you see it, add it to the list of users allowed to access the site_dbname.

Good luck!
wowheaded
Hi Melia,

Thank you for your post :)

I'm actually logged directly into the cPanel for this site, rather than going through my main reseller cPan to access it right now. Perhaps I should try from the reseller end and see if that makes a difference. To be honest, I think I did that when I set up my other site the first time around.

I've also added the username to the DB with all privs set, so this problem is really confusing. I'm thinking it could have something to do with a problem I had see more over the whole hosting account the other day in that the whole phpMyAdmin system went down over everything and I had to ask for them (the providers) to sort it out for me. Maybe that has something to do with why it's not recognising me for this one now...
If you want to send me a PM I will help you with this.

CyberXing
melia
When you are in phpMyAdmin, you can check to see if your username does in fact have privileges to localhost. You can check by going to the phpMyAdmin home and clicking on privileges.

Here's a shot in the dark, try using root and providing the root password to your db. I don't suggest this but that might work.

If you've done previous installs on the same server or account, then it could be the issue you just mentioned.
nuccca
Hello,

I would recommend installing the BoonEx cPanel Addon that will allow instant installations throughout your domains. Its much more time efficient for multiple installations.


http://www.boonex.com/trac/dolphin/wiki/CpanelSyncAdd
-
Download/Install Instructions
a CPanel user doesnt have access to install the instant installer, this has to be done via the WHManger.

CyberXing
a CPanel user doesnt have access to install the instant installer, this has to be done via the WHManger.

CyberXing
nuccca
To quote wowheaded first comment
"Hi Melia,

Thank you for your post :)

I'm actually logged directly into the cPanel for this site, rather than going through my main reseller cPan to access it right now."

cPanel Resellers with access to WHM can install for you.
I have a shared host that installed the cPan-Addon for free, no problems.
Wowheaded,

I responded to you, but also wanted to make a suggestion, please post these questions and issues in the forums and not here on the blog site. :-)

Regards,
CyberXing
wowheaded
Hey Cyber,

For some reason my computer has a hard time loading the forum on here. My screen completely freezes and I get the wondering (not responding) error every time I click on it. :-(

I've also just heard back from my hosting team and they confirmed I am putting in the correct info. All I can think is that there must be an issue somewhere their end as I'm getting strange error messages for phpMyAdmin over numerous accounts that seem to pop up every couple of days over the last week.

Anyway, see more thanks for the help :)
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.056893110275269