root user password

[whatg]

Ok guys have spent hours looking for a solution!

I've just installed xampp and thought I'd log into mysql, just for the sake of doing so!

I type this 'mysql -u root -p" and it prompts me for a password, I enter it and then it says 'access denied for user root@localhost <using password : YES>'

I have modified the config.inc.php file so that the passwords are matching but doesn't seem to be working!

Also went through phpmyadmin to change the password for root user but that doesn't seem to be working either :(

Any help would be useful!

[whatg]

OK so I've figured out that I can log in as the pma account but still no luck with the root user :(

[120]

Have you set a root password when you installed it? If not, have you tried logging in without one?

mysql -u root

See this link:
http://www.apachefriends.org/en/faq-xampp-windows.html#password2

[whatg]

Ok, that was it! I hadn't set a password for it!

So now I'm in sql how do I set a password for root?


Thanks

[whatg]

Ok all sorted! :D Thanks for the help!