Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error while trying to connect to the Mysql database: SQLSTATE[28000] [1045] Access denied for user 'xxx'@'localhost' (using password: YES) #462

Closed
anonymous-matomo-user opened this issue Dec 4, 2008 · 4 comments
Closed

Error while trying to connect to the Mysql database: SQLSTATE[28000] [1045] Access denied for user 'xxx'@'localhost' (using password: YES) #462

anonymous-matomo-user opened this issue Dec 4, 2008 · 4 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Milestone
RobotRock

Comments

@anonymous-matomo-user
Copy link

The following error has occured during databaseSetup-phase of PiWik installation:

```
Error while trying to connect to the Mysql database: SQLSTATE28000 1045
Access denied for user ’xxx’@’localhost’ (using password: YES)
```

Switching mysql-server from localhost to 127.0.0.1 does not help – it only generates the same error.

I am running Piwik on a shared-hosting solution without permission to change MySQL socket access rights, making this a show-stopper for my Piwik installation.
@robocoder
Copy link
Contributor

Try logging into the database from the command line (using “mysql”). If that fails, then it could mean your database and/or database user wasn’t properly created.

@mattab
Copy link
Member

mattab commented Dec 9, 2008

This is not a Piwik problem: it looks like your user doesn’t have permission to connect on this mysql server. please make sure your server adress, login, pwd are all correct.

@anonymous-matomo-user
Copy link
Author

Issue resolved: Typed 127.0.0.1 instead of localhost and installation works fine now.

If this is a common issue, I would suggest providing users with contextual help in installation program, or automatically resolve localhost to 127.0.0.1 in Piwik.

@anonymous-matomo-user anonymous-matomo-user added this to the RobotRock milestone Jul 8, 2014
Closed
@mattab mattab added the wontfix label Aug 3, 2014
@chisom5
Copy link

chisom5 commented Apr 15, 2018

What if my error is something like this Could not connect to the database : SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Milestone
RobotRock
Development

No branches or pull requests
4 participants
@mattab @robocoder @anonymous-matomo-user @chisom5