Search the Community
Showing results for tags 'mysql error 1045'.
Found 1 result
-
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.
