MySQL Error 1045, "Access denied for user 'user'@'localhost' (using password: YES)"

Question

This question seem to be asked a lot however I cannot find a definitive answer.

I am making some webapp tests using MySQL, and at the beginning I used the 'root' user (with a non-empty password). My root user is working fine from the apps (tested from PHP and Python's Django), from the command line, and with PHPMyAdmin.

However I don't wanted to use the the root user, so I created another user, and I granted all privileges to the databases that user should need. (I used PHPMyAdmin logged as 'root' for this task).

The new user cannot log in to MySQL. Neither from the Django app, nor PHPMyAdmin, nor the command line.

I have two possible suspicions:

there is a global privilege the user lacks. (As I said, I granted all database privileges, however I have not granted any global privileges);
the user's configured host. ('root' has four lines in the mysql.user table, for hosts 'localhost', 'my-pc-name', '127.0.0.1' and '::1'; while the new user has one line for host '%')

(I have double-checked the password, so I am confident this is not a password problem.)

Did you try granting privileges specifically for user@localhostinstead of using % wildcard? — ulentini
– ulentini, Commented Apr 13, 2013 at 14:59
@CarlosEugenioThompsonPinzón Good, keep in mind that % would not match unix socket connections, so you need to explicitly grant privileges for localhost — ulentini
– ulentini, Commented Apr 13, 2013 at 15:06

johnnaras · Accepted Answer · 2013-04-13 15:00:07Z

5

% means that the new user can access the database from any host.

However, if you supplied the CREATE USER statement would be much more useful.

In addition, check MySQL Manual below, where it explains why a user should have both @'localhost' and @'%':

MySQL Reference Manual - Adding Users

edited Apr 13, 2013 at 15:00

answered Apr 13, 2013 at 14:52

johnnaras

13910 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Carlos Eugenio Thompson Pinzón Over a year ago

Adding the user as @'localhost' helped. Thank you.

Jules Over a year ago

It's a shame that if it's so important to have a localhost version of each user that by default mysql's own admin program ("mysql workbench ce") doesn't provide an option for doing so in its modelling mode, instead providing only a way of creating the "@%" variant.

Yas · Accepted Answer · 2017-02-12 23:38:41Z

0

restarting mysql server + "flush privileges;" command solved it for me

answered Feb 12, 2017 at 23:38

Yas

2704 silver badges6 bronze badges

Collectives™ on Stack Overflow

MySQL Error 1045, "Access denied for user 'user'@'localhost' (using password: YES)"

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related