Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[Jouni Väliaho]

I have similar problem.
I am using mysql-5.5.14.
I did:
mysql -u root -p
mysql> use mysql;
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
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
Query OK, 0 rows affected (0.13 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

And :mysql> SELECT user, host, Grant_priv FROM mysql.user WHERE user = 'root' AND host = 'localhost';
+------+-----------+------------+
| user | host | Grant_priv |
+------+-----------+------------+
| root | localhost | Y |
+------+-----------+------------+
1 row in set (0.00 sec)