## The Question :

451 people think this question is useful

First let me mention that I’ve gone through many suggested questions and found no relevent answer. Here is what I’m doing.

I’m connected to my Amazon EC2 instance. I can login with MySQL root with this command:

mysql -u root -p



Then I created a new user bill with host %

CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass';



Granted all the privileges to user bill:

grant all privileges on *.* to 'bill'@'%' with grant option;



Then I exit from root user and try to login with bill:

mysql -u bill -p



entered the correct password and got this error:

• Did you FLUSH PRIVILEGES?
• Okay, I tried this without any success. Any other suggestion please.
• This happened to me while installing Magento and I made a much sillier mistake. Putting ‘mysql -u magento -p magento’ was prompting me for a password and instead of the default password I was putting the root password in.
• @authentictech unfortunately, none of the suggested solutions worked for me at the time this question was posted. Please see my own answer that helped me getting outa this situation. That is the reason I did not mark any of them as the answer. Probably I can mark the highest ranked response as answer.

452 people think this answer is useful

You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1'.

As per the manual:

When multiple matches are possible, the server must determine which of them to use. It resolves this issue as follows: (…)

• When a client attempts to connect, the server looks through the rows [of table mysql.user] in sorted order.
• The server uses the first row that matches the client host name and user name.

(…) The server uses sorting rules that order rows with the most-specific Host values first. Literal host names [such as ‘localhost’] and IP addresses are the most specific.

Hence, such an anonymous user would “mask” any other user like '[any_username]'@'%' when connecting from localhost.

'bill'@'localhost' does match 'bill'@'%', but would match (e.g.) ''@'localhost' beforehands.

The recommended solution is to drop this anonymous user (this is usually a good thing to do anyways).

Below edits are mostly irrelevant to the main question. These are only meant to answer some questions raised in other comments within this thread.

Edit 1

Authenticating as 'bill'@'%' through a socket.


root@myhost:/home/mysql-5.5.16-linux2.6-x86_64# ./mysql -ubill -ppass --socket=/tmp/mysql-5.5.sock
Welcome to the MySQL monitor (...)

mysql> SELECT user, host FROM mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| bill | %         |
| root | 127.0.0.1 |
| root | ::1       |
| root | localhost |
+------+-----------+
4 rows in set (0.00 sec)

mysql> SELECT USER(), CURRENT_USER();
+----------------+----------------+
| USER()         | CURRENT_USER() |
+----------------+----------------+
| bill@localhost | bill@%         |
+----------------+----------------+
1 row in set (0.02 sec)

mysql> SHOW VARIABLES LIKE 'skip_networking';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| skip_networking | ON    |
+-----------------+-------+
1 row in set (0.00 sec)



Edit 2

Exact same setup, except I re-activated networking, and I now create an anonymous user ''@'localhost'.


root@myhost:/home/mysql-5.5.16-linux2.6-x86_64# ./mysql
Welcome to the MySQL monitor (...)

mysql> CREATE USER ''@'localhost' IDENTIFIED BY 'anotherpass';
Query OK, 0 rows affected (0.00 sec)

mysql> Bye

root@myhost:/home/mysql-5.5.16-linux2.6-x86_64# ./mysql -ubill -ppass \
--socket=/tmp/mysql-5.5.sock
root@myhost:/home/mysql-5.5.16-linux2.6-x86_64# ./mysql -ubill -ppass \
-h127.0.0.1 --protocol=TCP
root@myhost:/home/mysql-5.5.16-linux2.6-x86_64# ./mysql -ubill -ppass \
-hlocalhost --protocol=TCP



Edit 3

Same situation as in edit 2, now providing the anonymous user’s password.


root@myhost:/home/mysql-5.5.16-linux2.6-x86_64# ./mysql -ubill -panotherpass -hlocalhost
Welcome to the MySQL monitor (...)

mysql> SELECT USER(), CURRENT_USER();
+----------------+----------------+
| USER()         | CURRENT_USER() |
+----------------+----------------+
| bill@localhost | @localhost     |
+----------------+----------------+
1 row in set (0.01 sec)



Conclusion 1, from edit 1: One can authenticate as 'bill'@'%'through a socket.

Conclusion 2, from edit 2: Whether one connects through TCP or through a socket has no impact on the authentication process (except one cannot connect as anyone else but 'something'@'localhost' through a socket, obviously).

Conclusion 3, from edit 3: Although I specified -ubill, I have been granted access as an anonymous user. This is because of the “sorting rules” advised above. Notice that in most default installations, a no-password, anonymous user exists (and should be secured/removed).

145 people think this answer is useful

Try:

~$mysql -u root -p Enter Password: mysql> grant all privileges on *.* to bill@localhost identified by 'pass' with grant option;  ## The Answer 3 84 people think this answer is useful When you ran mysql -u bill -p  and got this error ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)  mysqld is expecting you to connect as bill@localhost Try creating bill@localhost CREATE USER bill@localhost IDENTIFIED BY 'passpass'; grant all privileges on *.* to bill@localhost with grant option;  If you want to connect remotely, you must specify either the DNS name, the public IP, or 127.0.0.1 using TCP/IP: mysql -u bill -p -hmydb@mydomain.com mysql -u bill -p -h10.1.2.30 mysql -u bill -p -h127.0.0.1 --protocol=TCP  Once you login, please run this SELECT USER(),CURRENT_USER();  USER() reports how you attempted to authenticate in MySQL CURRENT_USER() reports how you were allowed to authenticate in MySQL from the mysql.user table This will give you a better view of how and why you were allowed to login to mysql. Why is this view important to know? It has to do with the user authentication ordering protocol. Here is an example: I will create an anonymous user on my desktop MySQL mysql> select user,host from mysql.user; +---------+-----------+ | user | host | +---------+-----------+ | lwdba | % | | mywife | % | | lwdba | 127.0.0.1 | | root | 127.0.0.1 | | lwdba | localhost | | root | localhost | | vanilla | localhost | +---------+-----------+ 7 rows in set (0.00 sec) mysql> grant all on *.* to x@'%'; Query OK, 0 rows affected (0.02 sec) mysql> select user,host from mysql.user; +---------+-----------+ | user | host | +---------+-----------+ | lwdba | % | | mywife | % | | x | % | | lwdba | 127.0.0.1 | | root | 127.0.0.1 | | lwdba | localhost | | root | localhost | | vanilla | localhost | +---------+-----------+ 8 rows in set (0.00 sec) mysql> update mysql.user set user='' where user='x'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> select user,host from mysql.user; +---------+-----------+ | user | host | +---------+-----------+ | | % | | lwdba | % | | mywife | % | | lwdba | 127.0.0.1 | | root | 127.0.0.1 | | lwdba | localhost | | root | localhost | | vanilla | localhost | +---------+-----------+ 8 rows in set (0.00 sec) mysql>  OK watch me login as anonymous user: C:\MySQL_5.5.12>mysql -urol -Dtest -h127.0.0.1 --protocol=TCP Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.5.12-log MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user(),current_user(); +---------------+----------------+ | user() | current_user() | +---------------+----------------+ | rol@localhost | @% | +---------------+----------------+ 1 row in set (0.00 sec) mysql>  Authentication ordering is very strict. It checks from the most specific to the least. I wrote about this authentiation style in the DBA StackExchange. Don’t forget to explicitly call for TCP as the protocol for mysql client when necessary. ## The Answer 4 27 people think this answer is useful Super late to this I tried all of these other answers and ran many different versions of mysql -u root -p but never just ran mysql -u root -p And just pressing [ENTER] for the password. Once I did that it worked. Hope this helps someone. ## The Answer 5 21 people think this answer is useful When you type mysql -u root -p , you’re connecting to the mysql server over a local unix socket. However the grant you gave, 'bill'@'%' only matches TCP/IP connections curiously enough. If you want to grant access to the local unix socket, you need to grant privileges to ‘bill’@’localhost’ , which curiously enough is not the same as ‘bill’@’127.0.0.1’ You could also connect using TCP/IP with the mysql command line client, as to match the privileges you already granted, e.g. run mysql -u root -p -h 192.168.1.123 or whichever local IP address your box have. ## The Answer 6 20 people think this answer is useful A related problem in my case was trying to connect using : mysql -u mike -p mypass  Whitespace IS apparently allowed between the -u #uname# but NOT between the -p and #password# Therefore needed: mysql -u mike -pmypass  Otherwise with white-space between -p mypass mysql takes ‘mypass’ as the db name ## The Answer 7 20 people think this answer is useful If you forget your password or you want to modify your password.You can follow these steps : 1 :stop your mysql [root@maomao ~]# service mysqld stop Stopping MySQL: [ OK ] 2 :use “–skip-grant-tables” to restart mysql [root@mcy400 ~]# mysqld_safe –skip-grant-tables [root@cy400 ~]# Starting mysqld daemon with databases from /var/lib/mysql 3 : open a new window and input mysql -u root [root@cy400 ~]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. 4 : change the user database mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed 5 : modify your password your new password should be input in “（）” mysql> update user set password=password(‘root123′) where user=’root’; Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0 6 : flush mysql> flush privileges; 7: quit mysql> quit Bye 8: restart mysql [root@cy400 ~]# service mysqld restart; Stopping MySQL: [ OK ] Starting MySQL: [ OK ] Bingo！ You can connect your database with your username and new password: [root@cy400 ~]# mysql -u root -p <br> Enter password: admin123 <br> Welcome to the MySQL monitor. Commands end with ; or \g. <br> Your MySQL connection id is 2 <br> Server version: 5.0.77 Source distribution <br> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. <br> mysql> quit <br> Bye  ## The Answer 8 17 people think this answer is useful Save yourself of a MAJOR headache… Your problem might be that you are missing the quotes around the password. At least that was my case that detoured me for 3 hours. [client] user = myusername password = "mypassword" # <----------------------- VERY IMPORTANT (quotes) host = localhost  http://dev.mysql.com/doc/refman/5.7/en/option-files.html Search for “Here is a typical user option file:” and see the example they state in there. Good luck, and I hope to save someone else some time. ## The Answer 9 14 people think this answer is useful I had a somewhat similar problem – on my first attempt to enter MySQL, as root, it told me access denied. Turns out I forgot to use the sudo So, if you fail on root first attempt, try: sudo mysql -u root -p  and then enter your password, this should work. ## The Answer 10 13 people think this answer is useful The solution is to delete the anonymous (Any) user! I also faced the same issue on a server setup by someone else. I normally don’t choose to create an anonymous user upon installing MySQL, so hadn’t noticed this. Initially I logged in as “root” user and created a couple of “normal” users (aka users with privileges only on dbs with their username as prefix), then logged out, then went on to verify the first normal user. I couldn’t log in. Neither via phpMyAdmin, nor via shell. Turns out, the culprit is this “Any” user. ## The Answer 11 7 people think this answer is useful The best solution i found for myself is. my user is sonar and whenever i am trying to connect to my database from external or other machine i am getting error as ERROR 1045 (28000): Access denied for user 'sonar'@'localhost' (using password: YES)  Also as i am trying this from another machine and through Jenkins job my URL for accessing is alm-lt-test.xyz.com  if you want to connect remotely you can specify it with different ways as follows: mysql -u sonar -p -halm-lt-test.xyz.com mysql -u sonar -p -h101.33.65.94 mysql -u sonar -p -h127.0.0.1 --protocol=TCP mysql -u sonar -p -h172.27.59.54 --protocol=TCP  To access this with URL you just have to execute the following query. GRANT ALL ON sonar.* TO 'sonar'@'localhost' IDENTIFIED BY 'sonar'; GRANT ALL ON sonar.* TO 'sonar'@'alm-lt-test.xyz.com' IDENTIFIED BY 'sonar'; GRANT ALL ON sonar.* TO 'sonar'@'127.0.0.1' IDENTIFIED BY 'sonar'; GRANT ALL ON sonar.* TO 'sonar'@'172.27.59.54' IDENTIFIED BY 'sonar';  ## The Answer 12 6 people think this answer is useful It’s a difference between: CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass';  and CREATE USER 'bill'@'localhost' IDENTIFIED BY 'passpass';  Check it: mysql> select user,host from mysql.user; +---------------+----------------------------+ | user | host | +---------------+----------------------------+ | bill | % | <=== created by first | root | 127.0.0.1 | | root | ::1 | | root | localhost | | bill | localhost | <=== created by second +---------------+----------------------------+  The command mysql -u bill -p  access implicit to ‘bill’@’localhost’ and NOT to ‘bill’@’%’. There are no permissions for ‘bill’@’localhost’ you get the error: ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)  solving the problem: CREATE USER 'bill'@'localhost' IDENTIFIED BY 'passpass'; grant all privileges on . to 'bill'@'localhost' with grant option;  ## The Answer 13 5 people think this answer is useful Okay, I’m not sure but probably this is my.cnf file inside mysql installation directory is the culprit. Comment out this line and the problem might be resolved. bind-address = 127.0.0.1  ## The Answer 14 4 people think this answer is useful Just wanted to let you know a unusual circumstance I received the same error. Perhaps this helps someone in the future. I had developed a few base views, created at the development site and transferred them to the production-site. Later that week I changed a PHP script and all of a sudden errors came up that Access was denied for user ‘local-web-user’@’localhost’. The datasource object had not changed, so I concentrated on the database user in MySQL, worrying in the meantime someone hacked my website. Luckily the rest of the site seemed unharmed. It later turned out that the views were the culprit(s). Our object transfers are done using another (and remote: admin@ip-address) user than the local website user. So the views were created with ‘admin’@’ip-address’ as the definer. The view creation SECURITY default is SQL SECURITY DEFINER  When local-web-user tries to use the view it stumbles on the lacking privileges of the definer to use the tables. Once security was changed to: SQL SECURITY INVOKER  the issue was resolved. The actual problem was completely different than anticipated based on the error message. ## The Answer 15 4 people think this answer is useful This also happens when your password contains some special characters like @,$,etc. To avoid this situation you can wrap password in single quotes:

$mysql -usomeuser -p's0mep@$$w0Rd'  Or instead don’t use password while entering. Leave it blank and then type it when terminal asks. This is the recommended way. $ mysql -usomeuser -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 191
Server version: 5.5.46-0ubuntu0.14.04.2 (Ubuntu)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>



4 people think this answer is useful

For me, this problem was caused by a new feature of MySQL 5.7.2: user entries are ignored if their plugin field is empty.

Set it to e.g. mysql_native_password to reenable them:

UPDATE user SET plugin='mysql_native_password' WHERE user='foo';
FLUSH PRIVILEGES;



See the release notes for MySQL 5.7.2, under «Authentication Notes».

For some reason (maybe because my pre-4.1 password hashes were removed), the mysql_upgrade script didn’t set a default plugin value.

I found out by noticing the following warning message in /var/log/mysql/error.log:

[Warning] User entry ‘foo’@’%’ has an empty plugin value. The user will be ignored and no one can login with this user anymore.

I post this answer here to maybe save someone from using the same ridiculous amount of time on this as I did.

3 people think this answer is useful

Not sure if anyone else will find this helpful, but I encountered the same error and searched all over for any anonymous users…and there weren’t any. The problem ended up being that the user account was set to “Require SSL” – which I found in PHPMyAdmin by going to User Accounts and clicking on Edit Privileges for the user. As soon as I unchecked this option, everything worked as expected!

3 people think this answer is useful

Debugging Summary

• Check the host name and compare it with mysql.user table host name.
• Check user exists or not.
• Check whether host contains IP address or host name.

There is a great chance that, you might have encountered this issue multiple times in your work. This issue occurred to me most of times due to the incorrectly entering user name or password. Though this is one of the reasons, there are other many chances you might get this issue. Sometimes, it looks very similar, but when you dig deeper, you will realize multiple factors contributing to this error. This post will explain in detail, most of the common reasons and work around to fix this issue.

Possible reasons:

This is the most common reason for this error. If you entered the username or password wrongly, surely you will get this error.

Solution:

Solution for this type of error is very simple. Just enter the correct username and password. This error will be resolved. In case if you forget the password you can reset the username/password. If you forget the password for admin / root account, there are many ways to reset / recapture the root password. I will publish another post on how to reset the root password in-case if you forget root password.

• Case 2: Accessing from wrong host.

MySQL provides host based restriction for user access as a security features. In our production environment, we used to restrict the access request only to the Application servers. This feature is really helpful in many production scenarios.

Solution:

When you face this type of issue, first check whether your host is allowed or not by checking the mysql.user table. If it is not defined, you can update or insert new record to mysql.user table. Generally, accessing as a root user from remote machine is disabled and it is not a best practice, because of security concerns. If you have requirements to access your server from multiple machines, give access only to those machines. It is better not to use wildcards (%) and gives universal accesses. Let me update the mysql.user table, now the demouser can access MySQL server from any host.

• Case 3: User does not exists on the server.

This type of error occurs when the user, which you are trying to access not exist on the MySQL server.

Solutions:

When you face this type of issue, just check whether the user is exists in mysql.user table or not. If the record not exists, user cannot access. If there is a requirement for that user to access, create a new user with that username.

• Case 4: Mix of numeric and name based hosts.

Important points

• It is not advisable to use wildcards while defining user host, try to use the exact host name.

• Disable root login from remote machine.

• Use proxy user concept.

There are few other concepts related with this topic and getting into details of those topics is very different scope of this article. We will look into the following related topics in the upcoming articles.

• What to do, if you forgot root password in of MySQL server.
• MySQL Access privilege issues and user related tables.
• MySQL security features with best practices.

I hope this post will help for you to fix the MySQL Error Code 1045 Access denied for user in MySQL.

3 people think this answer is useful

I hope you have not done more damage by also deleting the debian-sys-maint user in mysql

Have your mysql daemon running the normal way. Start your mysql client as shown below

mysql -u debian-sys-maint -p



In another terminal, cat the file /etc/mysql/debian.cnf. That file contains a password; paste that password when prompted for it.

3 people think this answer is useful

I discovered yet another case that appears on the surface to be an edge case; I can export to the file system, via SELECT INTO .. OUTFILE as root, but not as regular user. While this may be a matter of permissions, I’ve looked at that, and see nothing especially obvious. All I can say is that executing the query as a regular user who has all permissions on the data base in question returns the access denied error that led me to this topic. When I found the transcript of a successful use of SELECT INTO … OUTFILE in an old project, I noticed that I was logged in as root. Sure enough, when I logged in as root, the query ran as expected.

3 people think this answer is useful

Update: On v8.0.15 (maybe this version) the PASSWORD() function does not work.

You have to:

1. Make sure you have Stopped MySQL first.
2. Run the server in safe mode with privilege bypass: sudo mysqld_safe --skip-grant-tables
3. Login: mysql -u root
4. mysql> UPDATE mysql.user SET authentication_string=null WHERE User='root';
5. mysql> FLUSH PRIVILEGES;
6. mysql> exit;
7. Login again: mysql -u root
8. mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

2 people think this answer is useful

2 people think this answer is useful

This may apply to very few people, but here goes. Don’t use an exclamation ! in your password.

I did and got the above error using MariaDB. When I simplified it to just numbers and letters it worked. Other characters such as @ and $ work fine – I used those characters in a different user on the same instance. The fifth response at this address led me to my fix. ## The Answer 24 2 people think this answer is useful Nowadays! Solution for : MySQL ERROR 1045 (28000): Access denied for user ‘user’@’localhost’ (using password: YES); Wampserver 3.2.0 new instalation or upgrading Probably xamp using mariaDB as default is well. Wamp server comes with mariaDB and mysql, and instaling mariaDB as default on 3306 port and mysql on 3307, port sometimes 3308. Connect to mysql! On instalation it asks to use mariaDB or MySql, But mariaDB is checked as default and you cant change it, check mysql option and install. when instalation done both will be runing mariaDB on default port 3306 and mysql on another port 3307 or 3308. Right click on wampserver icon where its runing should be on right bottom corner, goto tools and see your correct mysql runing port. And include it in your database connection same as folowng : $host = 'localhost';
$db = 'test';$user = 'root';
$pass = '';$charset = 'utf8mb4';
$port = '3308';//Port$dsn = "mysql:host=$host;dbname=$db;port=$port;charset=$charset"; //Add in connection
$options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ]; try {$pdo = new PDO($dsn,$user, $pass,$options);
} catch (\PDOException $e) { throw new \PDOException($e->getMessage(), (int)$e->getCode()); }  Note : I am using pdo. See here for more : https://sourceforge.net/projects/wampserver/ ## The Answer 25 0 people think this answer is useful When you run mysql -u bill -p, localhost is resolved to your ip, since it is 127.0.0.1 and in your /etc/hosts file, as default 127.0.0.1 localhost exists. So, mysql interprets you as bill@localhost which is not granted with bill@'%' . This is why there are 2 different records for root user in result of select host, user from mysql.user; query. There are two ways to handle this issue. One is specifying an ip which is not reversely resolved by /etc/hosts file when you try to login. For example, the ip of server is 10.0.0.2. When you run the command mysql -u bill -p -h 10.0.0.2, you will be able to login. If you type select user();, you will get bill@10.0.0.2. Of course, any domain name should not be resolved to this ip in your /etc/hosts file. Secondly, you need grant access for this specific domain name. For bill@localhost, you should call command grant all privileges on *.* to bill@localhost identified by 'billpass'; . In this case, you will be able to login with command mysql -u bill -p. Once logined, select user(); command returns bill@localhost. But this is only for that you try to login a mysql server in the same host. From remote hosts, mysql behaves expectedly, ‘%’ will grant you to login. ## The Answer 26 0 people think this answer is useful I resolved this by deleting the old buggy user ‘bill’ entries (this is the important part: both from mysql.user and mysql.db), then created the same user as sad before: FLUSH PRIVILEGES; CREATE USER bill@localhost IDENTIFIED BY 'passpass'; grant all privileges on *.* to bill@localhost with grant option; FLUSH PRIVILEGES;  Worked, user is connecting. Now I’ll remove some previlegies from it 🙂 ## The Answer 27 0 people think this answer is useful I encountered the same error. The setup that wasn’t working is as follows: define("HOSTNAME", "localhost"); define("HOSTUSER", "van"); define("HOSTPASS", "helsing"); define("DBNAME", "crossbow");$connection = mysqli_connect(HOSTNAME, HOSTUSER, HOSTPASS);



The edited setup below is the one that got it working. Notice the difference?

define('HOSTNAME', 'localhost');
define('HOSTUSER', 'van');
define('HOSTPASS', 'helsing');
define('DBNAME', 'crossbow');
$connection = mysqli_connect(HOSTNAME, HOSTUSER, HOSTPASS);  The difference is the double quotes. They seem to be quite significant in PHP as opposed to Java and they have an impact when it comes to escaping characters, setting up URLs and now, passing parameters to a function. They’re prettier (I know) but always use single quotes as much as possible then double quotes can be nested within those if necessary. This error came up when I tested my application on a Linux box as opposed to a Windows environment. ## The Answer 28 0 people think this answer is useful On Windows, here’s how to resolve: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO) 1. Uninstall mysql from the control panel 2. Delete the MySql folder from C:\Program Files,C:\Program Files (x86) and C:\ProgramData 3. Install mysql ## The Answer 29 0 people think this answer is useful This may also happen if MySQL is running on a case-insensitive OS, such as Windows. e.g. I found that attempting to connect to a database using these credentials failed: mysql> grant select on databaseV105.* to 'specialuser' identified by 's3curepa5wrd'; $ mysql -specialuser' -p's3curepa5wrd' -h10.61.130.89 databaseV105

But, this succeeded:

mysql> grant select on databasev105.* to 'specialuser' identified by 's3curepa5wrd';

\$ mysql -specialuser' -h10.300.300.400 databaseV105 -p