MySQL 1045 Acces denied

[patratel]

Hi,
I have xampp 1.8.1 on win xp sp3.
I got this error when I try to connect with mysql Client (cmd C:\xampp\mysql\bin\mysql -u root -p)
"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"
I can connect with "mysql -u root" (without password) but if I try something, I get access denied.

If I try "mysql -u root -p mysql", I get "ERROR 1049 (4200): Unknown database 'mysql'".
I can connect from phpMyAdmin, and I can do anything there. But in command prompt, when I tried mysqladmin flush privileges (or something else), it says "unknown command" or other errors.
I tried from SQL console in phpMyAdmin to add for root hosts 'root'@'localhost' , 'root'@'127.0.0.1' , 'root'@'::1', 'root'@'%'  with
CREATE USER 'root'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

For 127.0.0.1 I got "#1396 - Operation CREATE USER failed for 'root'@'127.0.0.1' ", for the others worked.

There are few days since I struggle with this thing, I can really use some help. Thanks.

[patratel]

Hi,
I've dropped XAMPP and I've installed Apache 2.4.4, PHP 5.4.16, MySQL 5.6 and phpMyAdmin 4.0.3 (after I formatted my pc ).
It seams it works fine for now, I'll test further, hope to be ok.
Thanks